You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "benj (Jira)" <ji...@apache.org> on 2020/03/25 11:20:00 UTC
[jira] [Comment Edited] (DRILL-1755) Add support for arrays and
scalars as first level elements in JSON files
[ https://issues.apache.org/jira/browse/DRILL-1755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17066614#comment-17066614 ]
benj edited comment on DRILL-1755 at 3/25/20, 11:19 AM:
--------------------------------------------------------
The problem appears to have been corrected in 1.17
The error shown previously appearing in 1.16 (see above) no longer appears in 1.17 (see below) :
{code:sql}
drill-embedded 1.17> SELECT 'justfortest' AS mytext FROM dfs.tmp.`example.json`;
+-------------+
| mytext |
+-------------+
| justfortest |
| justfortest |
+-------------+
{code}
was (Author: benj641):
The problem appears to have been corrected in 1.17
The error shown previously appearing in 1.16 (see above) no longer appears in 1.17 (see below) :
{code:sql}
drill-embedded 1.17> SELECT 'justfortest' AS mytext FROM dfs.tmp.`tmp.json`;
+-------------+
| mytext |
+-------------+
| justfortest |
| justfortest |
+-------------+
{code}
> Add support for arrays and scalars as first level elements in JSON files
> ------------------------------------------------------------------------
>
> Key: DRILL-1755
> URL: https://issues.apache.org/jira/browse/DRILL-1755
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Abhishek Girish
> Priority: Major
> Fix For: Future
>
> Attachments: drillbit.log
>
>
> Publicly available JSON data sometimes have the following structure (arrays as first level elements):
> [
> {"accessLevel": "public"
> },
> {"accessLevel": "private"
> }
> ]
> Drill currently does not support Arrays or Scalars as first level elements. Only maps are supported. We should add support for the arrays and scalars.
> Log attached.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)