[
https://issues.apache.org/jira/browse/DRILL-5898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Hou reassigned DRILL-5898:
---------------------------------
Assignee: Robert Hou (was: Vitalii Diravka)
> 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)
