You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Deneche A. Hakim (JIRA)" <ji...@apache.org> on 2015/06/10 01:33:00 UTC
[jira] [Created] (DRILL-3268) queries with empty OVER() clause
return empty result set
Deneche A. Hakim created DRILL-3268:
---------------------------------------
Summary: queries with empty OVER() clause return empty result set
Key: DRILL-3268
URL: https://issues.apache.org/jira/browse/DRILL-3268
Project: Apache Drill
Issue Type: Bug
Reporter: Deneche A. Hakim
Assignee: Deneche A. Hakim
The following query returns, incorrectly, an empty result set:
{noformat}
0: jdbc:drill:zk=local> SELECT employee_id, position_id, salary, SUM(salary) OVER() FROM cp.`employee.json` LIMIT 1000;
+--------------+--------------+---------+---------+
| employee_id | position_id | salary | EXPR$3 |
+--------------+--------------+---------+---------+
+--------------+--------------+---------+---------+
No rows selected (0.287 seconds)
{noformat}
DRILL-1862 is required otherwise such queries won't plan at all.
The problem is caused by WindowFrameRecordBatch.buildSchema() which assumes the very first batch to be an empty batch that only contains the schema, which is not the case when using OVER()
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)