Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-04-09 Thread Abhishek Parolkar
I was using Postgres from Heroku which imposes SSL connection, I finally got it working with query like this === --- set mapred.job.tracker=local; add jar /location/to/lib/hive-contrib-0.8.1.jar; add jar /location/to/lib/postgresql9jdbc3.jar; set jdbc.drivers = org.postgresql.D

Hive & json

2012-04-09 Thread Flinkster
Hi there, What's the best practice to read json data with Hive? select get_json_object? Or hive-json-serde.jar? Thanks, -ari

Re: hive trunk (0.9.0) with CDH3u3 - JAR issue?

2012-04-09 Thread Neil Yalowitz
Solved. This required a rebuild of the hbase-handlers JAR file. To review the versions I'm using: HBase: 0.90.4-cdh3u3 Hadoop: 0.20.2-cdh3u3 Hive: 0.9.0 (trunk as of Apr 6, 2012) Edited the HBase version in: ivy/libraries.properties ...and set... hbase.version=0.90.4 ...and then: ant packa

Re: Getting CNF during map reduce execution

2012-04-09 Thread buddhika chamith
Hi, Sorry I forgot to mention the versions. I am running Hive 0.8.1 and Hadoop 0.20.203.0. Shashwat's suggestion worked :). (I dropped hive-exec to hadoop lib). Thanks. Anyway I am curious how this happened since with hive running standalone (i mean not inside OSGi) this issue didn't come up. May