Re: Errors in hive queries

2011-04-27 Thread vipul sharma
This got resolved. Some of the clients were not upgraded to CHD3 and were running old version. On Wed, Apr 27, 2011 at 2:27 PM, vipul sharma wrote: > We have a hadoop/hive cluster which is using cloudera's distribution. > Metastore is stored in mysql and all the relevant drivers are i

Errors in hive queries

2011-04-27 Thread vipul sharma
astore but I cant figure out whats wrong. The way we run query is via a remote client. Any help is greatly appreciated! -- Vipul Sharma sharmavipul AT gmail DOT com

unable to get histogram from hive table

2011-02-07 Thread vipul sharma
I had been trying to get histogram_numeric from a hive table with numeric column but getting an invalid function error. Documentation has this function listed and I dont think that this function is deprecated. Appreciate your help in figuring this out. hive -hiveconf hive.root.logger=INFO,console

Re: Problem starting Hive with local metastore on mysql

2011-01-19 Thread vipul sharma
Yup. Thanks for you help J-D, much appreciated! On Wed, Jan 19, 2011 at 4:41 PM, Jean-Daniel Cryans wrote: > Have a looksee here http://wiki.apache.org/hadoop/Hive/FAQ > > J-D > > On Wed, Jan 19, 2011 at 4:38 PM, vipul sharma > wrote: > > Thanks! > > > > N

Re: Problem starting Hive with local metastore on mysql

2011-01-19 Thread vipul sharma
gt; repeatable-read > > > > datanucleus.valuegeneration.transactionIsolation > repeatable-read > > > J-D > > On Wed, Jan 19, 2011 at 4:05 PM, vipul sharma > wrote: > > Hi, > > > > we had been running cloudera distribution of hadoop. We instal

Problem starting Hive with local metastore on mysql

2011-01-19 Thread vipul sharma
Hi, we had been running cloudera distribution of hadoop. We installed hive following this document https://wiki.cloudera.com/display/DOC/Hive+Installation. hive-site.xml was later modified for storing metastore in mysql very similar to the config in this blog http://blog.milford.io/2010/06/install