Member since
07-17-2019
9
Posts
0
Kudos Received
0
Solutions
07-29-2019
01:17 PM
delete from table__3 where open_dte='2015-08-23'; i faced below error Error: Error while processing statement: null (state=,code=1) 0: jdbc:hive2://maa5rfiseimap01:10500> delete from table__3 where open_dte='2015-08-23'; INFO : Compiling command(queryId=hive_20190729140209_b0c1255e-4e47-4612-be7b-15676a78e0aa): delete from table__3 where open_dte='2015-08-23' INFO : Semantic Analysis Completed (retrial = false) INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:row__id, type:struct<writeid:bigint,bucketid:int,rowid:bigint>, comment:null)], properties:null) INFO : Completed compiling command(queryId=hive_20190729140209_b0c1255e-4e47-4612-be7b-15676a78e0aa); Time taken: 0.185 seconds INFO : Executing command(queryId=hive_20190729140209_b0c1255e-4e47-4612-be7b-15676a78e0aa): delete from table__3 where open_dte='2015-08-23' INFO : Query ID = hive_20190729140209_b0c1255e-4e47-4612-be7b-15676a78e0aa INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Subscribed to counters: [] for queryId: hive_20190729140209_b0c1255e-4e47-4612-be7b-15676a78e0aa INFO : Session is already open INFO : Dag name: delete from table__3...pen_dte='2015-08-23' (Stage-1) ERROR : Status: Failed ERROR : Vertex failed, vertexName=Map 1, vertexId=vertex_1563167767849_0379_24_00, diagnostics=[Vertex vertex_1563167767849_0379_24_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: table__3 initializer failed, vertex=vertex_1563167767849_0379_24_00 [Map 1], java.lang.IllegalArgumentException: No enum constant org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.SplitStrategyKind.etl at java.lang.Enum.valueOf(Enum.java:238) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$SplitStrategyKind.valueOf(OrcInputFormat.java:170) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$Context.<init>(OrcInputFormat.java:650) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getSplits(OrcInputFormat.java:1940) at org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:524) at org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:779) at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:243) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:278) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:269) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1688) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:269) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253) at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:108) at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:41) at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:77) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) ] ERROR : Vertex killed, vertexName=Reducer 2, vertexId=vertex_1563167767849_0379_24_01, diagnostics=[Vertex received Kill in INITED state., Vertex vertex_1563167767849_0379_24_01 [Reducer 2] killed/failed due to:OTHER_VERTEX_FAILURE] ERROR : DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:1 INFO : org.apache.tez.common.counters.DAGCounter: INFO : AM_CPU_MILLISECONDS: 90 INFO : AM_GC_TIME_MILLIS: 0 ERROR : FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1563167767849_0379_24_00, diagnostics=[Vertex vertex_1563167767849_0379_24_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: table__3 initializer failed, vertex=vertex_1563167767849_0379_24_00 [Map 1], java.lang.IllegalArgumentException: No enum constant org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.SplitStrategyKind.etl at java.lang.Enum.valueOf(Enum.java:238) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$SplitStrategyKind.valueOf(OrcInputFormat.java:170) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$Context.<init>(OrcInputFormat.java:650) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getSplits(OrcInputFormat.java:1940) at org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:524) at org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:779) at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:243) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:278) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:269) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1688) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:269) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253) at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:108) at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:41) at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:77) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) ]Vertex killed, vertexName=Reducer 2, vertexId=vertex_1563167767849_0379_24_01, diagnostics=[Vertex received Kill in INITED state., Vertex vertex_1563167767849_0379_24_01 [Reducer 2] killed/failed due to:OTHER_VERTEX_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:1 INFO : Completed executing command(queryId=hive_20190729140209_b0c1255e-4e47-4612-be7b-15676a78e0aa); Time taken: 0.276 seconds Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1563167767849_0379_24_00, diagnostics=[Vertex vertex_1563167767849_0379_24_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: table__3 initializer failed, vertex=vertex_1563167767849_0379_24_00 [Map 1], java.lang.IllegalArgumentException: No enum constant org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.SplitStrategyKind.etl at java.lang.Enum.valueOf(Enum.java:238) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$SplitStrategyKind.valueOf(OrcInputFormat.java:170) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat$Context.<init>(OrcInputFormat.java:650) at org.apache.hadoop.hive.ql.io.orc.OrcInputFormat.getSplits(OrcInputFormat.java:1940) at org.apache.hadoop.hive.ql.io.HiveInputFormat.addSplitsForGroup(HiveInputFormat.java:524) at org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:779) at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:243) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:278) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:269) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1688) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:269) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253) at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:108) at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:41) at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:77) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) ]Vertex killed, vertexName=Reducer 2, vertexId=vertex_1563167767849_0379_24_01, diagnostics=[Vertex received Kill in INITED state., Vertex vertex_1563167767849_0379_24_01 [Reducer 2] killed/failed due to:OTHER_VERTEX_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:1 (state=08S01,code=2)
... View more
07-27-2019
06:27 AM
when i am querying acid table i am facing this below error Error: java.io.IOException: java.lang.IllegalArgumentException: bucketId out of range: -1 (state=,code=0) can anyone help me
... View more
Labels:
- Labels:
-
Apache Hive
07-19-2019
04:47 AM
when i am import this >from pyspark_llap import HiveWarehouseSession i had faced the error like ImportError: No module named pyspark_llap. how to install this module .Is there any step by step user guide?
... View more
Labels:
- Labels:
-
Apache Hive
07-18-2019
04:39 PM
@Shu hive warehouse connector support for acid table is available in HDP-3.0 r do i need to upgrade HDP-3.0 to HDP-3.1
... View more
07-18-2019
04:38 PM
@shu hive warehouse connector support for acid table is available in HDP-3.0 r do i need to upgrade HDP-3.0 to HDP-3.1
... View more
07-18-2019
06:13 AM
thank u 4 the info
... View more
07-17-2019
12:34 PM
i have created acid orc partition table in hive. By using spark i insert the data to that table . in table pointing location its showing data like /warehouse/tablespace/managed/hive/testdb.db/table__2/full_date=2019-07-17/delta_0000000_0000000_0000/ 0000_0 . when i query the table it showing only column names can any one give me a solution
... View more
Labels:
- Labels:
-
Apache Hive