Re: Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause)

2014-02-26 Thread shashwat shriparv
Check for errors in hive logs too if any and let us know *Warm Regards_**∞_* * Shashwat Shriparv* [image: http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9][image: https://twitter.com/shriparv] [image

Re: Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause)

2014-02-26 Thread shashwat shriparv
​Check if hive server is running and not stopped.​ *Warm Regards_**∞_* * Shashwat Shriparv* [image: http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9][image: https://twitter.com/shriparv] [image: http

Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause)

2014-02-26 Thread Rishabh Bhardwaj
On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj wrote: Hi , I have created a external table and when I provide the location of the data for this table I get the following error: FAILED: Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite ca

Re: KryoException -missing no-arg constructor ASTNodeOrigin

2014-02-26 Thread Navis류승우
It's HIVE-5779 and will be fixed in hive-0.13.0. Thanks, Navis 2014-02-21 21:07 GMT+09:00 Rafal Janik : > Hi All, > > I've just started my adventure with Hive so I'm not sure if it's an issue > here or just my misunderstanding... > I'm using Hortonworks Sandbox 2.0 (Hive 0.12.0.2.0.6.0-76) > I'

What to choose, hive 0.11 (marked as stable release ) or hive 0.12

2014-02-26 Thread twinkle sachdeva
Hi, I am planning to use hive for my use case, but I am confused between hive 0.12 and hive 0.11. Hive 0.12 has been there for reasonable amount of time , while hive 0.11 has been marked as stable release. Are there any known critical issues which are there in hive 0.12, that it has not been mar

how to feed sample of data to each mapper

2014-02-26 Thread qiaoresearcher
Assume there is one large data set with size 100G on hdfs, how can I control that every data sent into each mapper is around 10G and the 10G is random sampled from the 100G data set? Do we have any mahout sample code doing this? Any comments will be appreciated. Regards,

Re: Hive 0.13

2014-02-26 Thread Lefty Leverenz
The release process is currently scheduled to begin on March 4th. It takes a couple of weeks, minimum, so if all goes well Hive 0.13 will be ready sometime in the second half of March. Here's the message thread on dev@hive: Timeline for the Hive 0.13 release?

RE: Hive trunk unit test failed

2014-02-26 Thread java8964
OK. Now I understand that this error is due to missing the Hadoop native library. If I manually add "libhadoop.so" into java.library.path for this unit test, it passed. So either the hadoop 2.2.0 coming from Maven reponsitory includes 32bit of hadoop native library, or totally missed it. Now the

Re: hive query to calculate percentage

2014-02-26 Thread Manish
Yong, Thanks for your response.. I am getting an error : FAILED: SemanticException [Error 10002]: Line 11:28 Invalid column reference 'timestamp_dt' Sorry I didn't mention earlier, the table is partitioned on "timestamp_dt " On 2/25/14, 5:57 PM, java8964 wrote: one query won't work, as t

Hive trunk unit test failed

2014-02-26 Thread java8964
Hi, I tried to run the all tests in my local Linux x64 of current Hive trunk code. My "mvn clean package -DskipTests -Phadoop-2 -Pdist" will work fine if I skip tests. The following unit test failed, and then it stopped. I traced the code down to a native method invoked at"org.apache.hadoop.sec

Hive 0.13

2014-02-26 Thread Bhaskar Dutta
Hi, when is hive 0.13 getting released? Thanks Bhaskie

Connection refused error - Getting repeatedly

2014-02-26 Thread Raj Hadoop
All,  I have a 3 node hadoop cluster CDH 4.4 and every few days or when ever I load some data through sqoop or query through hive , sometimes I get the following error - Call From <> to <> failed on connection exception: java.net.ConnectException: Connection refused This has become so freque

Re: Reading hive table using Pig script

2014-02-26 Thread Mohammad Tariq
Hi Chhaya, I totally agree with AbdelRahman. HCatalog is the correct way to do that. See *this*for more details. Warm Regards, Tariq cloudfront.blogspot.com On Wed, Feb 26, 2014 at 11:

Re: Reading hive table using Pig script

2014-02-26 Thread Abdelrahman Shettia
Hi Chhaya, Why not using HCatalog to store the PIG and Hive schema for easy sharing? Thanks, Rahman On Feb 12, 2014, at 2:32 AM, Chhaya Vishwakarma wrote: > Hi, > > I am trying to read hive table using PIG script but when I run a pig code to > read a table in hive its giving me following

Re: configuring Hive to automatically create _SUCCESS files

2014-02-26 Thread Abdelrahman Shettia
Hi Centerqi, The Enhanced FileOutputCommitter is to create a _SUCCESS file for successful jobs that run on a table. I believe the following conf controls this: mapreduce.fileoutputcommitter.marksuccessfuljobs Not sure if it is in Hive 0.9. Thanks -Rahnab On Tue, Feb 25, 2014 at 2:46 AM, center

Re: [ANNOUNCE] New Hive Committer - Remus Rusanu

2014-02-26 Thread Thejas Nair
Congrats Remus! On Wed, Feb 26, 2014 at 9:08 AM, Clay McDonald < stuart.mcdon...@bateswhite.com> wrote: > Congratulations Remus! > > Clay > > -Original Message- > From: Jarek Jarcec Cecho [mailto:jar...@apache.org] > Sent: Wednesday, February 26, 2014 12:06 PM > To: user@hive.apache.org

RE: [ANNOUNCE] New Hive Committer - Remus Rusanu

2014-02-26 Thread Clay McDonald
Congratulations Remus! Clay -Original Message- From: Jarek Jarcec Cecho [mailto:jar...@apache.org] Sent: Wednesday, February 26, 2014 12:06 PM To: user@hive.apache.org Cc: d...@hive.apache.org; rem...@microsoft.com Subject: Re: [ANNOUNCE] New Hive Committer - Remus Rusanu Congratulatio

Re: [ANNOUNCE] New Hive Committer - Remus Rusanu

2014-02-26 Thread Jarek Jarcec Cecho
Congratulations Remus, good work! Jarcec On Wed, Feb 26, 2014 at 08:58:43AM -0800, Carl Steinbach wrote: > The Apache Hive PMC has voted to make Remus Rusanu a committer on the > Apache Hive Project. > > Please join me in congratulating Remus! > > Thanks. > > Carl signature.asc Description:

ORC 'BETWEEN' Error

2014-02-26 Thread Martin, Nick
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

RE: [ANNOUNCE] New Hive Committer - Remus Rusanu

2014-02-26 Thread Eric Hanson (BIG DATA)
Fantastic! Welcome aboard, Remus! Eric From: Carl Steinbach [mailto:cwsteinb...@gmail.com] Sent: Wednesday, February 26, 2014 8:59 AM To: user@hive.apache.org; d...@hive.apache.org Cc: Remus Rusanu Subject: [ANNOUNCE] New Hive Committer - Remus Rusanu The Apache Hive PMC has voted to make Remus

[ANNOUNCE] New Hive Committer - Remus Rusanu

2014-02-26 Thread Carl Steinbach
The Apache Hive PMC has voted to make Remus Rusanu a committer on the Apache Hive Project. Please join me in congratulating Remus! Thanks. Carl

RE: Hadoop streaming with insert dynamic partition generate many small files

2014-02-26 Thread Bogala, Chandra Reddy
Hi, I tried with absolute path. It works fine. But I have another issue. I have below data in string format. I am trying to convert/cast that data to other format using transform. But it's not doing properly. What might be the issue? 10347 [{"protocol":"udp","sum_bytes":20897,"sum_packets"

Re: Hive JDBC + Jetty

2014-02-26 Thread Jone Lura
Hi Vaibhav, I apologize. I missed a line in the documentation. By adding the hadoop-core*.jar file, everything worked as expected. Best regards, Jone On 26 Feb 2014, at 11:58, Vaibhav Gumashta wrote: > Hi Jone, > > What version of jetty are you using? It is possible that you have multiple

Re: Hive JDBC + Jetty

2014-02-26 Thread Vaibhav Gumashta
Hi Jone, What version of jetty are you using? It is possible that you have multiple versions in your classpath. Thanks, --Vaibhav On Fri, Feb 21, 2014 at 5:31 AM, Jone Lura wrote: > Hi, > > I have encountered a problem when I try to deploy my application on Jetty. > > In my Junit test environ