unsubscribe

2013-06-21 Thread Haidar Hadi

Re: Hive built-in functions not working

2013-06-21 Thread Ramki Palle
Try to add the jar explicitly from hive prompt and see if that works. Regards, Ramki. On Fri, Jun 21, 2013 at 7:32 AM, fab wol darkwoll...@gmail.com wrote: I'm using Hadoop 0.20.2 with Hive 0.11. I have succesfully inserted into hive/hdfs some csv-files in seperate tables. selects and joins

unsubscribe

2013-06-21 Thread Jyothi Kommajosyula
CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not

Re: Hive built-in functions not working

2013-06-21 Thread fab wol
thx, this worked now, after i checked, that i have to add them in each session. which config file have i to manipulate to embed those jars permantly? 2013/6/21 Ramki Palle ramki.pa...@gmail.com Try to add the jar explicitly from hive prompt and see if that works. Regards, Ramki. On Fri,

TempStatsStore derby.log

2013-06-21 Thread Raj Hadoop
Hi,   I have Hive metastore created in an Oracle database.   But when i execute my Hive queries , I see following directory and file created. TempStatsStore  (directory) derby.log   What are this? Can one one suggest why derby log is created even though my javax.jdo.option.ConnectionURL is

Re: Hive built-in functions not working

2013-06-21 Thread Dean Wampler
You could add the ADD JAR statements to your hive scripts or for your interact sessions, put them in ~/.hiverc. On Fri, Jun 21, 2013 at 12:37 PM, fab wol darkwoll...@gmail.com wrote: thx, this worked now, after i checked, that i have to add them in each session. which config file have i to

Re: show table throwing strange error

2013-06-21 Thread Sanjay Subramanian
Can u stop following services hive-server hive-meta-store Hive-server2 (if u r running that) Move current hive.log some place else Start following services hive-server hive-meta-store Hive-server2 (if u r running that) And check hive.log ? Also can u paste the CREATE TABLe script verbatim

Re: show table throwing strange error

2013-06-21 Thread kulkarni.swar...@gmail.com
More often than not in my experience is caused by a malformed hive-site.xml(or hive-default.xml). When this happened to me, it was because I somehow had tab characters in my hive-site.xml. Try dropping the file(s) and recreate with appropriate formatting. On Fri, Jun 21, 2013 at 2:17 PM, Sanjay