diff options
author | gatorsmile <gatorsmile@gmail.com> | 2016-08-08 22:26:44 +0800 |
---|---|---|
committer | Wenchen Fan <wenchen@databricks.com> | 2016-08-08 22:26:44 +0800 |
commit | ab126909ce381842dbb057d480a1f9bee1b4f38e (patch) | |
tree | 1e1c774ca8bc45e82be2f392ed4dee4b32e23adf /sql/core/src/test | |
parent | 94a9d11ed1f61205af8067bf17d14dc93935ddf8 (diff) | |
download | spark-ab126909ce381842dbb057d480a1f9bee1b4f38e.tar.gz spark-ab126909ce381842dbb057d480a1f9bee1b4f38e.tar.bz2 spark-ab126909ce381842dbb057d480a1f9bee1b4f38e.zip |
[SPARK-16457][SQL] Fix Wrong Messages when CTAS with a Partition By Clause
#### What changes were proposed in this pull request?
When doing a CTAS with a Partition By clause, we got a wrong error message.
For example,
```SQL
CREATE TABLE gen__tmp
PARTITIONED BY (key string)
AS SELECT key, value FROM mytable1
```
The error message we get now is like
```
Operation not allowed: Schema may not be specified in a Create Table As Select (CTAS) statement(line 2, pos 0)
```
However, based on the code, the message we should get is like
```
Operation not allowed: A Create Table As Select (CTAS) statement is not allowed to create a partitioned table using Hive's file formats. Please use the syntax of "CREATE TABLE tableName USING dataSource OPTIONS (...) PARTITIONED BY ...\" to create a partitioned table through a CTAS statement.(line 2, pos 0)
```
Currently, partitioning columns is part of the schema. This PR fixes the bug by changing the detection orders.
#### How was this patch tested?
Added test cases.
Author: gatorsmile <gatorsmile@gmail.com>
Closes #14113 from gatorsmile/ctas.
Diffstat (limited to 'sql/core/src/test')
0 files changed, 0 insertions, 0 deletions