From issues-return-100324-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Wed Oct 9 08:09:02 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 1856A180645 for ; Wed, 9 Oct 2019 10:09:02 +0200 (CEST) Received: (qmail 634 invoked by uid 500); 9 Oct 2019 08:09:01 -0000 Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list issues@ignite.apache.org Received: (qmail 620 invoked by uid 99); 9 Oct 2019 08:09:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Oct 2019 08:09:01 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id B670FE2E5B for ; Wed, 9 Oct 2019 08:09:00 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 37B61780749 for ; Wed, 9 Oct 2019 08:09:00 +0000 (UTC) Date: Wed, 9 Oct 2019 08:09:00 +0000 (UTC) From: "Alexey Zinoviev (Jira)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (IGNITE-12159) Ignite spark doesn't support Alter Column syntax MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/IGNITE-12159?page=3Dcom.atlass= ian.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))=C2=A0WITH "backups=3D1" > ALTER TABLE person ADD COLUMN (first_name VARCHAR(64), last_name VARCHAR= (64)) > 3)After that run next spark code: > =C2=A0 =C2=A0 =C2=A0 =C2=A0String configPath =3D "client.xml"; > =C2=A0 =C2=A0 =C2=A0=C2=A0 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0SparkConf sparkConf =3D new Sp= arkConf() > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0.setMaster("local") > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0.setAppName("Example");=C2=A0 > =C2=A0 =C2=A0 =C2=A0 IgniteSparkSession.builder() > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0.appName("Spark Ignite catalog example") > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0.master("local") > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0.config("ignite.disableSparkSQLOptimization", true) > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0.igniteConfig(configPath) > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0.getOrCreate(); > =C2=A0 > =C2=A0 =C2=A0 =C2=A0 Dataset df2 =3D igniteSession.sql("select * fr= om person");=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 > =C2=A0 =C2=A0 =C2=A0 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)