Can't integrate Elasticsearch with Hive

2014-11-26 Thread Atul Paldhikar (apaldhik)
Hi All, I am using Hive 0.13.1 and Hadoop 2.5.1 and trying to create an external table so data can me loaded from Hive to Elasticsearch. However I keep getting the following error. I have tried with following jars but same error. I will really appreciate for any pointers. Thanks - Atul hiv

RE: Issue with windowing function UDAF registeration

2014-11-26 Thread wesley dias
Hi Karthik, Thanks for the below response. But I dont think the issue is related to empty table. Even if I try tocreate an alias for a inbuilt windowing function for e.g. Last_Value Create temporary function mylastval as 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFLastValue'; And i try usi

RE: Issue with windowing function UDAF registeration

2014-11-26 Thread wesley dias
Hi Karthik, Thanks for the below response. But I dont think the issue is related to empty table. Even if I try tocreate an alias for a inbuilt windowing function for e.g. Last_Value Create temporary function mylastval as 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFLastValue'; And i try usi

hive server2 error upgrade hive from 0.10.0 to 0.13.1

2014-11-26 Thread Jander g
Hi, everybody We use Hadoop CDH4.6.0, now i try to upgrade only hive to 0.13.1-cdh5.2.0,something puzzles me: because it isn't compatible with protobuf 2.5.0, so i rebuild hive-0.13.1-cdh5.2.0 using protobuf 2.4.0a, then it is ok to run hive query and metastore. when i use hive server2 using bee

upgrade hive-0.10.0-cdh4.6.0 to hive-0.13.1-cdh5.2.0

2014-11-26 Thread Jander g
Hi, everybody We use Hadoop CDH4.6.0, now i try to upgrade only hive to 0.13.1-cdh5.2.0,something puzzles me: because it isn't compatible with protobuf 2.5.0, so i rebuild hive-0.13.1-cdh5.2.0 using protobuf 2.4.0a, then it is ok to run hive query and metastore. when i use hive server2 using bee

can't get smallint field from hive on spark

2014-11-26 Thread 诺铁
we are currently using hive on spark, when reading a small int field, it reports error: Cannot get field 'i16Val' because union is currently set to i32Val I googled and find only source code of TColumnValue.java

Re: Issue with windowing function UDAF registeration

2014-11-26 Thread Karthiksrivasthava
You might be running this query on empty table .. Windowing function throw error with null input and this is fixed in 0.14 hive version Thanks Karthik > On Nov 26, 2014, at 21:35, wesley dias wrote: > > Hi, > > > > While executing a simple select query using a custom windowing UDAF I creat

Issue with windowing function UDAF registeration

2014-11-26 Thread wesley dias
Hi, While executing a simple select query using a custom windowing UDAF I created I am constantly running into this error. Error: java.lang.RuntimeException: Error in configuring object at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:109) at org.a

issue with hive wide tables/views

2014-11-26 Thread Viral Bajaria
Hi, I have a table which ended up having 3K+ columns. The building of the table wasn't that painful, but the part where things suck is when creating VIEWs on top of that table. 1 of the views that I want to create needs complex operation and references a ton of columns or almost all of the column

Re: maven build failure for hive with spark

2014-11-26 Thread Xuefu Zhang
Thanks for your interest. Please remove org/apache/spark in your local maven repo and try again. This may fix your problem. --Xuefu On Wed, Nov 26, 2014 at 1:03 AM, Somnath Pandeya < somnath_pand...@infosys.com> wrote: > Hi > > I am trying to build hive with spark engine but getting maven build

Query is stuck in middle

2014-11-26 Thread Amit Behera
Hi User, I am running a join query on 100GB table with 10 GB table. My query got stuck without giving any error like below. 2014-11-26 20:19:53,893 Stage-1 map = 99%, reduce = 10%, Cumulative CPU 29443.21 sec 2014-11-26 20:20:53,920 Stage-1 map = 99%, reduce = 10%, Cumulative CPU 29480.04 sec 2

RE: using "SET" with JDBC

2014-11-26 Thread Guy Doulberg
Option 1, is not good for me, I specify the connection string once for many statements From: Karthik Banala [mailto:karthikban...@gmail.com] Sent: Tuesday, November 25, 2014 6:32 PM To: user@hive.apache.org Subject: Re: using "SET" with JDBC You're right , Missed it We do need to specify SET

maven build failure for hive with spark

2014-11-26 Thread Somnath Pandeya
Hi I am trying to build hive with spark engine but getting maven build failure Please help. Following is the error. [INFO] Tests are skipped. [INFO] [INFO] --- maven-jar-plugin:2.2:jar (default-jar) @ hive-ant --- [INFO] Building jar: /mnt/disk1/software/hive/ant/target/hive-ant-0.15.0-SNAPSHO