title: How can I solve the error "file:/user/hive/warehouse/records is not a directory or unable to create one"?
body: <pre><code>hive&gt; CREATE TABLE records (year STRING, temperature INT, quality INT)
      &gt; ROW FORMAT DELIMITED
      &gt;   FIELDS TERMINATED BY '\t';
  FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:file:/user/hive/warehouse/records is not a directory or unable to create one)
  </code></pre>
  
  <p>How can I solve the error?</p>
  
  <p>where is <code>/user/hive/warehouse/</code> located? In my local ext4 filesystems under Ubuntu, there is no <code>/user/hive/warehouse/</code> such a path.</p>
  
  <p>How can I get information about i.e. examine <code>/user/hive/warehouse/</code>?</p>