drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-2554) Incorrect results for repeated values when using jdbc
Date Mon, 11 May 2015 20:46:01 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-2554.
-----------------------------------
    Resolution: Fixed

resolved by DRILL-2150

> Incorrect results for repeated values when using jdbc
> -----------------------------------------------------
>
>                 Key: DRILL-2554
>                 URL: https://issues.apache.org/jira/browse/DRILL-2554
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC, Execution - Data Types
>    Affects Versions: 0.8.0
>            Reporter: Khurram Faraaz
>            Assignee: Parth Chandra
>            Priority: Critical
>             Fix For: 1.0.0
>
>
> Data is missing from the output of select * from JSON data file statement. Data pertaining
to key2 and key3 and key4 is missing from the output of the below select statement. I had
enabled `store.json.all_text_mode`=true for that session.
> {code}
> 0: jdbc:drill:> alter session set `store.json.all_text_mode`=true;
> +------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | true       | store.json.all_text_mode updated. |
> +------------+------------+
> 1 row selected (0.022 seconds)
> 0: jdbc:drill:> select * from `testJsnData02.json`;
> +------------+------------+------------+------------+------------+
> |    key     |    key1    |    key2    |    key3    |    key4    |
> +------------+------------+------------+------------+------------+
> | 12345      | {}         | []         | {}         | []         |
> | -123456    | {}         | []         | {}         | null       |
> | 0          | {}         | []         | {}         | null       |
> | -99999.999 | {}         | []         | {}         | null       |
> | 99999999.9876 | {}         | []         | {}         | null       |
> | Hello World! | {}         | []         | {}         | null       |
> | this is a long string, not very long though! | {}         | []         | {}       
 | null       |
> | true       | {}         | []         | {}         | null       |
> | false      | {}         | []         | {}         | null       |
> | null       | {}         | []         | {}         | null       |
> | 2147483647 | {}         | []         | {}         | null       |
> | 1100110010101010100101010101010101 | {}         | []         | {}         | null  
    |
> | 2008-1-23 14:24:23 | {}         | []         | {}         | null       |
> | 2008-2-23  | {}         | []         | {}         | null       |
> | 10:20:30.123 | {}         | null       | {}         | null       |
> | -1         | {}         | null       | {}         | null       |
> | 3.147      | {}         | null       | {}         | null       |
> | null       | {"id":"1000.997"} | null       | {}         | null       |
> | null       | {}         | null       | {}         | null       |
> | null       | {}         | null       | {}         | null       |
> | null       | {}         | null       | {}         | null       |
> | abcdefghijklmnopqrstuvwxyz1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ    12345 aeiou | {}
        | null       | {}         | null       |
> +------------+------------+------------+------------+------------+
> 22 rows selected (0.069 seconds)
> 0: jdbc:drill:> select * from sys.version;
> +------------+----------------+-------------+-------------+------------+
> | commit_id  | commit_message | commit_time | build_email | build_time |
> +------------+----------------+-------------+-------------+------------+
> | f658a3c513ddf7f2d1b0ad7aa1f3f65049a594fe | DRILL-2209 Insert ProjectOperator with MuxExchange
| 09.03.2015 @ 01:49:18 EDT | Unknown     | 09.03.2015 @ 04:52:49 EDT |
> +------------+----------------+-------------+-------------+------------+
> 1 row selected (0.041 seconds)
> {code}
> The data that I used in my test was
> {code}
> {"key":12345}
> {"key":-123456}
> {"key":0}
> {"key":-99999.999}
> {"key":99999999.9876}
> {"key":"Hello World!"}
> {"key":"this is a long string, not very long though!"}
> {"key":true}
> {"key":false}
> {"key":null}
> {"key":2147483647}
> {"key":1100110010101010100101010101010101}
> {"key":"2008-1-23 14:24:23"}
> {"key":"2008-2-23"}
> {"key":"10:20:30.123"}
> {"key":-1}
> {"key":3.147}
> {"key1":{"id":1000.997}}
> {"key2":[1,2,3,4,-1,0,135.987,99999,-9999.876,2147483647,"test string",null,true,false]}
> {"key3":{"id":null}}
> {"key4":[null]}
> {"key":"abcdefghijklmnopqrstuvwxyz1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ    12345 aeiou"}
> {code}



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

Mime
View raw message