hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhu, Jian-bing" <jian-bin....@sap.com>
Subject RE: UPDATE and DELETE fail due to Error 10122 on Hive 1.2.1
Date Tue, 08 Sep 2015 08:08:33 GMT
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 HIVE_CONF_DIR='/usr/hdp/current/hive-metastore/conf/conf.server'
;
hive
--hiveconf hive.metastore.uris=thrift://sandbox.hortonworks.com:9083
--hiveconf hive.metastore.client.connect.retry.delay=1
--hiveconf hive.metastore.failure.retries=1
--hiveconf hive.metastore.connect.retries=1
--hiveconf hive.metastore.client.socket.timeout=14
--hiveconf hive.execution.engine=mr -e 'show databases;'' returned 40.

Best Regards,
Jianbing

From: reena upadhyay [mailto:reena2485@gmail.com]
Sent: Tuesday, September 8, 2015 3:13 PM
To: user@hive.apache.org
Subject: Re: UPDATE and DELETE fail due to Error 10122 on Hive 1.2.1

Apart from the above configuration, In order to allow insert/update/delete operation, You
would need to change following configuration in conf/hive-site.xml

<property>
  <name>hive.in.test</name>
  <value>true</value>
 </property>

Hope this helps.

On Tue, Sep 8, 2015 at 12:28 PM, Zhu, Jian-bing <jian-bin.zhu@sap.com<mailto:jian-bin.zhu@sap.com>>
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 Hive 1.2.1.

I already configured all the required parameters according to Hive doc:
hive.support.concurrency – true
hive.enforce.bucketing – true
hive.exec.dynamic.partition.mode – nonstrict
hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
hive.compactor.initiator.on – true (for exactly one instance of the Thrift metastore service)
hive.compactor.worker.threads – a positive number on at least one instance of the Thrift
metastore service

Hive log is attached and the followings are the output from Hive console.

Can anyone help to take a look and provide some suggestion to resolve it? Thanks in advance!



hive> CREATE TABLE mytable (col1 int, col2 string)
    > CLUSTERED BY (col1) INTO 2 BUCKETS
    > STORED AS ORC TBLPROPERTIES('TRANSACTIONAL'='TRUE');
OK
Time taken: 1.324 seconds

hive> insert into mytable values (1, 'AAA');
Query ID = root_20150908014932_e21e8fb1-f93b-472a-a527-1adc29cd3359
Total jobs = 1
Launching Job 1 out of 1
Tez session was closed. Reopening...
Session re-established.


Status: Running (Executing on YARN cluster with App id application_1440988430185         
                                                                                         
                                                         _0013)

--------------------------------------------------------------------------------
        VERTICES      STATUS  TOTAL  COMPLETED  RUNNING  PENDING  FAILED  KILLED
--------------------------------------------------------------------------------
Map 1 ..........   SUCCEEDED      1          1        0        0       0       0
Reducer 2 ......   SUCCEEDED      2          2        0        0       0       0
--------------------------------------------------------------------------------
VERTICES: 02/02  [==========================>>] 100%  ELAPSED TIME: 5.70 s
--------------------------------------------------------------------------------
Loading data to table default.mytable
Table default.mytable stats: [numFiles=2, numRows=1, totalSize=336, rawDataSize=         
                                                                                         
                                                         91]
OK
Time taken: 16.585 seconds

hive> insert into mytable values (2, 'BBB');
Query ID = root_20150908014955_2647ae71-0687-43dd-84c5-8263e65622f9
Total jobs = 1
Launching Job 1 out of 1


Status: Running (Executing on YARN cluster with App id application_1440988430185         
                                                                                         
                                                         _0013)

--------------------------------------------------------------------------------
        VERTICES      STATUS  TOTAL  COMPLETED  RUNNING  PENDING  FAILED  KILLED
--------------------------------------------------------------------------------
Map 1 ..........   SUCCEEDED      1          1        0        0       0       0
Reducer 2 ......   SUCCEEDED      2          2        0        0       0       0
--------------------------------------------------------------------------------
VERTICES: 02/02  [==========================>>] 100%  ELAPSED TIME: 7.97 s
--------------------------------------------------------------------------------
Loading data to table default.mytable
Table default.mytable stats: [numFiles=4, numRows=2, totalSize=672, rawDataSize=182]
OK
Time taken: 13.812 seconds

hive> delete from mytable;
FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO: Table:
default.mytable
hive>

hive> select * from mytable;
OK
2       BBB
1       AAA
Time taken: 0.803 seconds, Fetched: 2 row(s)


Best Regards,
Jianbing


Mime
View raw message