RE: UPDATE and DELETE fail due to Error 10122 on Hive 1.2.1

Hi Reena, Thanks for your quick response. Unfortunately, after I set hive.in.test to true, I got Metastore failure…… any other configuration needs to be changed accordingly? Metastore on sandbox.hortonworks.com failed (Execution of 'export

Unsubscribe

On Mon, Sep 7, 2015 at 11:58 PM, Zhu, Jian-bing wrote: > Hi, > > > > I tried to test UPDATE and DELETE on Hive, but it always failed because of > “[Error 10122]: Bucketized tables do not support INSERT INTO”. > > > > I am using Hortonworks Sandbox HDP 2.3 which contains

RE: UPDATE and DELETE fail due to Error 10122 on Hive 1.2.1

Which configuration I should check to see if the metastore is configured for concurrency? Sorry, I just started to use Hive... BTW, if I change hive.in.test back to false, everything becomes OK (except the update/delete failure). Best Regards, Jianbing -Original Message- From: Dr

RE: UPDATE and DELETE fail due to Error 10122 on Hive 1.2.1

Has your metastore configured for concurrency? On 8/9/2015, "Zhu, Jian-bing" wrote: >Hi Reena, > >Thanks for your quick response. > >Unfortunately, after I set hive.in.test to true, I got Metastore failure…… >any other configuration needs to be changed accordingly? >

Error: java.lang.IllegalArgumentE:Column has wrong number of index entries found - when trying to insert from JSON external table to ORC table

Hi all, We have a process that load data from folder that have json files. We use external table on top of the json folder and then insert into ORC table. We get the error below during the load “Column has wrong number of index entries found: 0 expected: 20” I validate the JSON data

RE: Error: java.lang.IllegalArgumentE:Column has wrong number of index entries found - when trying to insert from JSON external table to ORC table

Hi I was able to complete the load when setting those parameters set hive.merge.orcfile.stripe.level = false; those parameter didn’t have impact set hive.merge.mapfiles=false; set hive.merge.mapredfiles=false; I have an a similar script that load to similar table and this script

Re: Accumulo Storage Manager

For the Array support: it might have just been a missed test case and is just a bug. I don't recall how off the top of my head Arrays are intended to be serialized (if it's some numeric counter in the Accumulo CQ or just serializing all the elements in the array into the Accumulo Value). If it

Re: [ANNOUNCE] New Hive Committer - Lars Francke

Congrats! From: Daniel Lopes > Reply-To: "user@hive.apache.org" > Date: Tuesday, September 8, 2015 at 15:02 To:

Re: [ANNOUNCE] New Hive Committer - Lars Francke

Congrats! *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 Mob +55 (18) 99764-2733 Ph +55 (11) 3522-8009 http://about.me/dannyeuu Av. Nova Independência, 956, São Paulo, SP

Re: [ANNOUNCE] New Hive Committer - Lars Francke

Thank you so much everyone! Looking forward to continue working with all of you. On Tue, Sep 8, 2015 at 3:26 AM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > Congrats! > > On Mon, Sep 7, 2015 at 3:54 AM, Carl Steinbach wrote: > >> The Apache Hive PMC has

Re: Subquery in select statement

Sorry, but there are something that I can do in this case? *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 Mob +55 (18) 99764-2733 Ph +55 (11) 3522-8009

Accumulo Storage Manager

Hi, I have been trying out the Hive Accumulo Manager as described here https://cwiki.apache.org/confluence/display/Hive/AccumuloIntegration and it seems to work as advertised. Thanks. However I don't seem to be able to get any sensible results when I have a Hive column of type ARRAY<> like

Re: hiveserver2 hangs

How much memory have you currently provided to HS2? Have you tried bumping that up? On Mon, Sep 7, 2015 at 1:09 AM, Sanjeev Verma wrote: > *I am getting the following exception when the HS2 is crashing, any idea > why it has happening* > > "pool-1-thread-121" prio=4

Logging configuration

We are having an issue for which we would like to enable logging. The component is org.apache.hadoop.hive.ql.exec.persistence.HybridHashTableContainer. We have added entries to both hive-log4.properties and hive-exec-log4j.properties as follows: log4j.appender.ts=org.apache.log4j.FileAppender

Re: hiveserver2 hangs

Sanjeev, I am going off this exception in the stacktrace that you posted. "at java.lang.OutOfMemoryError.(OutOfMemoryError.java:48)" which def. indicates that it's not very happy memory wise. I would def. recommend to bump up the memory and see if it helps. If not, we can debug further from

Re: Error: java.lang.IllegalArgumentE:Column has wrong number of index entries found - when trying to insert from JSON external table to ORC table

What hive version are you using? Can you disable automerging of files and see if that works? set hive.merge.orcfile.stripe.level to false. Also set hive.merge.mapfiles to false and hive.merge.mapredfiles to false so that slow merging is also disabled. On Tue, Sep 8, 2015 at 5:29 AM -0700,

RE: Error: java.lang.IllegalArgumentE:Column has wrong number of index entries found - when trying to insert from JSON external table to ORC table

The hive version is 0.14 I will try to use the setting you mention. Thanks Yehuda *From:* Prasanth Jayachandran [mailto:pjayachand...@hortonworks.com] *Sent:* Tuesday, September 08, 2015 5:48 PM *To:* user@hive.apache.org; user@hive.apache.org *Cc:* Daniel Haviv;

Re: hiveserver2 hangs

We have 8GB HS2 java heap, we have not tried any bumping. On Tue, Sep 8, 2015 at 8:14 PM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > How much memory have you currently provided to HS2? Have you tried bumping > that up? > > On Mon, Sep 7, 2015 at 1:09 AM, Sanjeev Verma

Re: hiveserver2 hangs

What this exception implies here? how to identify the problem here. Thanks On Tue, Sep 8, 2015 at 10:44 PM, Sanjeev Verma wrote: > We have 8GB HS2 java heap, we have not tried any bumping. > > On Tue, Sep 8, 2015 at 8:14 PM, kulkarni.swar...@gmail.com < >

Re: Getting error while performing Insert query

What is your hive sql ? And please check the hive.log which may have more info. (By default hive.log is located in /tmp/${user}/hive.log ) Best Regard, Jeff Zhang From: Sateesh Karuturi > Reply-To:

Re: Unsubscribe

Mohit Garg, to unsubscribe please send a message to user-unsubscr...@hive.apache.org as described here: Mailing Lists . Thanks. -- Lefty On Tue, Sep 8, 2015 at 5:47 AM, Mohit Garg wrote: > > > On Mon, Sep 7, 2015 at 11:58 PM,

Getting error while performing Insert query

hello..., iam using hive 1.1 and tez 0.7... Whenever iam trying to INSERT data into hive table using tez via java iam getting following error: *Exception in thread "main" org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10293]: