试试看

use tmp_products;
drop table if exists tmp_products.orderid_201011051110;
create table tmp_products.orderid_201011051110
 
(
   orderid string comment '',
 
   period string comment ''
 )
 ROW FORMAT DELIMITED FIELDS TERMINATED by '\t'
 STORED AS TEXTFILE
 tblproperties('skip.header.line.count'='1');                                        #忽略第一行
 LOAD DATA LOCAL inpath 'orderid.txt' overwrite into table tmp_products.orderid_201011051110;
————————————————
版权声明：本文为CSDN博主「PersephoneSu」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/qq_34019697/article/details/109508287