Re: Passing hive conf variables through ODBC/JDBC

2014-07-29 Thread sai chaitanya tirumerla
Hi, Thanks Lars. I'm using hive 0.11 and it throws "can't execute after statement is closed" error when doing it(jdbc:hive2://foobar:1/database? fs.s3.awsAccessKeyId=xxx;fs.s3.awsSecretAccesskey=xx) from sql workbench. i have tried different methods to make it work like jdbc:hive2://f

RE: java.lang.NumberFormatException.forInputString

2014-07-29 Thread Sameer Tilak
Hi Nishant,Yes, that works, I don't see the crash any more. I also don't use the following sentence:SET hive.input.format=org.apache.hadoop.hive.ql.index.compact.HiveCompactIndexInputFormat; However, I don't see any benefit of indexing now. With or without indexing I get the results back in same

Re: Metastore Event Listeners

2014-07-29 Thread Raymond Lau
Figured out my problem. I didn't add the jar to the classpath properly, was trying to reference it locally instead of on HDFS. On Mon, Jul 28, 2014 at 7:23 PM, Raymond Lau wrote: > Hey guys, I'm having some trouble getting my Metastore Event Listener to > do anything, none of my print statemen

Re: python UDF and Avro tables

2014-07-29 Thread Kevin Weiler
Thanks for the information. In all the instructions that I’ve read, it mentions splitting the fields of the table on a delimiter, and I figured that it was the delimiter of whatever the file format was. It turns out that in the version of Hive I’m using (hive-0.12.0+cdh5.1.0+369), Avro tables ar

Re: Install Hadoop and Hive

2014-07-29 Thread R J
Hi Ricardo, Thank you. I am looking to install cloudera software on my PC.   PowerShelldoes not seem to have hadoop software in it. Thank you On Monday, July 28, 2014 12:06 AM, Ricardo Birmele wrote: Check out blogs.msdn.com.  Search for "how to install the PowerShell commandlets for