Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Error while fetching Hive Metadata

Copy link to this message
RE: Error while fetching Hive Metadata

Not all jdbc calls are implemented. This would be one of them. I don't think anyone tried to use hibernate with hive before, probably because it's highly unlikely to work at this time since it will produce sql which might not be understood by hive. In most cases you want a pretty fine grain of control over the queries you send to hive (or any other dwh system) for performance reasons so I don't think it's something people are actively working on.

As an alternative you might want to look at the apache commons dbcp for connection pooling. We used it for a while but stopped using it because of some out of PermGen issues (which probably was unrelated). We combined this with Spring Templates to make using it pretty simple in our code.


-----Original Message-----
From: Adarsh Sharma [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 21, 2010 11:52 AM
Subject: Error while fetching Hive Metadata
Hi all,
Did anyone encounter with the  following error while fetching meta data
of Hive.

10/09/21 15:18:26 INFO connection.DriverManagerConnectionProvider: Using
Hibernate built-in connection pool (not for production use!)
10/09/21 15:18:26 INFO connection.DriverManagerConnectionProvider:
Hibernate connection pool size: 10
10/09/21 15:18:26 INFO connection.DriverManagerConnectionProvider:
autocommit mode: false
10/09/21 15:18:26 INFO connection.DriverManagerConnectionProvider: using
driver: org.apache.hadoop.hive.jdbc.HiveDriver at URL:
10/09/21 15:18:26 INFO connection.DriverManagerConnectionProvider:
connection properties: {user=hadoop, password=****}
Hive history file=/tmp/root/hive_job_log_root_201009211518_1489326085.txt
10/09/21 15:18:26 INFO exec.HiveHistory: Hive history
10/09/21 15:18:26 WARN cfg.SettingsFactory: Could not obtain connection
java.sql.SQLException: Method not supported
    at SelectClauseExample.main(SelectClauseExample.java:20)

I want to use Hive Metadata. can someone Please help me.
I use Hadoop-0.20.2 and Hive 0.7 trunk