Eugene Koifman created HIVE-15032:
-------------------------------------

             Summary: Update/Delete statements use dynamic partitions when it's 
not necessary
                 Key: HIVE-15032
                 URL: https://issues.apache.org/jira/browse/HIVE-15032
             Project: Hive
          Issue Type: Bug
          Components: Transactions
    Affects Versions: 1.0.0
            Reporter: Eugene Koifman
            Assignee: Eugene Koifman


{noformat}
create table if not exists TAB_PART (a int, b int)  partitioned by (p string) 
clustered by (a) into 2  buckets stored as orc TBLPROPERTIES 
('transactional'='true')

   insert into TAB_PART partition(p='blah') values(1,2) //this uses static part
    update TAB_PART set b = 7 where p = 'blah' //this uses DP... WHY?
{noformat}

the Update is rewritten into an Insert stmt but SemanticAnalzyer.genFileSink() 
for this Insert is set up with dynamic partitions

at least in theory, we should be able to analyze the WHERE clause so that 
Insert doesn't have to use DP.



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

Reply via email to