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
Bennie Schut 2010-09-21, 10:18
Hi,

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.

Bennie.

-----Original Message-----
From: Adarsh Sharma [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 21, 2010 11:52 AM
To: [EMAIL PROTECTED]
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:
jdbc:hive://192.168.0.173:10000/default
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
file=/tmp/root/hive_job_log_root_201009211518_1489326085.txt
10/09/21 15:18:26 WARN cfg.SettingsFactory: Could not obtain connection
metadata
java.sql.SQLException: Method not supported
    at
org.apache.hadoop.hive.jdbc.HiveConnection.getAutoCommit(HiveConnection.java:201)
    at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112)
    at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
    at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1823)
    at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1143)
    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

Thanks