Re: Hive can't find some tables

2012-04-18 Thread Tim Robertson
It sounds like you have run Sqoop without specifying a durable metastore for Hive. E.g. you haven't told Hive to use MySQL, PostGRES etc to store it's metadata. It probably used Derby DB which either put it all in memory, or put it all on the /tmp directory, which was destroyed on restart. I wou

Hive can't find some tables

2012-04-17 Thread Đỗ Hoàng Khiêm
HI, I have some problems with Hive, looks like Hive cannot read some of my tables which was imported before by Sqoop. After importing from Sqoop it's still able to read/query from these tables, but after I restarted machine, Hive cannot find these tables anymore (as *show tables* didn't list these