GitHub user yhuai opened a pull request:

    https://github.com/apache/spark/pull/13395

    [SPARK-14507] [SQL] EXTERNAL keyword in a CTAS statement is not allowed

    ## What changes were proposed in this pull request?
    This PR makes the parser to throw an exception if a hive style CTAS command 
has an external keyword. The main reason of this change is to make the syntax 
consistent with CREATE TABLE USING AS SELECT syntax (it does not allow EXTERNAL 
keyword).
    
    Another options is to make `EXTERNAL` keyword optional. 
    
    ## How was this patch tested?
    HiveDDLCommandSuite
    
    **NOTE: This PR is based on https://github.com/apache/spark/pull/13386, 
which needs to be merged first.**

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/yhuai/spark SPARK-14507-1

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/spark/pull/13395.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #13395
    
----
commit f613d9e6687ac306f54d2e82276561ec5eb6a1ac
Author: Yin Huai <yh...@databricks.com>
Date:   2016-05-28T23:18:49Z

    test cases

commit 1e22d53cb2089841cc4dba4dd71066bb9915c9d6
Author: Yin Huai <yh...@databricks.com>
Date:   2016-05-28T23:19:45Z

    Move the conversion logic to the parser.

commit 2615f676844d19b33552f60cd2849522d5564360
Author: Yin Huai <yh...@databricks.com>
Date:   2016-05-28T23:32:05Z

    Update tests

commit c5cb32cf98248a1941c16b9ed605780f20cbca75
Author: Yin Huai <yh...@databricks.com>
Date:   2016-05-29T04:46:08Z

    Hive style CTAS command does not allow EXTERNAL keyword and PARTITIONED BY 
clause.

commit 220a6e0d76f110f6423d96ce0b25e29e8fcb19f9
Author: Yin Huai <yh...@databricks.com>
Date:   2016-05-29T17:47:49Z

    wip

commit fa8908122a238d6cdc0a9fc0f003221ef5601565
Author: Yin Huai <yh...@databricks.com>
Date:   2016-05-29T18:18:47Z

    Changes related to EXTERNAL will be handled in another PR.

commit 27332df39b36e781c311b35383338f5deb478eea
Author: Yin Huai <yh...@databricks.com>
Date:   2016-05-29T18:26:28Z

    [SPARK-14507] [SQL] EXTERNAL keyword in a CTAS statement is not allowed

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org

Reply via email to