摘要: create table person( name string, station string ) row format delimited fields terminated by '\t' lines terminated by '\n' stored as textfile; load data local inpath 'person.txt' into table person; ... 阅读全文
posted @ 2019-05-10 08:04 lilixia 阅读(177) 评论(0) 推荐(0) 编辑
摘要: set hive.auto.convert.join=true自动将join转换为map端的join set hive.mapjoin.smalltable.filesize=25000000;小于25M的都是小表 阅读全文
posted @ 2019-05-10 07:30 lilixia 阅读(201) 评论(0) 推荐(0) 编辑