You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2012/08/04 16:17:02 UTC
[jira] [Created] (HIVE-3334) bug in explain plan for load with
hive.optimize.index.autoupdate
Namit Jain created HIVE-3334:
--------------------------------
Summary: 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
[jira] [Commented] (HIVE-3334) bug in explain plan for load with
hive.optimize.index.autoupdate
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ 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