[ https://issues.apache.org/jira/browse/IGNITE-12159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexey Zinoviev updated IGNITE-12159: ------------------------------------- Labels: await (was: ) > 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: 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)