You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/05/11 22:46:01 UTC
[jira] [Resolved] (DRILL-2554) Incorrect results for repeated
values when using jdbc
[ 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)