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:reena2...@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....@sap.com<mailto:jian-bin....@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


Reply via email to