Re: "show table" throwing strange error

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 S

Re: "show table" throwing strange error

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 here

Re: Question regarding nested complex data type

;) I actually thought it was a clever choice on Hive's part. There's no real need for the 2nd tier separators, despite the nested collections! However, it's still tricky to know what Hive expects when you're generating table data with other apps. dean On Thu, Jun 20, 2013 at 9:34 PM, Stephen Spr

Re: Hive built-in functions not working

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

TempStatsStore derby.log

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 pointi

Re: Hive built-in functions not working

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

unsubscribe

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 to

Re: Hive built-in functions not working

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

unsubscribe

Hive built-in functions not working

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:

does any know how to use TCLIService.AsyncClient

hi dear all, I want to use TCLIService.AsyncClient to perform async query to hive, and want to query the query execute status to check if it finished. there is little information about the AsyncClient, does anyone have example codes or some documents? my hive version is 0.11 Kent

Re: Hive select shows null after successful data load

Yes values is the outer most array. Probably array < struct < struct is the max level of nesting possible. Any number of structs can be nested, but internal arrays seem to be an issue. The ones that failed had, array< struct < struct < array < struct. This broke the serde. Regarding pretty printin

How we can change the files name of results query in hive (the famous files name 00000_0, 00000_1,.....)

Hello every one, I want to know if is there a manner to change the files name when I want to store in HDSF or Local directory the Hive queries results (select …. >From …..), ie the famous files name (0_0, 0_1,..)? Thanks for your answers ;)