You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/08/05 01:56:05 UTC
[jira] [Created] (DRILL-3606) Wrong results - Lead(char-column)
without PARTITION BY clause
Khurram Faraaz created DRILL-3606:
-------------------------------------
Summary: Wrong results - Lead(char-column) without PARTITION BY clause
Key: DRILL-3606
URL: https://issues.apache.org/jira/browse/DRILL-3606
Project: Apache Drill
Issue Type: Bug
Components: Execution - Flow
Affects Versions: 1.2.0
Environment: private-branch-with-new-window-functions
Reporter: Khurram Faraaz
Assignee: Chris Westin
Window function query that does not use partition by clause in window definition and uses LEAD function returns wrong results, on developer's private branch. This issue may be related to DRILL-3605
Results returned by Drill
{code}
0: jdbc:drill:schema=dfs.tmp> select lead(col2) over (order by col0) lead_col0 from `fewRowsAllData.parquet`;
+-----------+
| lead_col0 |
+-----------+
| NHIN |
| INCACO |
| CACOSCSD |
| COSCSDWYLA |
| SCSDWYLAKSCO |
| SDWYLAKSCONYNY |
| WYLAKSCONYNYSDGA |
| LAKSCONYNYSDGAMOIN |
| KSCONYNYSDGAMOINMNIA |
| CONYNYSDGAMOINMNIAGAMN |
| NYNYSDGAMOINMNIAGAMNMNMI |
| NYSDGAMOINMNIAGAMNMNMIRISD |
| SDGAMOINMNIAGAMNMNMIRISDINWI |
| GAMOINMNIAGAMNMNMIRISDINWIMAIA |
| MOINMNIAGAMNMNMIRISDINWIMAIANDMA |
| INMNIAGAMNMNMIRISDINWIMAIANDMARIME |
| MNIAGAMNMNMIRISDINWIMAIANDMARIMEMNCO |
| IAGAMNMNMIRISDINWIMAIANDMARIMEMNCOOHMO |
| GAMNMNMIRISDINWIMAIANDMARIMEMNCOOHMOGAVT |
| MNMNMIRISDINWIMAIANDMARIMEMNCOOHMOGAVTNDNH |
| MNMIRISDINWIMAIANDMARIMEMNCOOHMOGAVTNDNHRIOR |
| MIRISDINWIMAIANDMARIMEMNCOOHMOGAVTNDNHRIORNCAZ |
| RISDINWIMAIANDMARIMEMNCOOHMOGAVTNDNHRIORNCAZORMD |
| SDINWIMAIANDMARIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMA |
| INWIMAIANDMARIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUT |
| WIMAIANDMARIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWY |
| MAIANDMARIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWY |
| IANDMARIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAK |
| NDMARIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPA |
| MARIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGA |
| RIMEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVT |
| MEMNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTIN |
| MNCOOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWV |
| COOHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMN |
| OHMOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVT |
| MOGAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUT |
| GAVTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVT |
| VTNDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISC |
| NDNHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| NHRIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| RIORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| ORNCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| NCAZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| AZORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| ORMDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| MDHIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| HIMANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| MANYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| NYUTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| UTDEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| DEWYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| WYOHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| OHWYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| WYNHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| NHAKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| AKMDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| MDPAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| PAMNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| MNGAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| GAMOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| MOVTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| VTUTINWYWVIAMNAZVTIAUTWIVTRISCME |
| UTINWYWVIAMNAZVTIAUTWIVTRISCME |
| INWYWVIAMNAZVTIAUTWIVTRISCME |
| WYWVIAMNAZVTIAUTWIVTRISCME |
| WVIAMNAZVTIAUTWIVTRISCME |
| IAMNAZVTIAUTWIVTRISCME |
| MNAZVTIAUTWIVTRISCME |
| AZVTIAUTWIVTRISCME |
| VTIAUTWIVTRISCME |
| IAUTWIVTRISCME |
| UTWIVTRISCME |
| WIVTRISCME |
| VTRISCME |
| RISCME |
| SCME |
| ME |
| null |
+-----------+
78 rows selected (0.301 seconds)
{code}
Results returned by Postgres
{code}
postgres=# select lead(col2) over (order by col0) lead_col0 from tbl_alldata;
lead_col0
-----------
NH
IN
CA
CO
SC
SD
WY
LA
KS
CO
NY
NY
SD
GA
MO
IN
MN
IA
GA
MN
MN
MI
RI
SD
IN
WI
MA
IA
ND
MA
RI
ME
MN
CO
OH
MO
GA
VT
NH
ND
RI
OR
NC
AZ
OR
MD
HI
MA
NY
UT
DE
WY
OH
WY
NH
AK
MD
PA
MN
GA
MO
VT
UT
IN
WY
WV
IA
MN
AZ
VT
IA
UT
WI
VT
RI
SC
ME
(78 rows)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)