导入数据到hive的几种方式

–创建hive表
CREATE TABLE test(
id string,
name string)
ROW FORMAT SERDE
‘org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe’
WITH SERDEPROPERTIES (
‘field.delim’=‘|’,
‘line.delim’=‘\n’,
‘serialization.format’=‘|’)
STORED AS INPUTFORMAT
‘org.apache.hadoop.mapred.TextInputFormat’
OUTPUTFORMAT
‘org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat’
LOCATION
‘hdfs://hacluster/user/hive/warehouse/test/test’
TBLPROPERTIES (
‘bucketing_version’=‘2’,
‘transient_lastDdlTime’=‘1715822045’)
;

–查询hive表
select * from test;
±---------±-----------+
| test.id | test.name |
±---------±-----------+
±---------±-----------+
No rows selected (0.623 seconds)

1.load导入
cat test.txt
1|one
2|two

load data local inpath ‘/tpdata/ypg/shell/work/work06