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 wrote: > 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 tho

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 > Try to add the jar explicitly from hive prompt and see if that works. > > Regards, > Ramki. > > > On Fri, Jun 21, 2013 at

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 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 work > flawlessly. W

Hive built-in functions not working

2013-06-21 Thread fab wol
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 work flawlessly. When trying to analyse some data, i needed to make use of the built in functions of hive like: - substr - to_date - rand - etc. for example: