[
https://issues.apache.org/jira/browse/DRILL-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14214173#comment-14214173
]
Jacques Nadeau commented on DRILL-1256:
---------------------------------------
Drill's perspective is a non-existent column and a column with no value are
equivalent.
> Drill is not displaying the column when the json has a null value for the
> column and the file contains a single record
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-1256
> URL: https://issues.apache.org/jira/browse/DRILL-1256
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JSON
> Reporter: Rahul Challapalli
> Priority: Minor
>
> git.commit.id.abbrev=98b208e
> JSON File Used :
> {code}
> {
> "a" : null,
> "b" : 1
> }
> {code}
> Query :
> {code}
> select * from `temp.json`;
> +------------+
> | b |
> +------------+
> | 1 |
> +------------+
> {code}
> However for the below data set it works fine
> {code}
> {
> "a" : null,
> "b" : 1
> }
> {
> "a" : 1,
> "b" : null
> }
> {code}
> Query :
> {code}
> select * from `temp.json`;
> +------------+------------+
> | b | a |
> +------------+------------+
> | 1 | null |
> | null | 1 |
> +------------+------------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
