Is it possible to generate indexes using Tez instead of specifying MR? When we try to set hive.execution.engine = Tez and try to generate an index, index creation fails. The following is a list of the commands I used:
CREATE TABLE table02 (column1 String, column2 bigint, string3 string); CREATE INDEX table02_index IN TABLE table02 (column3) AS "COMPACT" WITH REFLECTED CROSS; ALTER INDEX table02_index ON table02 REBUILD;
Error creating index with error message below: FAILED: Runtime error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask
So, to create an index in a table, we always need to set hive.execution.engine = mr, even if we want to use TEZ to execute queries on the data in this table? Is this a limitation for TEZ?
source share