[
https://issues.apache.org/jira/browse/DRILL-2071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14295838#comment-14295838
]
Kristine Hahn edited comment on DRILL-2071 at 3/18/15 9:28 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}
Ready for review:
* [Handling Type
Differences|http://drill.apache.org/docs/json-data-model#handling-type-differences]
* [Schema Changes
workaround|http://drill.apache.org/docs/json-data-model#schema-changes]
* [All text mode
option|http://drill.apache.org/docs/handling-different-data-types#all-text-mode-option]
in Data Types reference section
* The [flatten and kvgen
example|http://drill.apache.org/docs/json-data-model#example:-aggregate-loosely-structured-data]
shows that turning off the option is necessary to avoid an error when running
queries on numerics.
Does this cover the documentation needs?
was (Author: krishahn):
{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}
https://docs.google.com/a/maprtech.com/document/d/1jz5jvgFdm7jOldT_ZeY2gH389dKxMiv6fE0LNBJG8EI/
(page 2), Handling Type Differences and the preceding section are ready for
review. Does this cover the documentation needs?
> 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: Kristine Hahn
> 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)
