Venki Korukanti created DRILL-3938:
--------------------------------------

             Summary: Hive: Failure reading from a partition when a new column 
is added to the table after the partition creation
                 Key: DRILL-3938
                 URL: https://issues.apache.org/jira/browse/DRILL-3938
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Hive
    Affects Versions: 0.4.0
            Reporter: Venki Korukanti
            Assignee: Venki Korukanti
             Fix For: 1.3.0


Repro:

>From Hive:
{code}
CREATE TABLE kv(key INT, value STRING);
LOAD DATA LOCAL INPATH 
'/Users/hadoop/apache-repos/hive-install/apache-hive-1.0.0-bin/examples/files/kv1.txt'
 INTO TABLE kv;
CREATE TABLE kv_p(key INT, value STRING, part1 STRING);
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=10000;
set hive.exec.max.dynamic.partitions.pernode=10000;
INSERT INTO TABLE kv_p PARTITION (part1) SELECT key, value, value as s FROM kv;

ALTER TABLE kv_p ADD COLUMNS (newcol STRING);
{code}

>From Drill:
{code}
USE hive;
DESCRIBE kv_p;
SELECT newcol FROM kv_p;
throws column 'newcol' not found error in HiveRecordReader while selecting only 
the projected columns.
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to