You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/04/04 08:48:33 UTC
[jira] [Updated] (DRILL-2562) Order by over trimmed key, results in
incorrect ordering
[ https://issues.apache.org/jira/browse/DRILL-2562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Khurram Faraaz updated DRILL-2562:
----------------------------------
Environment:
| f658a3c513ddf7f2d1b0ad7aa1f3f65049a594fe | DRILL-2209 Insert ProjectOperator with MuxExchange | 09.03.2015 @ 01:49:18 EDT
was:
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.04 seconds)
> Order by over trimmed key, results in incorrect ordering
> --------------------------------------------------------
>
> Key: DRILL-2562
> URL: https://issues.apache.org/jira/browse/DRILL-2562
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Affects Versions: 0.8.0
> Environment: | f658a3c513ddf7f2d1b0ad7aa1f3f65049a594fe | DRILL-2209 Insert ProjectOperator with MuxExchange | 09.03.2015 @ 01:49:18 EDT
> Reporter: Khurram Faraaz
> Assignee: Steven Phillips
> Priority: Critical
> Attachments: longStringInJsnData.json
>
>
> Input data in JSON data file has prevailing and trailing spaces for some of the values. Trimming the whitespace and then doing an order by over the trimmed results, we see the query returned results in in correct ordering. Each value is a string value. Some of the strings are very long in length (they have 1000-2049 characters in them).
> {code}
> 0: jdbc:drill:> select trim(key) from `longStringInJsnData.json` order by key;
> +------------+
> | EXPR$0 |
> +------------+
> | p |
> | m |
> | a |
> | aeiou |
> | h |
> | z |
> | Hello World! |
> ...
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)