New Contributor
Posts: 5
Registered: ‎06-13-2017

problem with HIVE


Hello everyone,


i am new to this forum i wish i can get the answer for my question 


i sqoop the tables from mysql to HIVE under this path 

/user/hive/warehouse/retail_db.db. tables are created under retail_db database , i am able to see these.


using Hive shell , i entered the command show tables 

 but i dont see these tables 

can any one help me with this 




New Contributor
Posts: 3
Registered: ‎06-13-2017

Re: problem with HIVE

[ Edited ]

Try switching databases before asking for the tables list.


"use <databasename>;"

"show tables;"


My guess is that you are connected to the default database "default" and the "show tables;" command list the tables of that database and not yours.




New Contributor
Posts: 5
Registered: ‎06-13-2017

Re: problem with HIVE

i use the database name i ran show tables; command but no luck
Posts: 642
Topics: 3
Kudos: 121
Solutions: 67
Registered: ‎08-16-2016

Re: problem with HIVE

Did you use the sqoop switches to move it into HDFS at that location or did you tell it to move it into hive, specific db, table, and schema mapping (if needed)?

My suspicion is that you just imported the data into the Hive warehouse directory in HDFS. Without the schema nothing will show up in Hive. You can create this manually now, no need to do it through sqoop since the data is already there.