[jira] [Assigned] (IGNITE-12159) Ignite spark doesn't support Alter Column syntax

["Aleksey Zinoviev (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-12159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aleksey Zinoviev reassigned IGNITE-12159:
-----------------------------------------

    Assignee: Aleksey Zinoviev

> Ignite spark doesn't support Alter Column syntax
> ------------------------------------------------
>
>                 Key: IGNITE-12159
>                 URL: https://issues.apache.org/jira/browse/IGNITE-12159
>             Project: Ignite
>          Issue Type: Bug
>          Components: spark
>    Affects Versions: 2.7.5
>            Reporter: Andrey Aleksandrov
>            Assignee: Aleksey Zinoviev
>            Priority: Critical
>             Fix For: 2.8
>
>
> Steps:
> 1)Start the server
>  2)Run next SQL commands
> CREATE TABLE person (id LONG, name VARCHAR(64), age LONG, city_id DOUBLE, zip_code LONG, PRIMARY KEY (name)) WITH "backups=1"
>  ALTER TABLE person ADD COLUMN (first_name VARCHAR(64), last_name VARCHAR(64))
> 3)After that run next spark code:
>        String configPath = "client.xml";
>        
>         SparkConf sparkConf = new SparkConf()
>                 .setMaster("local")
>                 .setAppName("Example"); 
>       IgniteSparkSession.builder()
>                 .appName("Spark Ignite catalog example")
>                 .master("local")
>                 .config("ignite.disableSparkSQLOptimization", true)
>                 .igniteConfig(configPath)
>                 .getOrCreate();
>   
>        Dataset<Row> df2 = igniteSession.sql("select * from person");       
>        df2.show();
> The result will contain only 5 columns from CREATE TABLE call.
> [http://apache-ignite-users.70518.x6.nabble.com/Altered-sql-table-adding-new-columns-does-not-reflect-in-Spark-shell-td29265.html]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)