Bhavesh It is SQOOP related question hence moving to the SQOOP user group with hive user group in cc.
Did you do your SQOOP import by specifying --hive-import ? If hive table creation still doesn't seem to work,execute the SQOOP command with --verbose and scan the logs to see what is happening after the hdfs import. You can paste the relevant parts of the log here. Regards Bejoy.K.S ________________________________ From: Bhavesh Shah <bhavesh25s...@gmail.com> To: user@hive.apache.org; d...@hive.apache.org Sent: Thursday, February 2, 2012 5:16 PM Subject: Table not creating in hive Hello all, After successfully importing the tables in hive I am not able to see the table in Hive. When I imported the table I saw the dir on HDFS (under /user/hive/warehouse/) but when I execute command in Hive "SHOW TABLES" the table is not in the list. I find a lot about it but not getting anything. Pls suggest me some solution for it. -- Thanks and Regards, Bhavesh Shah