Error Hive show tables does not display table sqooptest which was imported by SQOOP

Question

hive> show tables tablename I have imported MySQL to HVE using SQOOP, once it done I can able to see from Hadoop File System(HDFS), but When I use "show tables tablname" from HIVE console, it throws no table exists.

Can anyone tell how to solve this?

Answer 1

Hi,

You can follow the below-given solution.

Just enter into hiveQL from where you used the sqoop import commands.

bin# cd /opt 

[opt]#$SQOOP_HOME/bin/sqoop import --connect jdbc:mysql://localhost:3306/hadoop --table huser --hive-import --split-by name --hive-table sqooptest -username root -P

Execute hive from /opt, if you are trying to enter other-then this dir, you will not able to view 

[opt]#$HIVE_HOME/bin/hive hive> show tables tablename

By default HIVE metadata stored in derby database. Derby store the data into current working dir. That can be customized by user "hive-default.xml"