Re: Alter table issue
Hello! I'm afraid the development of 3.0 have not started yet. Please avoid re-creating columns that were previously dropped. Instead, use new column name. Regards, -- Ilya Kasnacheev вт, 3 дек. 2019 г. в 15:51, Shravya Nethula < shravya.neth...@aline-consulting.com>: > Hi Ivan, > > Thank you for the confirmation. > > In the link, I can see that the issue will be resolved in Ignite 3.0 > version. > When will Ignite 3.0 be released? Is there any tentative date? > > Regards, > > Shravya Nethula, > > BigData Developer, > > > Hyderabad. > > -- > *From:* Ivan Pavlukhin > *Sent:* Tuesday, December 3, 2019 6:12 PM > *To:* user@ignite.apache.org > *Subject:* Re: Alter table issue > > Hi Shravya, > > It is a know issue. You can find more details in ticket [1]. > > [1] https://issues.apache.org/jira/browse/IGNITE-6611 > > вт, 3 дек. 2019 г. в 07:54, Shravya Nethula < > shravya.neth...@aline-consulting.com>: > > Hi, > > I added a new column in an existing table using the following query: > *ALTER TABLE person ADD COLUMN (order_id LONG)* > > Now, I am trying to change the datatype of the new column, so I tried > executing the following queries: > > *ALTER TABLE person DROP COLUMN (order_id) * > > *ALTER TABLE person ADD COLUMN (order_id VARCHAR(64)) * > > Now when I am trying to insert a row with "varchar" value in "order_id" > column, it is throwing the following error: > *Error: Wrong value has been set > [typeName=SQL_PUBLIC_PERSON_fc7e0bd5_d052_43c1_beaf_fb01b65f2f96, > fieldName=ORDER_ID, fieldType=long, assignedValueType=String]* > > In this link: https://apacheignite-sql.readme.io/docs/alter-table > The command does not remove actual data from the cluster which means that > if the column 'name' is dropped, the value of the 'name' will still be > stored in the cluster. This limitation is to be addressed in the next > releases. > > I saw that there is a limitation in Alter Table. So in which release can > this support be provided? What is the tentative date? > > > Regards, > > Shravya Nethula, > > BigData Developer, > > > Hyderabad. > > > > -- > Best regards, > Ivan Pavlukhin >
Re: Alter table issue
Hi Ivan, Thank you for the confirmation. In the link, I can see that the issue will be resolved in Ignite 3.0 version. When will Ignite 3.0 be released? Is there any tentative date? Regards, Shravya Nethula, BigData Developer, [cid:2a5e6893-c131-4622-bebf-2deef20e1f50] Hyderabad. From: Ivan Pavlukhin Sent: Tuesday, December 3, 2019 6:12 PM To: user@ignite.apache.org Subject: Re: Alter table issue Hi Shravya, It is a know issue. You can find more details in ticket [1]. [1] https://issues.apache.org/jira/browse/IGNITE-6611 вт, 3 дек. 2019 г. в 07:54, Shravya Nethula mailto:shravya.neth...@aline-consulting.com>>: Hi, I added a new column in an existing table using the following query: ALTER TABLE person ADD COLUMN (order_id LONG) Now, I am trying to change the datatype of the new column, so I tried executing the following queries: ALTER TABLE person DROP COLUMN (order_id) ALTER TABLE person ADD COLUMN (order_id VARCHAR(64)) Now when I am trying to insert a row with "varchar" value in "order_id" column, it is throwing the following error: Error: Wrong value has been set [typeName=SQL_PUBLIC_PERSON_fc7e0bd5_d052_43c1_beaf_fb01b65f2f96, fieldName=ORDER_ID, fieldType=long, assignedValueType=String] In this link: https://apacheignite-sql.readme.io/docs/alter-table The command does not remove actual data from the cluster which means that if the column 'name' is dropped, the value of the 'name' will still be stored in the cluster. This limitation is to be addressed in the next releases. I saw that there is a limitation in Alter Table. So in which release can this support be provided? What is the tentative date? Regards, Shravya Nethula, BigData Developer, [cid:16ecbc726072e8c0d661] Hyderabad. -- Best regards, Ivan Pavlukhin
Re: Alter table issue
Hi Shravya, It is a know issue. You can find more details in ticket [1]. [1] https://issues.apache.org/jira/browse/IGNITE-6611 вт, 3 дек. 2019 г. в 07:54, Shravya Nethula < shravya.neth...@aline-consulting.com>: > Hi, > > I added a new column in an existing table using the following query: > *ALTER TABLE person ADD COLUMN (order_id LONG)* > > Now, I am trying to change the datatype of the new column, so I tried > executing the following queries: > > *ALTER TABLE person DROP COLUMN (order_id) * > > *ALTER TABLE person ADD COLUMN (order_id VARCHAR(64)) * > > Now when I am trying to insert a row with "varchar" value in "order_id" > column, it is throwing the following error: > *Error: Wrong value has been set > [typeName=SQL_PUBLIC_PERSON_fc7e0bd5_d052_43c1_beaf_fb01b65f2f96, > fieldName=ORDER_ID, fieldType=long, assignedValueType=String]* > > In this link: https://apacheignite-sql.readme.io/docs/alter-table > The command does not remove actual data from the cluster which means that > if the column 'name' is dropped, the value of the 'name' will still be > stored in the cluster. This limitation is to be addressed in the next > releases. > > I saw that there is a limitation in Alter Table. So in which release can > this support be provided? What is the tentative date? > > > Regards, > > Shravya Nethula, > > BigData Developer, > > > Hyderabad. > > -- Best regards, Ivan Pavlukhin
Alter table issue
Hi, I added a new column in an existing table using the following query: ALTER TABLE person ADD COLUMN (order_id LONG) Now, I am trying to change the datatype of the new column, so I tried executing the following queries: ALTER TABLE person DROP COLUMN (order_id) ALTER TABLE person ADD COLUMN (order_id VARCHAR(64)) Now when I am trying to insert a row with "varchar" value in "order_id" column, it is throwing the following error: Error: Wrong value has been set [typeName=SQL_PUBLIC_PERSON_fc7e0bd5_d052_43c1_beaf_fb01b65f2f96, fieldName=ORDER_ID, fieldType=long, assignedValueType=String] In this link: https://apacheignite-sql.readme.io/docs/alter-table The command does not remove actual data from the cluster which means that if the column 'name' is dropped, the value of the 'name' will still be stored in the cluster. This limitation is to be addressed in the next releases. I saw that there is a limitation in Alter Table. So in which release can this support be provided? What is the tentative date? Regards, Shravya Nethula, BigData Developer, [cid:18fe433f-515a-4b53-bd76-358144bbf8a5] Hyderabad.