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)