1、直接用命令
這種要把文件先傳上去
[root@cdh01 ~]# ll |grep test
-rw-r--r-- 1 root root 527 May 9 13:47 test.txt
[root@cdh01 ~]# cat test.txt
{"name":"testName1", "age":21}
{"name":"testName2", "age":22}
{"name":"testName3", "age":23}
{"name":"testName4", "age":24}
{"name":"testName5", "age":25}
{"name":"testName6", "age":26}
{"name":"testName7", "age":27}
{"name":"testName8", "age":28}
{"name":"testName9", "age":29}
{"name":"testName10","age":30}
{"name":"testName11","age":31}
{"name":"testName12","age":32}
{"name":"testName13","age":33}
{"name":"testName14","age":34}
{"name":"testName15","age":35}
{"name":"testName16","age":36}
{"name":"testName17","age":37}
[root@cdh01 ~]#hadoop fs -put /root/test.txt /user/test.txt
#需要注意的是操作的目錄是需要獲取權(quán)限，比如/user/hive 則是用戶hive操目錄，沒(méi)有授權(quán)的情況下root也不可操作
[root@cdh01 ~]# hadoop fs -cat /user/test.txt
{"name":"testName1", "age":21}
{"name":"testName2", "age":22}
{"name":"testName3", "age":23}
{"name":"testName4", "age":24}
{"name":"testName5", "age":25}
{"name":"testName6", "age":26}
{"name":"testName7", "age":27}
{"name":"testName8", "age":28}
{"name":"testName9", "age":29}
順便把數(shù)據(jù)加載到hive
建表（基于json）
CREATE TABLE test_table(name string, age int)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
STORED AS TEXTFILE;
#這里的路徑是HDFS的文件路徑
load data inpath '/user/test.txt' into table test_table;
image.png
image.png
查詢結(jié)果看看
image.png
load之后，原文件被移動(dòng)到數(shù)據(jù)庫(kù)下
image.png
