drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jaroslaw Sosnicki (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3939) Drill failed to pars valid JSON object
Date Thu, 15 Oct 2015 21:16:05 GMT

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

Jaroslaw Sosnicki commented on DRILL-3939:
------------------------------------------

In order to make drill work I preprocess XML file and insert empty object in front of single
item where subsequent items are elements of the arrays:
...
...
<Pool />
<Pool key=value />
...
...
apache-camel will convert above construct in to single item array instead of the MAP:
...
Pool : [
      { key:value }
]
...

thus creating a workaround solution for the drill issue.

> Drill failed to pars valid JSON object
> --------------------------------------
>
>                 Key: DRILL-3939
>                 URL: https://issues.apache.org/jira/browse/DRILL-3939
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 1.0.0, 1.1.0, 1.2.0
>         Environment: Redhat Linux 6.7 Java 1.7 , 1.8
>            Reporter: Jaroslaw Sosnicki
>
> The following valid JSON object queried from DRILL using various clients:
> --- t.json start---
> {
>     "l1": {
>         "f1": "text1",
>         "f2": {
>             "command": "list",
>             "StorageArray": [
>                 {
>                     "array1": "Array1",
>                     "Pool": {
>                         "myPool": "PoolName"
>                     }
>                 },
>                 {
>                     "array2": "Arrays2",
>                     "Pool": [
>                         {
>                             "myPool": "PoolName1"
>                         },
>                         {
>                             "myPool": "PoolName2"
>                         }
>                     ]
>                 }
>             ]
>         }
>     }
> }
> --- t.json end ---
> Generates the following error:
> ----
> ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: SELECT * FROM `dfs`.`hdvm`.`./t.json`
LIMIT 100
> [30027]Query execution error. Details:[ 
> DATA_READ ERROR: You tried to write a Map type when you are using a ValueWriter of type
SingleMapWriter.
> File  /mapr/demo.mapr.com/data/hcs/hdvm/t.json
> Record  1
> Line  16
> Column  39
> Field  Pool
> Line  16
> Column  39
> Field  Pool
> Fragment 0:0
> [Error Id: 13e7a786-1135-410f-a4f0-877eab9222d6 on maprdemo:31010]
> ]----



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

Mime
View raw message