[jira] [Commented] (IGNITE-14555) Calcite engine. Create table from query result

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-14555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17459711#comment-17459711 ] 

Evgeny Stanilovsky commented on IGNITE-14555:
---------------------------------------------

guys, i found in _test_join_types.test_ignored_ we still have such a problem:

{noformat}
class org.apache.ignite.IgniteException: Error at: (test_join_types.test:12). Statement: Statement [queries=ArrayList [create table a as select i::tinyint AS i from range(1, 101, 1) t1(i)], expected=OK]

	at org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner$Statement.execute(SqlScriptRunner.java:420)
	at org.apache.ignite.internal.processors.query.calcite.logical.SqlScriptRunner.run(SqlScriptRunner.java:131)
	at org.apache.ignite.internal.processors.query.calcite.logical.ScriptTestRunner$1.run(ScriptTestRunner.java:219)
	at java.lang.Thread.run(Thread.java:748)
Caused by: class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse query.
{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)