You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2023/04/06 16:43:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-27194?focusedWorklogId=855353&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-855353 ]

ASF GitHub Bot logged work on HIVE-27194:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 06/Apr/23 16:42
            Start Date: 06/Apr/23 16:42
    Worklog Time Spent: 10m 
      Work Description: zabetak commented on code in PR #4132:
URL: https://github.com/apache/hive/pull/4132#discussion_r1159878060


##########
ql/src/test/queries/clientpositive/limit_expression.q:
##########
@@ -0,0 +1,11 @@
+--! qt:dataset:src
+

Issue Time Tracking
-------------------

    Worklog Id:     (was: 855353)
    Time Spent: 0.5h  (was: 20m)

> 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: 0.5h
>  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)