mysql - Hive - No table is listing after successful Sqoop import -
After successfully importing honeycomb using Sqoop , I recently imported table hive .
hive tables This is a common problem with the hive, set the following property hive-site. In Xml . & 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 Import Command
./sqoop Import - Connect jdbc: mysql: // localhost: 3306 / Extedu --table User - Users Name TALHA-P --warehouse-dir / home / talha / warehouse - directly
hive & gt; ; Show the table; Time taken: 0.038 seconds
& 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
Comments
Post a Comment