The litthrift.jar under hadoop/contrib may be the cause of the problem. The multiple libthrift.jar or libfb303.jar files are OK: hive/lib/libthrift.jar should be the same as build/dist/lib/libthrift.jar. What's important is that there is one copy under build/dist which is the Hive installation directory. We probably should remove all the other jar files in hadoop*/src/contrib.
BTW, have you tested TestJdbcDriver without -Dstandalone=true? If so did that pass? Thanks, Ning On Feb 22, 2010, at 2:35 PM, Something Something wrote: Thanks for looking into this issue. There was a libthrift.jar in the hadoop/contrib but I removed that. The libfb303.jar wasn't in Hadoop. Under Hive, though, it's in 6 different places: train...@training-vm:~$ find . -name 'libthrift.jar' ./hive/build/dist/lib/libthrift.jar ./hive/build/hadoopcore/hadoop-0.19.0/src/contrib/hive/lib/libthrift.jar ./hive/build/hadoopcore/hadoop-0.19.0/src/contrib/thriftfs/lib/libthrift.jar ./hive/build/hadoopcore/hadoop-0.19.0/contrib/hive/lib/libthrift.jar ./hive/build/hadoopcore/hadoop-0.20.0/src/contrib/thriftfs/lib/libthrift.jar ./hive/lib/libthrift.jar and libfb303.jar is in 4 places: train...@training-vm:~$ find . -name 'libfb303.jar' ./hive/build/dist/lib/libfb303.jar ./hive/build/hadoopcore/hadoop-0.19.0/src/contrib/hive/lib/libfb303.jar ./hive/build/hadoopcore/hadoop-0.19.0/contrib/hive/lib/libfb303.jar ./hive/lib/libfb303.jar I have Hadoop running from outside Hive, from directory, /home/training/hadoop-0.20.1 (because I had it installed previously). Is that okay? On Mon, Feb 22, 2010 at 2:15 PM, Ning Zhang <[email protected]<mailto:[email protected]>> wrote: I ran into a different error when running Jdbc test on standalone mode. I'm looking into that issue. It seems your error is due to thrift connection. Can you double check if you have another version of libthrift.jar or libfb303.jar in your classpath? This could be true if you have these two jars in your hadoop's lib directory. Thanks, Ning On Feb 22, 2010, at 12:50 PM, Something Something wrote: I used this command: svn co http://svn.apache.org/repos/asf/hadoop/hive/trunk hive So, AFAIK I got it from trunk around Sat, Feb 20, 2010 at 4:00 PM PST. I also tried http://svn.apache.org/repos/asf/hadoop/hive/tags/release-0.5.0-rc1/ yesterday (Sunday afternoon), but ran into the same issue. I have HIVE_HOME set to /home/training/hive, so I am running both commands from hive's root (installation) directory. I am not getting the error message that you are getting. It could be because I made the changes suggested by Vidyasagar in this email thread: http://www.mail-archive.com/[email protected]/msg02535.html Greatly appreciate your help with this. If I can't access Hive from a Java program I can't really use Hive so I am stuck at this point (unless of course I fire up the IDE and start debugging the Thrift code). On Mon, Feb 22, 2010 at 12:05 PM, Carl Steinbach <[email protected]<mailto:[email protected]>> wrote: Hey, I tried running the test on trunk and ran into this issue: http://issues.apache.org/jira/browse/HIVE-1188 Since you appear to be getting a little farther along than this I doubt that you are actually running the test on trunk (though it's possible that you are running on an older copy of trunk). When was the last time you updated your svn workspace? Also, which directory were you in when you ran "bin/hive --service hiveserver" and "ant test -Dtestcase=TestJdbcDriver"? Thanks. Carl On Sun, Feb 21, 2010 at 11:29 AM, Something Something <[email protected]<mailto:[email protected]>> wrote: I am following instructions on 'Getting Started' (http://wiki.apache.org/hadoop/Hive/GettingStarted), so I am getting from the trunk. No error messages in Hiveserver log. This is what I see: 10/02/21 11:25:16 INFO ql.Driver: OK 10/02/21 11:25:16 INFO service.HiveServer: Running the query: drop table testHiveDriverTable 10/02/21 11:25:16 INFO ql.Driver: Starting command: drop table testHiveDriverTable 10/02/21 11:25:16 INFO parse.ParseDriver: Parsing command: drop table testHiveDriverTable 10/02/21 11:25:16 INFO parse.ParseDriver: Parse Completed 10/02/21 11:25:16 INFO ql.Driver: Semantic Analysis Completed 10/02/21 11:25:16 INFO metastore.HiveMetaStore: 9: drop_table : db=default tbl=testHiveDriverTable 10/02/21 11:25:16 INFO metastore.HiveMetaStore: 9: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 10/02/21 11:25:16 INFO metastore.ObjectStore: ObjectStore, initialize called 10/02/21 11:25:16 INFO metastore.ObjectStore: Initialized ObjectStore 10/02/21 11:25:16 INFO metastore.HiveMetaStore: 9: get_table : db=default tbl=testHiveDriverTable 10/02/21 11:25:16 INFO metastore.warehouse: deleting hdfs://localhost:9000/user/hive/warehouse/testhivedrivertable 10/02/21 11:25:16 INFO metastore.warehouse: Deleted the diretory hdfs://localhost:9000/user/hive/warehouse/testhivedrivertable OK 10/02/21 11:25:16 INFO ql.Driver: OK 10/02/21 11:25:16 INFO service.HiveServer: Running the query: create table testHiveDriverTable (key int, value string) 10/02/21 11:25:16 INFO ql.Driver: Starting command: create table testHiveDriverTable (key int, value string) 10/02/21 11:25:17 INFO parse.ParseDriver: Parsing command: create table testHiveDriverTable (key int, value string) 10/02/21 11:25:17 INFO parse.ParseDriver: Parse Completed 10/02/21 11:25:17 INFO parse.DDLSemanticAnalyzer: Creating tabletestHiveDriverTable 10/02/21 11:25:17 INFO ql.Driver: Semantic Analysis Completed 10/02/21 11:25:17 INFO exec.DDLTask: Default to LazySimpleSerDe for table testHiveDriverTable 10/02/21 11:25:17 INFO hive.log: DDL: struct testHiveDriverTable { i32 key, string value} 10/02/21 11:25:17 INFO metastore.HiveMetaStore: 9: create_table: db=default tbl=testHiveDriverTable 10/02/21 11:25:17 INFO metastore.HiveMetaStore: 9: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 10/02/21 11:25:17 INFO metastore.ObjectStore: ObjectStore, initialize called 10/02/21 11:25:17 INFO metastore.ObjectStore: Initialized ObjectStore 10/02/21 11:25:17 INFO metastore.HiveMetaStore: 9: get_table : db=default tbl=testHiveDriverTable OK 10/02/21 11:25:17 INFO ql.Driver: OK On Sat, Feb 20, 2010 at 11:01 PM, Carl Steinbach <[email protected]<mailto:[email protected]>> wrote: Which version of Hive are you using? Also, what does the log output of the HiveServer process look like? Thanks. Carl On Sat, Feb 20, 2010 at 4:36 PM, Something Something <[email protected]<mailto:[email protected]>> wrote: I started HiveServer for the first time using instructions from the following page: http://wiki.apache.org/hadoop/Hive/HiveServer 1) bin/hive --service hiveserver 2) ant test -Dtestcase=TestJdbcDriver -Dstandalone=true Getting this error: org.apache.thrift.TApplicationException: Invalid method name: 'getThriftSchema' [junit] at org.apache.thrift.TApplicationException.read(TApplicationException.java:107) [junit] at org.apache.hadoop.hive.service.ThriftHive$Client.recv_getThriftSchema(ThriftHive.java:247) [junit] at org.apache.hadoop.hive.service.ThriftHive$Client.getThriftSchema(ThriftHive.java:231) [junit] at org.apache.hadoop.hive.jdbc.HiveResultSet.initDynamicSerde(HiveResultSet.java:90) [junit] at org.apache.hadoop.hive.jdbc.HiveResultSet.<init>(HiveResultSet.java:77) [junit] at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:201) [junit] at org.apache.hadoop.hive.jdbc.TestJdbcDriver.setUp(TestJdbcDriver.java:81) [junit] at junit.framework.TestCase.runBare(TestCase.java:125) [junit] at junit.framework.TestResult$1.protect(TestResult.java:106) [junit] at junit.framework.TestResult.runProtected(TestResult.java:124) [junit] at junit.framework.TestResult.run(TestResult.java:109) [junit] at junit.framework.TestCase.run(TestCase.java:118) [junit] at junit.framework.TestSuite.runTest(TestSuite.java:208) [junit] at junit.framework.TestSuite.run(TestSuite.java:203) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:420) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:911) [junit] at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:768) [junit] Tests run: 9, Failures: 0, Errors: 9, Time elapsed: 3.867 sec [junit] Test org.apache.hadoop.hive.jdbc.TestJdbcDriver FAILED I am looking into it, but if you know why this is happening please let me know. Thanks.
