[jira] [Commented] (HIVE-27194) Support expression in limit and offset clauses

["vamshi kolanu (Jira)" <ji...@apache.org>]

    [ 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)