hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3334) bug in explain plan for load with hive.optimize.index.autoupdate
Date Sat, 04 Aug 2012 14:19:02 GMT

    [ 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

        

Mime
View raw message