[
https://issues.apache.org/jira/browse/DRILL-1279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14092229#comment-14092229
]
Jacques Nadeau commented on DRILL-1279:
---------------------------------------
We need to figure out how we enable this configuration as REST APIs often
return this type of structure. Assigning to Neeraja to provide feedback on
what people are doing and propose a suggested approach at the query/experience
layer.
> Drill does not provide a way to unflatten a single large json record into sub
> records
> -------------------------------------------------------------------------------------
>
> Key: DRILL-1279
> URL: https://issues.apache.org/jira/browse/DRILL-1279
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JSON
> Reporter: Yash Sharma
> Assignee: Neeraja
> Fix For: Future
>
>
> Error while executing a query on Geo JSON data.
> {quote}
> select t.features[0].properties.name from
> dfs.`/opt/drill/sample-data/geo1.json` t;
> Query failed: Failure while running fragment. Resetting to invalid mark
> [41a66a4a-b8c2-4fc6-a7fc-f1c76e312f32]
> Error: exception while executing query: Failure while trying to get next
> result batch. (state=,code=0)
> {quote}
> Data can be located at:
> https://drive.google.com/file/d/0B7bWVX3BL3wrUGRKaHRyRTFLV2c/edit?usp=sharing
> The data is a valid JSON data (~250 Megs) in a single line.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
