Re: NPE when reading Parquet using Hive on Tez

2016-01-04 Thread Gopal Vijayaraghavan
> select count(*) from alexa_parquet; > Caused by: java.lang.NullPointerException >at >org.apache.hadoop.hive.serde2.typeinfo.TypeInfoUtils$TypeInfoParser.tokeni >ze(TypeInfoUtils.java:274) >at >org.apache.hadoop.hive.serde2.typeinfo.TypeInfoUtils$TypeInfoParser.

Re: Immutable data in Hive

2016-01-04 Thread Ashok Kumar
I second that. Many thanks Mich for your reply. Regards On Monday, 4 January 2016, 10:58, "Singh, Abhijeet" wrote: #yiv5347372295 #yiv5347372295 -- _filtered #yiv5347372295 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv5347372295

RE: Immutable data in Hive

2016-01-04 Thread Singh, Abhijeet
Very well answered by Mich. Thanks Mich !! From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: Sunday, January 03, 2016 8:35 PM To: user@hive.apache.org; 'Ashok Kumar' Subject: RE: Immutable data in Hive Hi Ashok. I will have a go at this on top of Alan’s very valuable clarification.

Hive on TEZ fails starting

2016-01-04 Thread Mich Talebzadeh
Hi, Trying to run Hive on TEZ for the first time. Getting the error below 0: jdbc:hive2://rhes564:10010/default> set hive.execution.engine=tez; No rows affected (0.001 seconds) 0: jdbc:hive2://rhes564:10010/default> use oraclehadoop; No rows affected (0.018 seconds) 0:

RE: Hive on TEZ fails starting

2016-01-04 Thread Mich Talebzadeh
Thanks Rajesh. Done that and progressed Got another error :( 0: jdbc:hive2://rhes564:10010/default> set hive.execution.engine=tez; No rows affected (0.003 seconds) 0: jdbc:hive2://rhes564:10010/default> select count(1) from sales; INFO : Tez session hasn't been created yet. Opening

Re: Hive on TEZ fails starting

2016-01-04 Thread Rajesh Balamohan
Can you try removing double-quotes for "tez.lib.uris" in tez-site.xml (i.e just use hdfs://rhes564:9000/apps/tez-0.7.1-SNAPSHOT/tez-0.7.1- SNAPSHOT.tar.gz)? ~Rajesh.B On Tue, Jan 5, 2016 at 5:30 AM, Mich Talebzadeh wrote: > Hi, > > > > Trying to run Hive on TEZ for the

Re: Hive on TEZ fails starting

2016-01-04 Thread Rajesh Balamohan
By default it should add "LD_LIBRARY_PATH" in the container (ref: https://github.com/apache/tez/blob/abfc8bfb0a8620d31697a31ad516674a8d3f9f7c/tez-api/src/main/java/org/apache/tez/dag/api/TezConfiguration.java#L358) . In case your snappy native libs are present elsewhere in the cluster deployment,

Deleting empty rows from hive table through java

2016-01-04 Thread Sateesh Karuturi
Hello... Anyone please help me how to delete empty rows from hive table through java? Thanks in advance

NPE when reading Parquet using Hive on Tez

2016-01-04 Thread Adam Hunt
Hi, When I perform any operation on a data set stored in Parquet format using Hive on Tez, I get an NPE (see bottom for stack trace). The same operation works fine on tables stored as text, Avro, ORC and Sequence files. The same query on the parquet tables also works fine if I use Hive on MR.