通过从HDFS读取.csv文件在Hive中创建表时遇到问题.查询如下:
CREATE EXTERNAL TABLE testmail (memberId String , email String, sentdate String,actiontype String, actiondate String, campaignid String,campaignname String) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/user/hadoop/cloudera/ameeth/ca_email.csv';
得到错误.元数据错误:
MetaException(消息:hdfs:// PC:8020/user/hadoop/cloudera/ameeth/ca_email.csv不是目录或无法创建目录)
任何人都可以帮助我.实际上我想在.sql文件中运行这样的staments作为工作
Hive会获取您在LOCATION中指定的目录中的所有文件.您无需指定文件名.
这应该工作:
CREATE EXTERNAL TABLE testmail (memberId String , email String, sentdate String,actiontype String, actiondate String, campaignid String,campaignname String) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/user/hadoop/cloudera/ameeth';