如果文本中含有多余的空白行,则通过
load data local inpath 'waybill_code.txt' overwrite into table waybill_code_table_0116;
导入到表中后,表中会存在NULL的字段值。
如下:
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
Time taken: 0.433 seconds, Fetched: 719723 row(s)
hive> select current_database();
OK
default
Time taken: 1.0 seconds, Fetched: 1 row(s)
hive> select count(*) from default.waybill_code_table_0116 ;
719723
Time taken: 42.5 seconds, Fetched: 1 row(s)
hive> select count(*) from default.waybill_code_table_0116 and waybill_code is not null;
228922
Time taken: 42.375 seconds, Fetched: 1 row(s)
hive>