Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Wed, 25 Oct 2017 18:48:00 +0000 (UTC)
From: "Vitalii Diravka (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13111538.1508793482000.59907.1508957280114@Atlassian.JIRA>
In-Reply-To: <JIRA.13111538.1508793482000@Atlassian.JIRA>
References: <JIRA.13111538.1508793482000@Atlassian.JIRA> <JIRA.13111538.1508793482348@jira-lw-us.apache.org>
Subject: [jira] [Commented] (DRILL-5898) Query returns columns in the wrong
 order
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 25 Oct 2017 18:48:05 -0000


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

Vitalii Diravka commented on DRILL-5898:
----------------------------------------

[~rhou] Wrong column ordering for queries with ORDER BY and LIMIT clauses was fixed with commit for DRILL-5845. Feel free to edit the baseline values.
And looks like the issue mentioned by Boaz is different and root cause is unknown yet.

> Query returns columns in the wrong order
> ----------------------------------------
>
>                 Key: DRILL-5898
>                 URL: https://issues.apache.org/jira/browse/DRILL-5898
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Relational Operators
>    Affects Versions: 1.11.0
>            Reporter: Robert Hou
>            Assignee: Robert Hou
>            Priority: Blocker
>             Fix For: 1.12.0
>
>
> This is a regression.  It worked with this commit:
> {noformat}
> f1d1945b3772bb782039fd6811e34a7de66441c8	DRILL-5582: C++ Client: [Threat Modeling] Drillbit may be spoofed by an attacker and this may lead to data being written to the attacker's target instead of Drillbit
> {noformat}
> It fails with this commit, although there are six commits total between the last good one and this one:
> {noformat}
> b0c4e0486d6d4620b04a1bb8198e959d433b4840	DRILL-5876: Use openssl profile to include netty-tcnative dependency with the platform specific classifier
> {noformat}
> Query is:
> {noformat}
> select * from dfs.`/drill/testdata/tpch100_dir_partitioned_50000files/lineitem` where dir0=2006 and dir1=12 and dir2=15 and l_discount=0.07 order by l_orderkey, l_extendedprice limit 10
> {noformat}
> Columns are returned in a different order.  Here are the expected results:
> {noformat}
> foxes. furiously final ideas cajol	1994-05-27	0.07	1731.42	4	F	653442	4965666.0	1.0	1994-06-23	A	1994-06-22	NONE	SHIP	215671	0.07	2006	12	15 (1 time(s))
> lly final account	1994-11-09	0.07	45881.78	3	F	653412	1.320809E7	46.0	1994-11-24	R	1994-11-08	TAKE BACK RETURN	REG AIR	458104	0.08	2006	12	15 (1 time(s))
>  the asymptotes	1997-12-29	0.07	60882.8	6	O	653413	1.4271413E7	44.0	1998-02-04	N	1998-01-20	DELIVER IN PERSON	MAIL	21456	0.05	2006	12	15 (1 time(s))
> carefully a	1996-09-23	0.07	5381.88	2	O	653378	1.6702792E7	3.0	1996-11-14	N	1996-10-15	NONE	REG AIR	952809	0.05	2006	12	15 (1 time(s))
> ly final requests. boldly ironic theo	1995-09-04	0.07	2019.94	2	O	653380	2416094.0	2.0	1995-11-14	N	1995-10-18	COLLECT COD	FOB	166101	0.02	2006	12	15 (1 time(s))
> alongside of the even, e	1996-02-14	0.07	86140.32	2	O	653409	5622872.0	48.0	1996-05-02	N	1996-04-22	NONE	SHIP	372888	0.04	2006	12	15 (1 time(s))
> es. regular instruct	1996-10-18	0.07	25194.0	1	O	653382	6048060.0	25.0	1996-08-29	N	1996-08-20	DELIVER IN PERSON	AIR	798079	0.0	2006	12	15 (1 time(s))
> en package	1993-09-19	0.07	18718.32	2	F	653440	1.372054E7	12.0	1993-09-12	A	1993-09-09	DELIVER IN PERSON	TRUCK	970554	0.0	2006	12	15 (1 time(s))
> ly regular deposits snooze. unusual, even 	1998-01-18	0.07	12427.92	1	O	653413	2822631.0	8.0	1998-02-09	N	1998-02-05	TAKE BACK RETURN	REG AIR	322636	0.01	2006	12	15 (1 time(s))
>  ironic ideas. bra	1996-10-13	0.07	64711.53	3	O	653383	6806672.0	41.0	1996-12-06	N	1996-11-10	TAKE BACK RETURN	AIR	556691	0.01	2006	12	15 (1 time(s))
> {noformat}
> Here are the actual results:
> {noformat}
> 2006	12	15	653383	6806672	556691	3	41.0	64711.53	0.07	0.01	N	O	1996-11-10	1996-10-13	1996-12-06	TAKE BACK RETURN	AIR	 ironic ideas. bra
> 2006	12	15	653378	16702792	952809	2	3.0	5381.88	0.07	0.05	N	O	1996-10-15	1996-09-23	1996-11-14	NONE	REG AIR	carefully a
> 2006	12	15	653380	2416094	166101	2	2.0	2019.94	0.07	0.02	N	O	1995-10-18	1995-09-04	1995-11-14	COLLECT COD	FOB	ly final requests. boldly ironic theo
> 2006	12	15	653413	2822631	322636	1	8.0	12427.92	0.07	0.01	N	O	1998-02-05	1998-01-18	1998-02-09	TAKE BACK RETURN	REG AIR	ly regular deposits snooze. unusual, even 
> 2006	12	15	653382	6048060	798079	1	25.0	25194.0	0.07	0.0	N	O	1996-08-20	1996-10-18	1996-08-29	DELIVER IN PERSON	AIR	es. regular instruct
> 2006	12	15	653442	4965666	215671	4	1.0	1731.42	0.07	0.07	A	F	1994-06-22	1994-05-27	1994-06-23	NONE	SHIP	foxes. furiously final ideas cajol
> 2006	12	15	653413	14271413	21456	6	44.0	60882.8	0.07	0.05	N	O	1998-01-20	1997-12-29	1998-02-04	DELIVER IN PERSON	MAIL	 the asymptotes
> 2006	12	15	653412	13208090	458104	3	46.0	45881.78	0.07	0.08	R	F	1994-11-08	1994-11-09	1994-11-24	TAKE BACK RETURN	REG AIR	lly final account
> 2006	12	15	653440	13720540	970554	2	12.0	18718.32	0.07	0.0	A	F	1993-09-09	1993-09-19	1993-09-12	DELIVER IN PERSON	TRUCK	en package
> 2006	12	15	653409	5622872	372888	2	48.0	86140.32	0.07	0.04	N	O	1996-04-22	1996-02-14	1996-05-02	NONE	SHIP	alongside of the even, e
> {noformat}


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)