[ 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)