[
https://issues.apache.org/jira/browse/IGNITE-14555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17459730#comment-17459730
]
Aleksey Plekhanov commented on IGNITE-14555:
--------------------------------------------
[~zstan], have you tried to replace {{range}} with {{{}system_range{}}}:
{noformat}
create table a as select i::tinyint AS i from table(system_range(1, 100, 1))
t1(i){noformat}
?
> Calcite engine. Create table from query result
> ----------------------------------------------
>
> Key: IGNITE-14555
> URL: https://issues.apache.org/jira/browse/IGNITE-14555
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Aleksey Plekhanov
> Priority: Minor
> Labels: calcite3-required, ignite-3
> Time Spent: 2h 20m
> Remaining Estimate: 0h
>
> Provide ability to create table from the result of the query: {{CREATE TABLE
> my_tbl AS <SELECT QUERY>}}.
> Affected tests:
> {{modules/calcite/src/test/sql/types/decimal/decimal_aggregates.test_ignore}}
> {{modules/calcite/src/test/sql/insert/test_insert.test}}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
