title: Hive error when creating an external table (state=08S01,code=1)
body: <p>I'm trying to create an external table in Hive, but keep getting the following error:</p>
  
  <pre><code>create external table foobar (a STRING, b STRING) row format delimited fields terminated by "\t" stored as textfile location "/tmp/hive_test_1375711405.45852.txt";
  Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=08S01,code=1)
  Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=08S01,code=1)
  Aborting command set because "force" is false and command failed: "create external table foobar (a STRING, b STRING) row format delimited fields terminated by "\t" stored as textfile location "/tmp/hive_test_1375711405.45852.txt";"
  </code></pre>
  
  <p>The contents of <code>/tmp/hive_test_1375711405.45852.txt</code> are:</p>
  
  <pre><code>abc\tdef
  </code></pre>
  
  <p>I'm connecting via the <code>beeline</code> command line interface, which uses Thrift <code>HiveServer2</code>.</p>
  
  <p>System:</p>
  
  <ul>
  <li>Hadoop 2.0.0-cdh4.3.0</li>
  <li>Hive 0.10.0-cdh4.3.0</li>
  <li>Beeline 0.10.0-cdh4.3.0</li>
  <li>Client OS - Red Hat Enterprise Linux Server release 6.4 (Santiago)</li>
  </ul>