[ https://issues.apache.org/jira/browse/SPARK-17732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15623707#comment-15623707 ]
Apache Spark commented on SPARK-17732: -------------------------------------- User 'dongjoon-hyun' has created a pull request for this issue: https://github.com/apache/spark/pull/15704 > ALTER TABLE DROP PARTITION should support comparators > ----------------------------------------------------- > > Key: SPARK-17732 > URL: https://issues.apache.org/jira/browse/SPARK-17732 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.0.0 > Reporter: Dongjoon Hyun > > This issue aims to support `comparators`, e.g. '<', '<=', '>', '>=', again in > Apache Spark 2.0 for backward compatibility. > *Spark 1.6.2* > {code} > scala> sql("CREATE TABLE sales(id INT) PARTITIONED BY (country STRING, > quarter STRING)") > res0: org.apache.spark.sql.DataFrame = [result: string] > scala> sql("ALTER TABLE sales DROP PARTITION (country < 'KR')") > res1: org.apache.spark.sql.DataFrame = [result: string] > {code} > *Spark 2.0* > {code} > scala> sql("CREATE TABLE sales(id INT) PARTITIONED BY (country STRING, > quarter STRING)") > res0: org.apache.spark.sql.DataFrame = [] > scala> sql("ALTER TABLE sales DROP PARTITION (country < 'KR')") > org.apache.spark.sql.catalyst.parser.ParseException: > mismatched input '<' expecting {')', ','}(line 1, pos 42) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org