31、一张大表A(上亿条记录)和小表B(几千条记录),如果join出现数据倾斜,有什么解决办法?
略
32、有如下三张表:
表login_a(登录表):
ds user_id 2019-08-06 1 2019-08-06 2 2019-08-06 3 2019-08-06 4 create table login_a( ds date, user_id int ) row format delimited fields terminated by ' '; load data local inpath './hivedata/login_a.txt' overwrite into table login_a;
表read_b(阅读表):
ds user_id read_num 2019-08-06 1 2 2019-08-06 2 3 2019-08-06 3 6 create table read_b( ds date, user_id int, read_num int ) row format delimited fields terminated by ' '; load data local inpath './hivedata/read_b.txt' overwrite into table read_b;
表cost_c(付费表):
ds user_id price 2019-08-06 1 55.6 2019-08-06 2 55.8 create table cost_c( ds date, user_id int, price float ) row format delimited fields terminated by ' '; lo