[ https://issues.apache.org/jira/browse/DRILL-3938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032881#comment-15032881 ]
ASF GitHub Bot commented on DRILL-3938: --------------------------------------- Github user mehant commented on the pull request: https://github.com/apache/drill/pull/211#issuecomment-160822016 Other than the minor comment, lgtm. +1 > 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.4.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)