You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2017/08/15 22:48:00 UTC
[jira] [Commented] (HIVE-17326) Insert into HBase tables fails if
hive.llap.execution.mode is set to only
[ https://issues.apache.org/jira/browse/HIVE-17326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16128003#comment-16128003 ]
Sergey Shelukhin commented on HIVE-17326:
-----------------------------------------
Likely a duplicate of HIVE-16703
> Insert into HBase tables fails if hive.llap.execution.mode is set to only
> -------------------------------------------------------------------------
>
> Key: HIVE-17326
> URL: https://issues.apache.org/jira/browse/HIVE-17326
> Project: Hive
> Issue Type: Bug
> Components: llap
> Affects Versions: 2.1.0
> Environment: HDP 2.6.x
> Reporter: Sailaja Navvluru
>
> Inserting into a table created using HBase storage handler errors out if hive.llap.execution.mode=only. Works if the hive.llap.execution.mode value is none or auto or with MR execution engine.
> Simple repro script
> CREATE TABLE hbase_table_sai(id int, name string)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:name")
> TBLPROPERTIES ("hbase.table.name" = "sai");
> create table hive_tab1(c1 int, c2 string);
> insert into hive_tab1 values(1,'abc');
> 0: jdbc:hive2://localhost:10500/default> insert overwrite table hbase_table_sai select * from hive_tab1;
> INFO : Compiling command(queryId=hive_20170808125431_652dbcde-96d5-4afd-9359-bd71bfd6b01a): insert overwrite table hbase_table_sai select * from hive_tab1
> INFO : We are setting the hadoop caller context from HIVE_SSN_ID:7114abad-2ba2-410d-ad73-40d473a647af to hive_20170808125431_652dbcde-96d5-4afd-9359-bd71bfd6b01a
> INFO : Semantic Analysis Completed
> INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:hive_tab1.c1, type:int, comment:null), FieldSchema(name:hive_tab1.c2, type:string, comment:null)], properties:null)
> INFO : Completed compiling command(queryId=hive_20170808125431_652dbcde-96d5-4afd-9359-bd71bfd6b01a); Time taken: 0.36 seconds
> INFO : We are resetting the hadoop caller context to HIVE_SSN_ID:7114abad-2ba2-410d-ad73-40d473a647af
> INFO : Concurrency mode is disabled, not creating a lock manager
> INFO : Setting caller context to query id hive_20170808125431_652dbcde-96d5-4afd-9359-bd71bfd6b01a
> INFO : Executing command(queryId=hive_20170808125431_652dbcde-96d5-4afd-9359-bd71bfd6b01a): insert overwrite table hbase_table_sai select * from hive_tab1
> INFO : Query ID = hive_20170808125431_652dbcde-96d5-4afd-9359-bd71bfd6b01a
> INFO : Total jobs = 1
> INFO : Starting task [Stage-0:DDL] in serial mode
> INFO : Starting task [Stage-1:DDL] in serial mode
> INFO : Launching Job 1 out of 1
> INFO : Starting task [Stage-3:MAPRED] in serial mode
> INFO : Session is already open
> INFO : Tez session missing resources, adding additional necessary resources
> INFO : Dag name: insert overwrite table hbase_tab...hive_tab1(Stage-3)
> INFO : Dag submit failed due to There is conflicting local resource (guava-14.0.1.jar) between dag local resource and vertex Map 1 local resource.
> Resource of dag : resource { scheme: "hdfs" host: "ulcer1" port: 8020 file: "/tmp/hive/hive/7114abad-2ba2-410d-ad73-40d473a647af/hive_2017-08-08_12-54-31_225_8109820757632121978-7/hive/_tez_scratch_dir/guava-14.0.1.jar" } size: 2189117 timestamp: 1502222072247 type: FILE visibility: PRIVATE
> Resource of vertex: resource { scheme: "hdfs" host: "ulcer1" port: 8020 file: "/tmp/hive/hive/_tez_session_dir/8a93f7fd-b925-4684-a6b1-6561b5c8e344/guava-14.0.1.jar" } size: 2189117 timestamp: 1502211657919 type: FILE visibility: PRIVATE stack trace: [org.apache.tez.dag.api.DAG.verify(DAG.java:695), org.apache.tez.dag.api.DAG.createDag(DAG.java:796), org.apache.tez.client.TezClientUtils.prepareAndCreateDAGPlan(TezClientUtils.java:718), org.apache.tez.client.TezClient.submitDAGSession(TezClient.java:555), org.apache.tez.client.TezClient.submitDAG(TezClient.java:522), org.apache.hadoop.hive.ql.exec.tez.TezTask.submit(TezTask.java:506), org.apache.hadoop.hive.ql.exec.tez.TezTask.execute(TezTask.java:188), org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:197), org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100), org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1905), org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1607), org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1354), org.apache.hadoop.hive.ql.Driver.run(Driver.java:1123), org.apache.hadoop.hive.ql.Driver.run(Driver.java:1116), org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:242), org.apache.hive.service.cli.operation.SQLOperation.access$800(SQLOperation.java:91), org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:334), java.security.AccessController.doPrivileged(Native Method), javax.security.auth.Subject.doAs(Subject.java:422), org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866), org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:348), java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511), java.util.concurrent.FutureTask.run(FutureTask.java:266), java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511), java.util.concurrent.FutureTask.run(FutureTask.java:266), java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149), java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624), java.lang.Thread.run(Thread.java:748)] retrying...
> ERROR : Failed to execute tez graph.
> java.lang.IllegalStateException: There is conflicting local resource (guava-14.0.1.jar) between dag local resource and vertex Map 1 local resource.
> Resource of dag : resource { scheme: "hdfs" host: "ulcer1" port: 8020 file: "/tmp/hive/hive/7114abad-2ba2-410d-ad73-40d473a647af/hive_2017-08-08_12-54-31_225_8109820757632121978-7/hive/_tez_scratch_dir/guava-14.0.1.jar" } size: 2189117 timestamp: 1502222072247 type: FILE visibility: PRIVATE
> Resource of vertex: resource { scheme: "hdfs" host: "ulcer1" port: 8020 file: "/tmp/hive/hive/_tez_session_dir/8a93f7fd-b925-4684-a6b1-6561b5c8e344/guava-14.0.1.jar" } size: 2189117 timestamp: 1502211657919 type: FILE visibility: PRIVATE
> at org.apache.tez.dag.api.DAG.verify(DAG.java:695) ~[tez-api-0.8.4.2.6.1.0-129.jar:0.8.4.2.6.1.0-129]
> at org.apache.tez.dag.api.DAG.createDag(DAG.java:796) ~[tez-api-0.8.4.2.6.1.0-129.jar:0.8.4.2.6.1.0-129]
> at org.apache.tez.client.TezClientUtils.prepareAndCreateDAGPlan(TezClientUtils.java:718) ~[tez-api-0.8.4.2.6.1.0-129.jar:0.8.4.2.6.1.0-129]
> at org.apache.tez.client.TezClient.submitDAGSession(TezClient.java:555) ~[tez-api-0.8.4.2.6.1.0-129.jar:0.8.4.2.6.1.0-129]
> at org.apache.tez.client.TezClient.submitDAG(TezClient.java:522) ~[tez-api-0.8.4.2.6.1.0-129.jar:0.8.4.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.exec.tez.TezTask.submit(TezTask.java:526) ~[hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.exec.tez.TezTask.execute(TezTask.java:188) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:197) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1905) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1607) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1354) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1123) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1116) [hive-exec-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:242) [hive-service-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hive.service.cli.operation.SQLOperation.access$800(SQLOperation.java:91) [hive-service-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:334) [hive-service-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141]
> at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141]
> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1866) [hadoop-common-2.7.3.2.6.1.0-129.jar:?]
> at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:348) [hive-service-2.1.0.2.6.1.0-129.jar:2.1.0.2.6.1.0-129]
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_141]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_141]
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_141]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_141]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_141]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_141]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_141]
> ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
> INFO : Resetting the caller context to HIVE_SSN_ID:7114abad-2ba2-410d-ad73-40d473a647af
> INFO : Completed executing command(queryId=hive_20170808125431_652dbcde-96d5-4afd-9359-bd71bfd6b01a); Time taken: 11.141 seconds
> Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask (state=08S01,code=1)
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)