[DRILL-1255] Allow change from integer to double type and vice versa in JSON reader

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Assignee: Unassigned
• Reporter: Jason Altekruse
• Created: 05/Aug/14 21:17
• Updated: 19/Jun/17 00:04

Description

Currently the JSON reader for drill will fail if there is any schema change in a file. For the time being, this is expected for a significant change in type, such as a change between types without clear implicit casting rules, such as a change between any combination of string, bool, or numeric types. We however do want to support changing from an integer to a double type (any number with a decimal point is read as a double value) or vice versa. This is also related to mixed integer and double types in arrays, which should also be supported.

Issue Links

• is duplicated by: DRILL-1193 Drill hangs when json data contains an array with more than one value and one of them is a decimal
• is related to: DRILL-4824 Null maps / lists and non-provided state support for JSON fields. Numeric types promotion.
• supercedes: DRILL-1193 Drill hangs when json data contains an array with more than one value and one of them is a decimal
• supercedes: DRILL-1204 Problem selecting the following json format (a mongodb export)