ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexey Zinoviev (Jira)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-12159) Ignite spark doesn't support Alter Column syntax
Date Wed, 09 Oct 2019 08:09:00 GMT

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

Alexey Zinoviev updated IGNITE-12159:
-------------------------------------
    Affects Version/s:     (was: 2.7.5)
                       2.8

> 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.8
>            Reporter: Andrey Aleksandrov
>            Assignee: Alexey Zinoviev
>            Priority: Critical
>              Labels: await
>             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)

Mime
View raw message