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.