[ 
https://issues.apache.org/jira/browse/HIVE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13240823#comment-13240823
 ] 

Phabricator commented on HIVE-2908:
-----------------------------------

kevinwilfong has commented on the revision "HIVE-2908 [jira] Hive: Extend ALTER 
TABLE DROP PARTITION syntax to use all comparators".

  Looks good, just some cosmetic things.

INLINE COMMENTS
  ql/src/java/org/apache/hadoop/hive/ql/plan/PartitionSpec.java:61 Why do you 
change the != to <>, why not use whichever the user chose to use?
  ql/src/test/results/clientnegative/drop_partition_filter_failure.q.out:18 
This error message seems confusing, the filter was < 1, so it should not be 
surprising that the partition '1' was not found.  (I know why this exception 
was thrown, I'm just saying the message could be improved)
  ql/src/test/queries/clientpositive/drop_partitions_filter.q:18 Out of 
curiosity, does the behavior change if you use d<=2 vs. d<='2'?

REVISION DETAIL
  https://reviews.facebook.net/D2523

                
> Hive: Extend ALTER TABLE DROP PARTITION syntax to use all comparators
> ---------------------------------------------------------------------
>
>                 Key: HIVE-2908
>                 URL: https://issues.apache.org/jira/browse/HIVE-2908
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Sambavi Muthukrishnan
>            Assignee: Sambavi Muthukrishnan
>            Priority: Minor
>         Attachments: HIVE-2908.D2523.1.patch
>
>   Original Estimate: 96h
>  Remaining Estimate: 96h
>
> To drop a partition from a Hive table, this works:
> ALTER TABLE foo DROP PARTITION(ds = 'date')
> ...but it should also work to drop all partitions prior to date.
> ALTER TABLE foo DROP PARTITION(ds < 'date')
> This task is to implement ALTER TABLE DROP PARTITION for all of the 
> comparators, < > <= >= <> = != instead of just for =.

--
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

        

Reply via email to