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

Vitalii Diravka commented on DRILL-3508:
----------------------------------------

It was solved in scope of DRILL-5546 and -DRILL-4185.
{code:java}
0: jdbc:drill:zk=local> use dfs.tmp;
+-------+--------------------------------------+
|  ok   |               summary                |
+-------+--------------------------------------+
| true  | Default schema changed to [dfs.tmp]  |
+-------+--------------------------------------+
1 row selected (0.099 seconds)
0: jdbc:drill:zk=local> select * from `emptyfolder`;
+--+
|  |
+--+
+--+
No rows selected (1.75 seconds)
{code}
Starting form Drill 1.13 the empty directory is a Drill schemaless table, see 
more:
 
[https://drill.apache.org/docs/data-sources-and-file-formats-introduction/#schemaless-tables]

> IOOB raised if FROM points at an empty directory
> ------------------------------------------------
>
>                 Key: DRILL-3508
>                 URL: https://issues.apache.org/jira/browse/DRILL-3508
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.1.0
>            Reporter: Stefán Baxter
>            Priority: Major
>             Fix For: Future
>
>
> I union select where the right hand side points to an empty directory files 
> with the following error code:
> Error: PARSE ERROR: Index: 0, Size: 0
> [Error Id: fed7527a-9d7a-4980-80f5-ff3f0b92d49b on localhost:31010] 
> (state=,code=0)
> We use this to merge tenant based information and sometimes there are no 
> files on the right hand side of the union. It would be ideal that that 
> scenario would return an empty list rather than an error.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to