[
https://issues.apache.org/jira/browse/HIVE-15553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
N Campbell updated HIVE-15553:
------------------------------
Attachment: TOLAP
> expression to compute running sum fails with Failed to breakup Windowing
> invocations into Groups
> ------------------------------------------------------------------------------------------------
>
> Key: HIVE-15553
> URL: https://issues.apache.org/jira/browse/HIVE-15553
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.0
> Reporter: N Campbell
> Attachments: TOLAP
>
>
> The following statement will fail in Hive.Expecting to compute the following
> as is possible in Oracle, Db2, Teradata, ...
> select c1, sum ( sum ( c3 ) ) over ( order by c1 ) from certtext.tolap
> group by c1
> Error: Error while compiling statement: FAILED: SemanticException Failed to
> breakup Windowing invocations into Groups. At least 1 group must only depend
> on input columns. Also check for circular dependencies.
> Underlying error: org.apache.hadoop.hive.ql.parse.SemanticException: Line
> 1:18 Expression not in GROUP BY key 'c3'
> SQLState: 42000
> ErrorCode: 40000
> Note: if you use the following statement it can encounter a Tez error when c1
> is a char vs string type.
> select c1, sum( c3 ), sum ( sum ( c3 ) ) over ( order by c1 ) from
> certtext.tolap group by c1
> C1 SUM(C3) SUM(SUM(C3))OVER(ORDERBYC1)
> AAA 50 50
> BBB 20 70
> CCC 30 100
> DDD 40 140
> <null> 50 190
> Table definition
> create table if not exists TOLAP (RNUM int , C1 char(3), C2 char(2), C3 int,
> C4 int)
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
> STORED AS textfile ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
