[jira] [Comment Edited] (DRILL-2071) Better documentation for JSON reader all_text_mode option

["Kristine (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14295838#comment-14295838 ] 

Kristine edited comment on DRILL-2071 at 1/28/15 8:51 PM:
----------------------------------------------------------

{quote}
This is only mentioned on the wiki in this page, but does not really describe all of the use cases of the feature.
{quote}
What are all the use cases?


was (Author: krishahn):
What are all the use cases?

> Better documentation for JSON reader all_text_mode option
> ---------------------------------------------------------
>
>                 Key: DRILL-2071
>                 URL: https://issues.apache.org/jira/browse/DRILL-2071
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Documentation
>            Reporter: Jason Altekruse
>            Assignee: Bridget Bevens
>             Fix For: 0.7.0
>
>
> Currently Drill will fail by default to read JSON files with changes in schema, or with several different data types in a list. These files can however be read if the store.json.all_text_mode option is set to true. This option will read all data from the JSON files as varchar and from here the data can be casted to an appropriate type (or filtered out in the case where a cast to numeric is desired but some of the data in the column is a string or boolean type). This is only mentioned on the wiki in this page, but does not really describe all of the use cases of the feature. https://cwiki.apache.org/confluence/display/DRILL/Analyzing+Yelp+JSON+Data+with+Apache+Drill



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)