You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "vamshi kolanu (Jira)" <ji...@apache.org> on 2023/03/30 01:32:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-27194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

vamshi kolanu reassigned HIVE-27194:
------------------------------------


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