[jira] [Created] (DRILL-3268) queries with empty OVER() clause return empty result set

["Deneche A. Hakim (JIRA)" <ji...@apache.org>]

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)