RE: Hive JSON Serde question

Hi Ari, Please send an email to user-unsubscr...@hive.apache.org Thanks! Nick From: Ari Flink [mailto:flinks...@gmail.com] Sent: Monday, January 26, 2015 1:30 PM To: user@hive.apache.org Subject: Re: Hive JSON Serde question unsubscribe On Sun, Jan 25,

sum a double in ORC bug?

*Hive 13 I'm storing a sales amount column as a double in an ORC table and when I do: select sum(x) from sometable I get a value like 4.79165141174808E9 A visual inspection of the column values reveals no glaring anomalies...all looks pretty normal. If I do the same thing in a textfile table I

RE: Set variable via query

, 2015 at 4:39 PM, Martin, Nick mailto:nimar...@pssd.com>> wrote: Hi all, I'm looking to set a variable in Hive and use the resulting value in a subsequent query. Something like: set startdt='select max(dt) from sometable'; select * from someothertable where dt=${hiveconf:start

Set variable via query

Hi all, I'm looking to set a variable in Hive and use the resulting value in a subsequent query. Something like: set startdt='select max(dt) from sometable'; select * from someothertable where dt=${hiveconf:startdt}; I found this is still open HIVE-2165

Variable set via query

Hi all, Wondering of its possible for me to set a variable via a query. Something like: Set V1= select max(V1) from sometable And then use V1 in my query. Thx! Sent from my iPhone

RE: Null Pointer Exception with tez

Can you post the query you're trying to run and the log output? -Original Message- From: Anusha [mailto:anusha.mang...@gmail.com] Sent: Friday, October 03, 2014 9:28 AM To: user@hive.apache.org Subject: Null Pointer Exception with tez Hi , I get Null Pointer Exception sometimes when I

RE: Indexes vs Partitions in hive

Lefty, that’s the single best description of indexes/partitions I’ve yet encountered. Stealing it. Nice ☺ From: Lefty Leverenz [mailto:leftylever...@gmail.com] Sent: Tuesday, September 09, 2014 2:28 PM To: user@hive.apache.org Subject: Re: Indexes vs Partitions in hive Others can give technical

Re: Hive job scheduling

Oozie has a workflow action for Hive to execute scripts. You can also configure an Oozie coordinator to run the Hive workflow at desired intervals. Lots of Oozie config options for workflows and configs so check out the documentation. Sent from my iPhone On Jul 10, 2014, at 6:09 PM, "Cheng Ju C

Re: ORC 'BETWEEN' Error

is an known issue and its fixed in hive trunk. It should be available in 0.13 release. https://issues.apache.org/jira/browse/HIVE-5601 Thanks Prasanth Jayachandran On Feb 26, 2014, at 8:55 AM, Martin, Nick mailto:nimar...@pssd.com>> wrote: Hi all, (Running Hive 12.0) I have two tabl

ORC 'BETWEEN' Error

Hi all, (Running Hive 12.0) I have two tables and both are stored as ORC. I attempted to insert via select from tbl1 to tbl2 using 'BETWEEN' in my where clause to narrow down some dates. Something like so: "Insert into tbl1 select col1, col2 from tbl2 where col1 between 2 and 4" I kept hittin

Julian Date Conversion?

Have a Julian date I need to convert... is there a date func for that in Hive 12?

RE: Execution failed with exit status: 3

at org.apache.hadoop.mapred.Child$4.run(Child.java:255) From: Martin, Nick [mailto:nimar...@pssd.com] Sent: Tuesday, October 08, 2013 3:21 PM To: user@hive.apache.org Subject: RE: Execution failed with exit status: 3 Thanks for the suggestion. We have the user perms configured appropr

OOM/GC limit Error

Hi all, I have two tables: tbl1: 81m rows tbl2: 4m rows tbl1 is partitioned on one column and tbl2 has none. I'm attempting the following query: SELECT tbl1.col_pk, tbl2.col1, tbl2.col2, SUM(tbl1.col4), SUM(tbl1.col5), SUM(tbl1.col4+col5) FROM tbl2 JOIN tbl1 ON (tbl1.col_pk=tbl2.col_pk) WHERE

RE: Problem starting Hive

Hi Clay, Quick housekeeping/config check...is the URI in /etc/hive/conf/hive-site.xml pointing to the right place? From: Clay McDonald [mailto:stuart.mcdon...@bateswhite.com] Sent: Thursday, October 17, 2013 8:54 AM To: 'Eric Mizell'; Rommel Garcia; Yi Zhang; 'user@hive.apache.org' Cc: Chris Hac

RE: Execution failed with exit status: 3

mailto:user@hive.apache.org>> Subject: RE: Execution failed with exit status: 3 Update on this... When I run this in Hive CLI it works perfectly. Only has a bug in Hue. I'll send this thread over to hue_user@ and see what they say. From: Martin, Nick [mailto:nimar...@pssd.com] Sent: Tuesday

RE: Execution failed with exit status: 3

Update on this... When I run this in Hive CLI it works perfectly. Only has a bug in Hue. I'll send this thread over to hue_user@ and see what they say. From: Martin, Nick [mailto:nimar...@pssd.com] Sent: Tuesday, October 08, 2013 12:17 PM To: user@hive.apache.org Subject: RE: Execution f

RE: Execution failed with exit status: 3

Hi Sanjay, thanks for the suggestion. There are no partitions on either table. From: Sanjay Subramanian [mailto:sanjay.subraman...@wizecommerce.com] Sent: Monday, October 07, 2013 8:19 PM To: user@hive.apache.org Subject: Re: Execution failed with exit status: 3 Hi Nick How many partitions are

Execution failed with exit status: 3

Hi all, I'm doing a very basic join in Hive and getting the error below. The HiveQL join syntax I'm using is: SELECT T1.somecolumn, T2.someothercolumn FROM t1 JOIN t2 ON (t1.idfield=t2.idfield) Driver returned: 3. Errors: OK Total MapReduce jobs = 1 setting HADOOP_USER_NAME someuser E

RE: Hive Query via Hue, Only column headers in downloaded CSV or XSL results, sometimes

Mark - is the Hive table you're using for this fairly wide? If so, are you doing a "select * from table_name limit 10"? We ran some tests this morning on one of the Hive tables giving us some fits and if we limit the select to ~20 columns and put the limit on the query we get the returns fairly

RE: Hive Query via Hue, Only column headers in downloaded CSV or XSL results, sometimes

Hi Mark - we hit this issue as well. We use Hue as the Hive front-end for our users and this is a pretty big roadblock for them. We're on Hue 2.2 and Hive 11. If you figure out a fix let me know :) -Original Message- From: Sunderlin, Mark [mailto:mark.sunder...@teamaol.com] Sent: Mo