You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2016/11/14 11:44:58 UTC
[jira] [Created] (DRILL-5040) Interrupted CTAS should not succeed &
should not create physical file on disk
Khurram Faraaz created DRILL-5040:
-------------------------------------
Summary: Interrupted CTAS should not succeed & should not create physical file on disk
Key: DRILL-5040
URL: https://issues.apache.org/jira/browse/DRILL-5040
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow
Affects Versions: 1.9.0
Reporter: Khurram Faraaz
We should not allow CTAS to succeed (i.e create physical file on disk ) in the case where it was interrupted. (vis Ctrl-C)
Drill 1.9.0
git commit ID : db30854
Consider the below CTAS that was interrupted using Ctrl-C
{noformat}
0: jdbc:drill:schema=dfs.tmp> create table temp_t1 as select * from `twoKeyJsn.json`;
[ issue Ctrl-C while the above CTAS is running ]
No rows affected (7.694 seconds)
{noformat}
I verified that physical file was created on disk, even though the above CTAS was Canceled
{noformat}
[root@centos-01 ~]# hadoop fs -ls /tmp/temp_t1*
-rwxr-xr-x 3 root root 36713198 2016-11-14 10:51 /tmp/temp_t1/0_0_0.parquet
{noformat}
We are able to do a select on the CTAS table (above) that was Canceled.
{noformat}
0: jdbc:drill:schema=dfs.tmp> select count(*) from temp_t1;
+----------+
| EXPR$0 |
+----------+
| 3747840 |
+----------+
1 row selected (0.183 seconds)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)