[jira] [Created] (DRILL-5024) CTAS with LIMIT 0 query in SELECT stmt does not create parquet file

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

Khurram Faraaz created DRILL-5024:
-------------------------------------

             Summary: CTAS with LIMIT 0 query in SELECT stmt does not create parquet file
                 Key: DRILL-5024
                 URL: https://issues.apache.org/jira/browse/DRILL-5024
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.8.0
            Reporter: Khurram Faraaz


Note that CTAS was successful
{noformat}
0: jdbc:drill:schema=dfs.tmp> create table regtbl_w0rows as select * from typeall_l LIMIT 0;
+-----------+----------------------------+
| Fragment  | Number of records written  |
+-----------+----------------------------+
| 0_0       | 0                          |
+-----------+----------------------------+
1 row selected (0.51 seconds)
{noformat}

But a SELECT on CTAS created file fails.
{noformat}
0: jdbc:drill:schema=dfs.tmp> select * from regtbl_w0rows;
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 27: Table 'regtbl_w0rows' not found

SQL Query null

[Error Id: 0569cf98-3800-43ee-b635-aa101b016d46 on centos-01.qa.lab:31010] (state=,code=0)
{noformat}

DROP on the CTAS created table also fails
{noformat}
0: jdbc:drill:schema=dfs.tmp> drop table regtbl_w0rows;
Error: VALIDATION ERROR: Table [regtbl_w0rows] not found


[Error Id: fb0b1ea8-f76d-42e2-b69c-4beae2798bdf on centos-01.qa.lab:31010] (state=,code=0)
0: jdbc:drill:schema=dfs.tmp>
{noformat}

Verified that CTAS did not create a physical file in dfs.tmp schema
{noformat}
[test@cent01 bin]# hadoop fs -ls /tmp/regtbl_w0rows
ls: `/tmp/regtbl_w0rows': No such file or directory
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)