Re: NegativeArraySizeException in table join

2015-01-15 Thread Guodong Wang
are hitting into : > https://issues.apache.org/jira/browse/HIVE-9324 > > On Thu, Jan 15, 2015 at 1:53 AM, Guodong Wang wrote: > >> Hi, >> >> I am using hive 0.13.1 and currently I am blocked by a bug when joining 2 >> tables. Here is the sample query. >> >>

NegativeArraySizeException in table join

2015-01-15 Thread Guodong Wang
Hi, I am using hive 0.13.1 and currently I am blocked by a bug when joining 2 tables. Here is the sample query. INSERT OVERWRITE TABLE test_archive PARTITION(data='2015-01-17', name, type) SELECT COALESCE(b.resource_id, a.id) AS id, a.timstamp, a.payload, a.name, a.typ

question about SQL Standard Based Hive Authorization

2014-11-10 Thread Guodong Wang
Hi all, I am looking for some tutorial about how to set up "SQL Standard Based Hive Authorization" in hive 0.13. I found this page https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization I have followed this page to setup the mentioned configuration. But authorizatio

multiple insert clauses for the same table

2014-10-10 Thread Guodong Wang
I am using Hive 0.12.0. And when putting multiple inserts for the same table in one SQL, looks like hive queries plan analyzer fails to synthesis the right plan. Here is the issue. create table T1(i int, j int); create table T2(m int) partitioned by (n int); explain from T1 insert into table T2 p