Deleting empty rows from hive table through java

Hello... Anyone please help me how to delete empty rows from hive table through java? Thanks in advance

Re: Hive on TEZ fails starting

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, y

RE: Hive on TEZ fails starting

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

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 first time. Getting the

Hive on TEZ fails starting

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: jdbc:hive2

Re: NPE when reading Parquet using Hive on Tez

> 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. >(TypeInfoUtils.java:29

Re: Immutable data in Hive

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 {font-family:Tahoma;panose-1:2 11

NPE when reading Parquet using Hive on Tez

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. I'm

RE: Immutable data in Hive

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. Extr