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 Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: 2015年9月8日 17:01 To: user@hive.apache.org Subject: 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" <jian-bin....@sap.com> 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? > >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 > > >
