okumin commented on PR #4981: URL: https://github.com/apache/hive/pull/4981#issuecomment-1892395365
Reading the description of HIVE-27960 and quickly testing the test case on my machine, I would say it should be merged into the 2.3 branch. The current master is likely to work without the problem. ### Hive 2.3 ``` Beeline version 2.3.8 by Apache Hive 0: jdbc:hive2://hive-hiveserver2:10000/defaul> create function row_number2 as 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRowNumber'; No rows affected (0.79 seconds) 0: jdbc:hive2://hive-hiveserver2:10000/defaul> select row_number2() over(); 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: Invalid function row_number2 (state=42000,code=40000) ``` ### Hive 3.1 ``` Beeline version 3.1.2 by Apache Hive 0: jdbc:hive2://hive-hiveserver2:10000/defaul> create function row_number2 as 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRowNumber'; ... No rows affected (0.995 seconds) 0: jdbc:hive2://hive-hiveserver2:10000/defaul> select row_number2() over(); ... +-----------------------+ | row_number2_window_0 | +-----------------------+ | 1 | +-----------------------+ 1 row selected (12.93 seconds) ``` ### Hive 4(latest master) ``` Beeline version 4.0.0-beta-2-SNAPSHOT by Apache Hive 0: jdbc:hive2://hive-hiveserver2:10000/defaul> create function row_number2 as 'org.apache.hadoop.hive.ql.udf.generic.GenericUDAFRowNumber'; ... No rows affected (1.582 seconds) 0: jdbc:hive2://hive-hiveserver2:10000/defaul> select row_number2() over(); ... +-----------------------+ | row_number2_window_0 | +-----------------------+ | 1 | +-----------------------+ 1 row selected (16.311 seconds) ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
