[
https://issues.apache.org/jira/browse/TRAFODION-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16285482#comment-16285482
]
ASF GitHub Bot commented on TRAFODION-2804:
-------------------------------------------
GitHub user EEDY opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1334
[TRAFODION-2804] Limit clause support in statements
LOAD/INSERT/CREATE-TABLE + query
add "LIMIT" clause support for statements create-as-select,
insert-into-select and load-into-select
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/EEDY/incubator-trafodion limit_clause
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1334.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1334
----
commit 083f58d651f7e7ca631590fb7479df3b037d16fc
Author: eedy <cqlc...@gmail.com>
Date: 2017-11-14T09:44:58Z
limit clause support in create-as-select/load-into-select: syntax support
1. add syntax support
commit f574b540d6ba7de35493a672da544887b7d146e6
Author: eedy <cqlc...@gmail.com>
Date: 2017-11-22T12:48:35Z
add limit clause for insert-as-select statement
add limit clause for insert-as-select statement
commit 2299f3dfc156ca230c935c4ac150f7037d5d4dde
Author: eedy <cqlc...@gmail.com>
Date: 2017-12-03T11:43:31Z
add limit clause support for LOAD-INTO statement.
add limit clause support for LOAD-INTO statement.
----
> add "LIMIT" clause support for statements create-as-select and
> load-into-select
> -------------------------------------------------------------------------------
>
> Key: TRAFODION-2804
> URL: https://issues.apache.org/jira/browse/TRAFODION-2804
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Qilin Chen
> Priority: Minor
>
> We don't support "LIMIT" clause in statements CREATE-AS-SELECT and
> LOAD-INTO-SELECT, see below for details:
> --01 : CREATE-AS-SELECT
> SQL>create table comment_table_02 as select * from comment_table limit 100;
> *** ERROR[15001] A syntax error occurred at or before:
> create table comment_table_02 as select * from comment_table limit 100;
> ^ (66
> characters from start of SQL statement) [2017-11-13 15:42:01]
> --02 : LOAD-INTO-SELECT
> SQL>load into comment_table_02 select * from comment_table limit 100;
> *** ERROR[15001] A syntax error occurred at or before:
> load into comment_table_02 select * from comment_table limit 100;
> ^ (60 characters
> from start of SQL statement) [2017-11-13 15:45:31]
> --03 : INSERT-INTO-SELECT
> SQL>insert into test003 select * from test002 limit 4;
> *** ERROR[15001] A syntax error occurred at or before:
> insert into test003 select * from test002 limit 4;
> ^ (47 characters from start of
> SQL statement) [2017-12-11 10:27:03]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
