title: Unable to Create Table in HIVE reading a CSV from HDFS
body: <p>I have issues while creating a table in Hive by reading the .csv file from HDFS. The Query is below:</p>
  
  <pre><code>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';
  </code></pre>
  
  <p>Error getting. 
  Error in metadata: </p>
  
  <blockquote>
    <p>MetaException(message:hdfs://PC:8020/user/hadoop/cloudera/ameeth/ca_email.csv
    is not a directory or unable to create one)</p>
  </blockquote>
  
  <p>Can any one help me in this. Actually I want to run such staments in a .sql file as a job</p>