hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dr Mich Talebzadeh" <>
Subject Re: Index Rebuild - DUG failes due to vertex failure
Date Fri, 15 May 2015 10:32:30 GMT

Hi Marc,

As far as I know indexes do not work in hive. Have you checked it with



On 15/5/2015, "Marc Seeger" <> wrote:

>I'm using Hive14 on a HDP2.2-Cluster and have a problem with indexing on
>Hive. I can create an index.
>create INDEX ix_key ON TABLE DbTest.Tbl_test(TEST_KEY)
>as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH
>After that I loaded data into the table and built the index.
>ALTER INDEX ix_key ON DbTest.Tbl_test REBUILD;
>Hive built the index and it works fine, performance increased. Now I want
>to rebuild the index, but always get an error:
>INFO  : Session is already open
>INFO  : Tez session was closed. Reopening...
>INFO  : Session re-established.
>INFO  :
>ERROR : Status: Failed
>ERROR : Vertex failed, vertexName=Map 1,
>vertexId=vertex_1426585957958_2810_1_00, diagnostics=[Vertex
>vertex_1426585957958_2810_1_00 [Map 1] killed/failed due
>to:ROOT_INPUT_INIT_FAILURE, Vertex Input: Tbl_test initializer failed,
>vertex=vertex_1426585957958_2810_1_00 [Map 1],
>at org.apache.hadoop.hive.ql.exec.tez.DynamicPartitionPruner.initialize(
>at org.apache.hadoop.hive.ql.exec.tez.DynamicPartitionPruner.prune(
>at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(
>at Method)
>at java.util.concurrent.ThreadPoolExecutor.runWorker(
>at java.util.concurrent.ThreadPoolExecutor$
>ERROR : Vertex killed, vertexName=Reducer 2,
>vertexId=vertex_1426585957958_2810_1_01, diagnostics=[Vertex received
>Kill in INITED state., Vertex vertex_1426585957958_2810_1_01 [Reducer
>2] killed/failed due to:null]
>ERROR : DAG failed due to vertex failure. failedVertices:1 killedVertices:1
>Error: Error while processing statement: FAILED: Execution Error,
>return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask
>The base table exists, I can run queries against it. The index table exists
>too. If I create a new index on another table and run rebuild-command, I
>got the same error. I tried the command with beeline and CLI without any
>effect to result.
>Thanks for your help,

View raw message