[
https://issues.apache.org/jira/browse/HIVE-18?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18083795#comment-18083795
]
Shohei Okumiya commented on HIVE-18:
------------------------------------
I believe we now support the feature.
{code:text}
0: jdbc:hive2://localhost:10000/> SELECT * FROM test;
...
+----------+
| test.id |
+----------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
+----------+
0: jdbc:hive2://localhost:10000/> SELECT * FROM test LIMIT 2, 1;
+----------+
| test.id |
+----------+
| 3 |
+----------+
{code}
> Hive: support of SELECT ... LIMIT N,M
> -------------------------------------
>
> Key: HIVE-18
> URL: https://issues.apache.org/jira/browse/HIVE-18
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Zheng Shao
> Priority: Major
>
> Hive now supports LIMIT N which outputs the first N rows of a table/query
> result. It should be a no-brainer to support LIMIT N,M which outputs the N to
> N+M-1 rows. See http://dev.mysql.com/doc/refman/5.0/en/select.html for MySQL
> syntax.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
