[
https://issues.apache.org/jira/browse/DRILL-3509?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14990740#comment-14990740
]
Khurram Faraaz commented on DRILL-3509:
---------------------------------------
RHS of UNION ALL has a directory which has an empty JSON file in it. On the LHS
of UNION ALL is a non-empty JSON file. Verified that there is no PARSER ERROR.
{code}
[root@centos-01 ~]# ls -lrt empty
total 0
-rw-r--r-- 1 root root 0 Nov 4 23:42 empty.json
0: jdbc:drill:schema=dfs.tmp> select key1 from `non_empty.json` union all
select key1 from empty;
+---------+
| key1 |
+---------+
| value1 |
+---------+
1 row selected (0.89 seconds)
{code}
> Empty JSON files trigger exception when used in a union
> -------------------------------------------------------
>
> Key: DRILL-3509
> URL: https://issues.apache.org/jira/browse/DRILL-3509
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.1.0
> Reporter: Stefán Baxter
> Assignee: Sean Hsuan-Yi Chu
> Fix For: 1.2.0
>
>
> When the right hand side of a union is a directory search that involving an
> empty json file (or a empty log file waiting for first log lines) causes this
> exception:
> {
> "errorMessage" : "PARSE ERROR: From line 1, column 564 to line 1, column
> 574: Column 'occurred_at' not found in any table\n\n\n[Error Id:
> bef7370a-3c4e-4c35-8126-33c391ecb8ce on localhost:31010]"
> }
> where 'occurred_at' is the first column used/requested.
> This works fine if no union is involved but it happens regardless of the
> left/right position of the directory search if union is being called.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
