[
https://issues.apache.org/jira/browse/DRILL-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14959552#comment-14959552
]
Jaroslaw Sosnicki commented on DRILL-3939:
------------------------------------------
$ sqlline -u jdbc:drill:zk=maprdemo:5181
OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was
removed in 8.0
apache drill 1.2.0
"drill baby drill"
0: jdbc:drill:zk=maprdemo:5181> alter session set
`store.json.all_text_mode`=true;
+-------+------------------------------------+
| ok | summary |
+-------+------------------------------------+
| true | store.json.all_text_mode updated. |
+-------+------------------------------------+
1 row selected (0.394 seconds)
0: jdbc:drill:zk=maprdemo:5181> SELECT * FROM `dfs`.`hdvm`.`./t1.json`;
Error: DATA_READ ERROR: Error parsing JSON - You tried to write a Map type when
you are using a ValueWriter of type SingleMapWriter.
File /mapr/demo.mapr.com/data/hcs/hdvm/t1.json
Record 1
Fragment 0:0
[Error Id: 1c936836-06ad-4ceb-b84c-77fccf384e04 on maprdemo:31010]
(state=,code=0)
0: jdbc:drill:zk=maprdemo:5181>
---
Yes it fails with the same error messages.
I am investigating this issue due to the fact that large JSON file I originally
used was generated from XML using apache-camel v2.15.x and v2.16.0. I verified
the syntax of generated JSON files and it was correct.
I assume I should be able to open any syntax validated JSON file in the DRILL.
> 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)
