Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BF4471800A for ; Wed, 5 Aug 2015 15:58:04 +0000 (UTC) Received: (qmail 10929 invoked by uid 500); 5 Aug 2015 15:58:04 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 10899 invoked by uid 500); 5 Aug 2015 15:58:04 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 10888 invoked by uid 99); 5 Aug 2015 15:58:04 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Aug 2015 15:58:04 +0000 Date: Wed, 5 Aug 2015 15:58:04 +0000 (UTC) From: "Deneche A. Hakim (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-3606) Wrong results - Lead(char-column) without PARTITION BY clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-3606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3606: ------------------------------------ Environment: private branch: https://github.com/adeneche/incubator-drill/tree/new-window-funcs (was: private-branch-with-new-window-functions) > 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: https://github.com/adeneche/incubator-drill/tree/new-window-funcs > 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)