[ https://issues.apache.org/jira/browse/HIVE-3334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428610#comment-13428610 ]
Namit Jain commented on HIVE-3334: ---------------------------------- The following query: set hive.stats.autogather=false; -- Create temp, and populate it with some values in src. CREATE TABLE temp(key STRING, val STRING) STORED AS TEXTFILE; -- Build an index on temp. CREATE INDEX temp_index ON TABLE temp(key) as 'COMPACT' WITH DEFERRED REBUILD; ALTER INDEX temp_index ON temp REBUILD; SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; SET hive.optimize.index.filter=true; SET hive.optimize.index.autoupdate=true; SET hive.optimize.index.filter.compact.minsize=0; -- load a file into a table with an index -- The stats task should follow the index update task explain load data local inpath '../data/files/srcbucket20.txt' INTO TABLE temp; The plan for load is as follows: STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 depends on stages: Stage-0 Stage-1 depends on stages: Stage-1 Stage-0 depends on stages: Stage-1 null depends on stages: Stage-1 Stage-2 depends on stages: Stage-1 > bug in explain plan for load with hive.optimize.index.autoupdate > ----------------------------------------------------------------- > > Key: HIVE-3334 > URL: https://issues.apache.org/jira/browse/HIVE-3334 > Project: Hive > Issue Type: Bug > Reporter: Namit Jain > -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira