[
https://issues.apache.org/jira/browse/DRILL-1449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chris Westin resolved DRILL-1449.
---------------------------------
Resolution: Duplicate
> CTAS in JSON format creates a table even when the SELECT query fails
> --------------------------------------------------------------------
>
> Key: DRILL-1449
> URL: https://issues.apache.org/jira/browse/DRILL-1449
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JSON
> Affects Versions: 0.6.0
> Reporter: Aman Sinha
> Priority: Minor
> Fix For: Future
>
>
> When a CTAS command fails for any reason, it should not create the target
> table. It appears that when the storage output format is JSON, we end up
> creating an empty table. If the output format is Parquet, this works
> correctly.
> 0: jdbc:drill:zk=local> alter session set `store.format` = 'json';
> ..
> 0: jdbc:drill:zk=local> create table orders3 as select * from
> cp.`tpch/orders.parquet` where o_orderdate between '1994-07-01' and
> '1994-09-31' limit 10;
> Query failed: Failure while running fragment. Value 31 for dayOfMonth must be
> in the range [1,30]
> // Now fix the query and re-run :
> 0: jdbc:drill:zk=local> create table orders3 as select * from
> cp.`tpch/orders.parquet` where o_orderdate between '1994-07-01' and
> '1994-09-30' limit 10;
> +------------+------------+
> | ok | summary |
> +------------+------------+
> | false | Table 'orders3' already exists. |
> +------------+------------+
> 0: jdbc:drill:zk=local> select * from orders3;
> +--+
> | |
> +--+
> +--+
> No rows selected
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
