[ https://issues.apache.org/jira/browse/DRILL-2906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Phillips updated DRILL-2906: ----------------------------------- Summary: Json reader with extended json adds extra column (was: CTAS with store.format = 'json' returns incorrect results) > Json reader with extended json adds extra column > ------------------------------------------------ > > Key: DRILL-2906 > URL: https://issues.apache.org/jira/browse/DRILL-2906 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON, Storage - Writer > Reporter: Mehant Baid > Assignee: Steven Phillips > Fix For: 1.0.0 > > > Performing a CTAS with 'store.format' = 'json' and querying the table results > in projecting an addition field '*' will null values. Below is a simple repro > 0: jdbc:drill:zk=local> create table t as select timestamp '1980-10-01 > 00:00:00' from cp.`employee.json` limit 1; > +------------+---------------------------+ > | Fragment | Number of records written | > +------------+---------------------------+ > | 0_0 | 1 | > +------------+---------------------------+ > 1 row selected (0.314 seconds) > 0: jdbc:drill:zk=local> select * from t; > +------------+------------+ > | EXPR$0 | * | > +------------+------------+ > | 1980-10-01 00:00:00.0 | null | > +------------+------------+ > Notice in the above result set we get an extra column '*' with null value. -- This message was sent by Atlassian JIRA (v6.3.4#6332)