drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1449) CTAS in JSON format creates a table even when the SELECT query fails
Date Sun, 28 Dec 2014 23:31:21 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-1449:
----------------------------------
    Fix Version/s: Future
         Priority: Minor  (was: Major)

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

Mime
View raw message