[
https://issues.apache.org/jira/browse/HIVE-27194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17706949#comment-17706949
]
Stamatis Zampetakis commented on HIVE-27194:
--------------------------------------------
Thanks for logging this [~vkolanu]! Before checking the PRI would like to
understand better the motivation and scope behind this change.
If I recall well SQL standard does not allow expression in LIMIT and OFFSET
clauses so I was wondering which other DBMS provide such functionality.
The examples in the description contain only static arithmetic expressions; is
the implementation targeting more complex things or just that. If we are
targeting only static arithmetic expressions then why not putting the final
result directly in the query. In other words what's the benefit of the new
syntax?
> Support expression in limit and offset clauses
> ----------------------------------------------
>
> Key: HIVE-27194
> URL: https://issues.apache.org/jira/browse/HIVE-27194
> Project: Hive
> Issue Type: Task
> Components: Hive
> Reporter: vamshi kolanu
> Assignee: vamshi kolanu
> Priority: Major
>
> As part of this task, support expressions in both limit and offset clauses.
> Currently, these clauses are only supporting integers.
> For example: The following expressions will be supported after this change.
> 1. select key from (select * from src limit (1+2*3)) q1;
> 2. select key from (select * from src limit (1+2*3) offset (3*4*5)) q1;
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
