I am trying to create a Hive table using a csv file which I have already stored in the hdfs. I am running the following command to do this:
CREATE EXTERNAL TABLE student (studentId String , email String, class String)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
When i run this, I am getting the following error:
MetaException(message:hdfs://PC:8020/user/hadoop/student/student_data.csv is not a directory or unable to create one)