Failed to create table in HIVE reading CSV from HDFS

Question

I'm having trouble creating a table in Hive while reading a CSV file from HDFS. Request below:

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'; 

Error receiving. Error in metadata:

MetaException (message: HDFS: // PC: 8020 / user / Hadoop / Cloudera / ameeth / ca_email.csv is not a directory or cannot create it)

Can anyone help me on this. Actually I want to run such elements in a .sql file as a job

Answer 1

Hive collects all files in the directory specified by LOCATION. You do not need to specify a file name.

This should work:

 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'; 

Answer 2

go to this way

find your metastore_db folder in cloudera and delete the * .lck files.

sudo rm / folder_path / metastore_db / * command. lck

Answer 3

Create a directory on HDFS and move the ca_email.csv file into it, then specify this directory as the LOCATION of your CREATE EXTERNAL TABLE command.