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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.9.0
• Component/s: Client - JDBC
• Assignee: Abhishek Girish
• Reporter: Abhishek Girish
• Created: 12/Feb/15 21:03
• Updated: 14/May/17 00:46
• Resolved: 10/Apr/15 17:44

Description

The following two queries when executed at once, sequentially via JDBC fail:

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.

Issue Links

• relates to: DRILL-1735 JDBC driver's close() leaks resources in local mode