[DRILL-3358] CUME_DIST window function provides wrong result when only ORDER BY clause is specified

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.1.0
• Fix Version/s: 1.1.0
• Component/s: Query Planning & Optimization
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Abhishek Girish
• Created: 24/Jun/15 20:36
• Updated: 29/Jun/15 23:13
• Resolved: 24/Jun/15 23:40

Description

Drill:

> 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)

Postgres

# 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)

Issue Links

• duplicates: DRILL-3327 row_number function returns incorrect result when only order by clause is specified