drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Hou (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5898) Query returns columns in the wrong order
Date Mon, 23 Oct 2017 21:19:00 GMT
Robert Hou created DRILL-5898:
---------------------------------

             Summary: 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: Vitalii Diravka
            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)

Mime
View raw message