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 would imagine you need to sqoop in again, after you correct this. HTH, Tim On Wed, Apr 18, 2012 at 5:29 AM, Đỗ Hoàng Khiêm <dohoangkh...@gmail.com>wrote: > 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 > tables) while it's still able to create new tables. I have checked in HDFS, > these table files still existed at /user/hive/warehouse/. > > When start hive shell then try to show tables, the hive log printed out: > > 2012-04-18 10:25:11,412 WARN conf.HiveConf (HiveConf.java:<clinit>(68)) - > hive-site.xml not found on CLASSPATH > 2012-04-18 10:25:43,239 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.resources" but it cannot be resolved. > 2012-04-18 10:25:43,239 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.resources" but it cannot be resolved. > 2012-04-18 10:25:43,240 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.runtime" but it cannot be resolved. > 2012-04-18 10:25:43,240 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.core.runtime" but it cannot be resolved. > 2012-04-18 10:25:43,240 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.text" but it cannot be resolved. > 2012-04-18 10:25:43,240 ERROR DataNucleus.Plugin > (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires > "org.eclipse.text" but it cannot be resolved. > > How can I recover these table? > > Thanks. > > >
