[DRILL-2906] Json reader with extended json adds extra column

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Storage - JSON, Storage - Writer
• Assignee: Unassigned
• Reporter: Mehant Baid
• Created: 29/Apr/15 18:50
• Updated: 01/Oct/15 16:37

Description

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.

Issue Links

• relates to: DRILL-2976 Set default of extended JSON support for output to false until issues are resolved