[jira] [Created] (HIVE-15498) sum() over (order by c) should default the windowing spec to RangeBoundarySpec

["Aihua Xu (JIRA)" <ji...@apache.org>]

Aihua Xu created HIVE-15498:
-------------------------------

             Summary: sum() over (order by c) should default the windowing spec to RangeBoundarySpec
                 Key: HIVE-15498
                 URL: https://issues.apache.org/jira/browse/HIVE-15498
             Project: Hive
          Issue Type: Bug
          Components: PTF-Windowing
    Affects Versions: 2.1.0
            Reporter: Aihua Xu
            Assignee: Aihua Xu


Currently {{sum() over (partition by a)}} without order by will default windowing to RangeBoundarySpec while  {{sum() over (partition by a order by c)}} will default to ValueBoundarySpec.

From the comment 
{noformat}
  /*
   * - A Window Frame that has only the /start/boundary, then it is interpreted as:
         BETWEEN <start boundary> AND CURRENT ROW
   * - A Window Specification with an Order Specification and no Window
   *   Frame is interpreted as:
         ROW BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
   * - A Window Specification with no Order and no Window Frame is interpreted as:
         ROW BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
   */
{noformat}
We were trying to set as "row between". 




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)