Hi
you'd better
hive> add derby.jar ;
before exec your sql
2011/8/18 wd
> The error in log is 'java.lang.ClassNotFoundException:
> org.postgresql.Driver', not can't connect or user name or password error.
>
>
> On Wed, Aug 17, 2011 at 3:53 PM, Jander g wrote:
>
>> Hi,wd
>>
>> You should confi
Hi,
I solved this by placing the jar in ${java_home}/jre/lib and
${java_home}/jre/lib/ext . This is the workaround whenever jdbc drivers wont
work. The same thing worked here too. (I hope it works with your postgres
too). I am still wondering why hive didn't recognize it in the classpath.
Also th
Maybe you should use
'hive.stats.jdbcdriver="org.apache.mysql.jdbc.EmbeddedDriver"'
settings?
via
http://mail-archives.apache.org/mod_mbox/hive-user/201103.mbox/%3c42360b00-72ec-437a-9d95-93f3ad9f1...@fb.com%3E
On Fri, Aug 19, 2011 at 5:45 AM, bharath vissapragada <
bharathvissapragada1...@gmail.
Hi,
Iam also getting the same error. However I am using mysql for stats.
The thing is I configured mysql for metastore and it works fine and all the
metadata gets populated normally. When the metastore classes can find the
mysql jar in the class path , why cant the stats publisher find it. I look
The error in log is 'java.lang.ClassNotFoundException:
org.postgresql.Driver', not can't connect or user name or password error.
On Wed, Aug 17, 2011 at 3:53 PM, Jander g wrote:
> Hi,wd
>
> You should configure "hive.stats.dbconnectionstring" as follows.
>
>
>
> hive.stats.dbconnectionstring
>
Hi,wd
You should configure "hive.stats.dbconnectionstring" as follows.
hive.stats.dbconnectionstring
jdbc:postgresql://localhost/hive_statsdb?createDatabaseIfNotExist=true&user=hive&password=pwd
The default connection string for the database that
stores temporary hive statistics.
Regards,
HBase Publisher/Aggregator classes cannot be loaded.
need to configure publisher/aggregator for hbase...there is only one
way, that is use mysql ..
does stats database will optimize hive query? Consider whether or not
setup a mysql for this.
On Mon, Aug 15, 2011 at 3:17 PM, wd wrote:
> oh, foun
oh, found hive only support mysql and hbase. I'll try hbase.
On Mon, Aug 15, 2011 at 3:09 PM, wd wrote:
> hi,
>
> I'm try to use postgres as stats database. And made following settings
> in hive-site.xml
>
>
>
> hive.stats.dbclass
> jdbc:postgresql
> The default database that stores temporary
hi,
I'm try to use postgres as stats database. And made following settings
in hive-site.xml
hive.stats.dbclass
jdbc:postgresql
The default database that stores temporary hive
statistics.
hive.stats.autogather
true
A flag to gather statistics automatically during the
INSERT OVERWR
