Abhishek Girish created DRILL-3358: -------------------------------------- Summary: CUME_DIST window function provides wrong result when only ORDER BY clause is specified Key: DRILL-3358 URL: https://issues.apache.org/jira/browse/DRILL-3358 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Affects Versions: 1.1.0 Reporter: Abhishek Girish Assignee: Deneche A. Hakim
*Drill:* {code:sql} > SELECT CUME_DIST() OVER (ORDER BY ss.ss_store_sk) FROM store_sales ss ORDER > BY 1 LIMIT 20; +---------------------+ | EXPR$0 | +---------------------+ | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | | 0.9923989432198661 | +---------------------+ 20 rows selected (17.317 seconds) {code} *Postgres* {code:sql} # SELECT CUME_DIST() OVER (ORDER BY ss.ss_store_sk) FROM store_sales ss ORDER BY 1 LIMIT 20; cume_dist ------------------- 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 0.158622193275665 (20 rows) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)