[jira] [Created] (HIVE-8719) LoadSemanticAnalyzer ignores previous partition location if inserting into partition that already exists

[Sushanth Sowmyan (JIRA)]

Sushanth Sowmyan created HIVE-8719:
--------------------------------------

             Summary: LoadSemanticAnalyzer ignores previous partition location 
if inserting into partition that already exists
                 Key: HIVE-8719
                 URL: https://issues.apache.org/jira/browse/HIVE-8719
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.14.0
            Reporter: Sushanth Sowmyan


LOAD DATA INSERT INTO seems to be broken currently for partitions that do not 
use hive's native directory structure naming scheme, thus ignoring any location 
previously set by an ALTER TABLE ADD PARTITION ... LOCATION ... command.

Here is a simple reproducer:

{noformat}
echo 1 > /tmp/data1.txt
hive -e "create external table testpart(id int) partitioned by (date string) 
location '/tmp/testpart';"
hive -e "alter table testpart add partition(date='2014-09-16')  location 
'/tmp/testpart/20140916';"
hive -e "describe formatted testpart partition(date='2014-09-16') ;" | egrep 
'/tmp/testpart/(date=.?)?2014-?09-?16' > /tmp/a
hive -e "load data local inpath '/tmp/data1.txt' into table testpart 
partition(date='2014-09-16');"
hive -e "describe formatted testpart partition(date='2014-09-16') ;" | egrep 
'/tmp/testpart/(date=.?)?2014-?09-?16' > /tmp/b
diff /tmp/a /tmp/b
hadoop fs -ls /tmp/testpart/
{noformat}



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