[
https://issues.apache.org/jira/browse/HIVE-27194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17708185#comment-17708185
]
vamshi kolanu commented on HIVE-27194:
--------------------------------------
Thanks for the review [~zabetak]. Currently, different databases behave
differently. As part of this PR, we want to start supporting constant
expressions in limit and offset clauses for Hive.
Limit and offset clauses support:
||Database||Integers ||Constant expressions|| Complex Expressions||
|Current Hive |Yes|No|No|
|Impala|Yes|Yes|No|
|Postgres|Yes|Yes|Yes|
|Snowflake|Yes|No |No|
|Mysql|Yes|No |No|
> 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
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)
