mysql - Hive - No table is listing after successful Sqoop import -


After successfully importing honeycomb using Sqoop , I recently imported table hive .

Import Command

  ./sqoop Import - Connect jdbc: mysql: // localhost: 3306 / Extedu --table User - Users Name TALHA-P --warehouse-dir / home / talha / warehouse - directly   

hive tables

  hive & gt; ; Show the table; Time taken: 0.038 seconds  

This is a common problem with the hive, set the following property hive-site. In Xml

  & lt; Property & gt; & Lt; Name & gt; Javax.jdo.option.ConnectionURL & lt; / Name & gt; & Lt; Price & gt; JDBC: Derby: DatabaseName = metastore_db; Create = true & lt; / Pricing & gt; & Lt; Details & gt; JDBC Connect String for JDBC Metastore & lt; / Description & gt; & Lt; / Property & gt;   
  & lt; Property & gt; Provide some complete path instead of   

. & Lt; Name & gt; Javax.jdo.option.ConnectionURL & lt; / Name & gt; & Lt; Price & gt; JDBC: Derby: DatabaseName = ** / home / user / hive / metastore_db **; / Pricing & gt; = Create true & lt; & Lt; Details & gt; JDBC Connect String for JDBC Metastore & lt; / Description & gt; & Lt; / Property & gt;

Then check. Hope this will work

Comments

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

ios - Replace text in UITextView run slowly -