[jira] [Commented] (DRILL-2231) CTAS (Parquet) followed by a select query fails via JDBC

["Parth Chandra (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393736#comment-14393736 ] 

Parth Chandra commented on DRILL-2231:
--------------------------------------

[~agirish] Can you verify if this issue still exists. The bug with writing zero size Parquet files has been fixed.

> CTAS (Parquet) followed by a select query fails via JDBC
> --------------------------------------------------------
>
>                 Key: DRILL-2231
>                 URL: https://issues.apache.org/jira/browse/DRILL-2231
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>    Affects Versions: 0.8.0
>            Reporter: Abhishek Girish
>            Assignee: Abhishek Girish
>             Fix For: 0.9.0
>
>         Attachments: drillbit_ctas_par_jdbc.log
>
>
> The following two queries when executed at once, sequentially via JDBC fail:
> (i) create table world_bank_par as select * from `world_bank.json`
> [Succeeds]
> (ii) select * from world_bank_par limit 1
> Query failed: RuntimeException: maprfs:/drill/testdata/json_gaps/json_all_text_mode/world_bank_par/0_0_0.parquet is not a Parquet file (too small)
> (iii) select * from world_bank_par limit 1
> Query failed: RuntimeException: maprfs:/drill/testdata/json_gaps/json_all_text_mode/world_bank_par/0_0_0.parquet is not a Parquet file. expected magic number at tail [80, 65, 82, 49] but found [0, 0, 0, 0]
> Log attached.



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