06-13-2017 08:34 PM
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
06-14-2017 01:28 AM - edited 06-14-2017 01:28 AM
Try switching databases before asking for the tables list.
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.
06-15-2017 02:18 PM