HDFS文件路径:/user/test/qar_test.txt
文件格式:***,***,***
创建hive表:
create table test_load(type STRING,num INT,time STRING)
partitioned by(name STRING) //分区
row format delimited
fields terminated by ',' //以逗号分隔
stored as TEXTFILE
导入HDFS文件数据:
load data inpath 'hdfs://Master:9000/user/test/qar_test'
into table test_load
partition (name=‘MH');
报错:
FAILED: SemanticException Line 1:17 Invalid path ''hdfs://Master:9000/user/test/qar_test'': No files matching path hdfs://Master:9000/user/test/qar_test
路径不对,这个就很奇怪了。我再查询MySQL数据库(我的hive元数据放在MySQL数据库中,其它方法类似)。
查询hive下的DBS表DB_LOCATION_URI列:select DB_LOCATION_URI from DBS;
+----------------------------------------+
| DB_LOCATION_URI |
+----------------