title: Creating External Table in Hive using HIVE JDBC : Not Possible?
body: <p>External Table creation via <code>HIVE JDBC</code> isnt reflected in the hive datawarehouse whereas the normal table creation inside the hive datawarehouse happens without any issue.</p>
  
  <p>After creating the table via Hive JDBC,   </p>
  
  <pre><code>stmt.executeQuery("create external table trial (TOPIC STRING) row format delimited fields terminated by '' STORED as TEXTFILE LOCATION '/user/ranjitha/trial'");`
  </code></pre>
  
  <p>no error returned.</p>
  
  <p>But when I try retrieving from this table trial, nothing is returned.</p>
  
  <p>Here in this link, <a href="https://groups.google.com/a/cloudera.org/forum/?fromgroups#!topic/cdh-user/YTekdFtbelE" rel="nofollow">https://groups.google.com/a/cloudera.org/forum/?fromgroups#!topic/cdh-user/YTekdFtbelE</a>, it says external table creation not possible using <code>HIVE JDBC</code>.</p>
  
  <p>It would be really helpful if someone can guide me on the above. Is this not possible with JDBC or is there another alternative for the same.</p>
  
  <p>Thanks</p>