title: Hive External table in MySQL
body: <p>Currently, I’m executing the following steps(Hadoop 1.1.2, Hive 0.11 and Sqoop-1.4.3.bin__hadoop-1.0.0) :</p>
  
  <ol>
  <li>Import data from MySQL to Hive using Sqoop</li>
  <li>Execute a query in Hive and store its output in a Hive table</li>
  <li>Export the output to MySQL using Sqoop</li>
  </ol>
  
  <p>I was wondering if it would be possible to combine steps 2 &amp; 3 – the output of the Hive query written directly to the MySQL database. </p>
  
  <ol>
  <li>I read about the external tables but couldn’t find an example where the LOCATION clause points to something like jdbc:myql://localhost:3306//. Is it really possible?</li>
  <li><a href="https://stackoverflow.com/questions/11958529/how-to-move-hive-data-table-to-mysql">This</a> thread talks about the JDBC Storage Handler but couldn't find a Hive example for the same(I guess its unimplemented!)</li>
  </ol>