[ https://issues.apache.org/jira/browse/DRILL-3813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Barclay (Drill) updated DRILL-3813: ------------------------------------------ Description: Trying to use as a table a directory subtree that has no descendent files (but zero or more descendent directories) yields what seems to be a partially handled index out-of-bounds condition. For example, with {{/tmp/empty_directory}} being an empty directory: {noformat} 0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`empty_directory`; Error: VALIDATION ERROR: Index: 0, Size: 0 [Error Id: 747425c9-5350-4813-9f0d-ecf580e15101 on dev-linux2:31010] (state=,code=0) 0: jdbc:drill:zk=local> {noformat} Also, with {{/tmp/no_child_files_subtree}} having two child directories and a grandchild directory, but not descendent files: 0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`no_child_files_subtree`; Error: VALIDATION ERROR: Index: 0, Size: 0 [Error Id: abc90424-8434-4403-b44b-0ba69ef43151 on dev-linux2:31010] (state=,code=0) 0: jdbc:drill:zk=local> {noformat} A directory subtree having no files was expected to be taken as a table with no rows (and a null schema). was: Trying to use as a table a directory subtree that has no descendent files (but zero or more descendent directories) yields what seems to be a partially handled index out-of-bounds condition. For example, with {{/tmp/empty_directory}} being an empty directory: {noformat} 0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`empty_directory`; Error: VALIDATION ERROR: Index: 0, Size: 0 [Error Id: 747425c9-5350-4813-9f0d-ecf580e15101 on dev-linux2:31010] (state=,code=0) 0: jdbc:drill:zk=local> {noformat} Also, with {{/tmp/no_child_files_subtree}} having two child directories and a grandchild directory, but not descendent files: 0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`no_child_files_subtree`; Error: VALIDATION ERROR: Index: 0, Size: 0 [Error Id: abc90424-8434-4403-b44b-0ba69ef43151 on dev-linux2:31010] (state=,code=0) 0: jdbc:drill:zk=local> {noformat} > table from directory subtree having no descendent files fails with index error > ------------------------------------------------------------------------------ > > Key: DRILL-3813 > URL: https://issues.apache.org/jira/browse/DRILL-3813 > Project: Apache Drill > Issue Type: Bug > Components: SQL Parser, Storage - Other > Reporter: Daniel Barclay (Drill) > Assignee: Aman Sinha > > Trying to use as a table a directory subtree that has no descendent files > (but zero or more descendent directories) yields what seems to be a partially > handled index out-of-bounds condition. > For example, with {{/tmp/empty_directory}} being an empty directory: > {noformat} > 0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`empty_directory`; > Error: VALIDATION ERROR: Index: 0, Size: 0 > [Error Id: 747425c9-5350-4813-9f0d-ecf580e15101 on dev-linux2:31010] > (state=,code=0) > 0: jdbc:drill:zk=local> > {noformat} > Also, with {{/tmp/no_child_files_subtree}} having two child directories and a > grandchild directory, but not descendent files: > 0: jdbc:drill:zk=local> SELECT * FROM `dfs`.`tmp`.`no_child_files_subtree`; > Error: VALIDATION ERROR: Index: 0, Size: 0 > [Error Id: abc90424-8434-4403-b44b-0ba69ef43151 on dev-linux2:31010] > (state=,code=0) > 0: jdbc:drill:zk=local> > {noformat} > A directory subtree having no files was expected to be taken as a table with > no rows (and a null schema). -- This message was sent by Atlassian JIRA (v6.3.4#6332)