[
https://issues.apache.org/jira/browse/DRILL-3606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Deneche A. Hakim resolved DRILL-3606.
-------------------------------------
Resolution: Fixed
Fixed in private branch
> 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: Deneche A. Hakim
> Labels: window_function
> Fix For: 1.2.0
>
>
> 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)
