[DRILL-2775] message error not clear when doing a select or ctas on empty folder

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 1.4.0
• Fix Version/s: 1.13.0
• Component/s: Metadata
• Assignee: Vitalii Diravka
• Reporter: Rahul Kumar Challapalli
• Created: 13/Apr/15 23:54
• Updated: 10/Dec/18 12:21
• Resolved: 06/Dec/18 14:30

Description

if you have an empty folder "emptyfolder", you get a cryptic error message when you try to query the folder or CTAS a table that has the same name of the empty folder:

0: jdbc:drill:zk=local> select * from emptyfolder;
Error: PARSE ERROR: Index: 0, Size: 0

[Error Id: ef86154b-8219-4b48-84bf-cb318f7d4ae4 on abdel-11.qa.lab:31010] (state=,code=0)

0: jdbc:drill:zk=local> create table emptyfolder as select * from `test.json`;
Error: SYSTEM ERROR: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

[Error Id: 1c3965f4-1566-4df6-9bb6-a91211771976 on abdel-11.qa.lab:31010] (state=,code=0)

Issue Links

• is duplicated by: DRILL-2618 BasicFormatMatcher calls getFirstPath(...) without checking # of paths is not zero
• is part of: DRILL-5546 Schema change problems caused by empty batch
• is part of: DRILL-4185 UNION ALL involving empty directory on any side of union all results in Failed query