Unable to insert the data into table after altering the table via sqlline

classic Classic list List threaded Threaded
3 messages Options
radha radha
Reply | Threaded
Open this post in threaded view
|

Unable to insert the data into table after altering the table via sqlline

Hi,
 Insertion is failing, after altering the table.
 Followed below steps:

-> CREATE TABLE student (id_ VARCHAR, firstName VARCHAR, lastName VARCHAR, birthDate TIMESTAMP, height DOUBLE, PRIMARY KEY(id))
-> INSERT INTO student (id, firstName, lastName, birthDate, height) VALUES (1000, 'huxt', 'abx', CURRENT_TIMESTAMP(), 5.6);
-> ALTER TABLE student DROP COLUMN birthDate;
-> ALTER TABLE student ADD COLUMN birthDate VARCHAR;
-> INSERT INTO student (id, firstName, lastName, birthDate, height) VALUES (1001, 'luan', 'qwst', '11223', 6.6);   

Getting below error:
Error: class org.apache.ignite.binary.BinaryObjectException: Wrong value has been set [typeName=SQL_PUBLIC_STUDENT_e910ba3a_3a65_4d53_9265_8c12a9b0bac3, fieldName=BIRTHDATE, fieldType=Timestamp, assignedValueType=String] (state=50000,code=1)

Issues faced:
-> unable to insert the data after modifying the datatype of the field in a table.
-> If i do " select * from student;" , I am seeing the old data being inserted for the birthdate column, after dropping birthdate colmun and adding the colmn with the same name but different datatype.

Is this a know issue? Or soemthing i am doing wrong.
If it is a know issue please provide the workaround.

Thanks
radha






 
ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re: Unable to insert the data into table after altering the table via sqlline

Hello!

Unfortunately, you can't do that until Apache Ignite 3.0 :(

There's at least one ticket to watch: https://issues.apache.org/jira/browse/IGNITE-6611

Right now my recommendation is to change column name when you do ADD COLUMN so that it does not clash with any columns that ever existed on that table.

Regards,
--
Ilya Kasnacheev


пт, 2 авг. 2019 г. в 11:55, radha jai <[hidden email]>:
Hi,
 Insertion is failing, after altering the table.
 Followed below steps:

-> CREATE TABLE student (id_ VARCHAR, firstName VARCHAR, lastName VARCHAR, birthDate TIMESTAMP, height DOUBLE, PRIMARY KEY(id))
-> INSERT INTO student (id, firstName, lastName, birthDate, height) VALUES (1000, 'huxt', 'abx', CURRENT_TIMESTAMP(), 5.6);
-> ALTER TABLE student DROP COLUMN birthDate;
-> ALTER TABLE student ADD COLUMN birthDate VARCHAR;
-> INSERT INTO student (id, firstName, lastName, birthDate, height) VALUES (1001, 'luan', 'qwst', '11223', 6.6);   

Getting below error:
Error: class org.apache.ignite.binary.BinaryObjectException: Wrong value has been set [typeName=SQL_PUBLIC_STUDENT_e910ba3a_3a65_4d53_9265_8c12a9b0bac3, fieldName=BIRTHDATE, fieldType=Timestamp, assignedValueType=String] (state=50000,code=1)

Issues faced:
-> unable to insert the data after modifying the datatype of the field in a table.
-> If i do " select * from student;" , I am seeing the old data being inserted for the birthdate column, after dropping birthdate colmun and adding the colmn with the same name but different datatype.

Is this a know issue? Or soemthing i am doing wrong.
If it is a know issue please provide the workaround.

Thanks
radha






 
radha radha
Reply | Threaded
Open this post in threaded view
|

Re: Unable to insert the data into table after altering the table via sqlline

Thanks for the reply.


On Fri, 2 Aug 2019 at 14:32, Ilya Kasnacheev <[hidden email]> wrote:
Hello!

Unfortunately, you can't do that until Apache Ignite 3.0 :(

There's at least one ticket to watch: https://issues.apache.org/jira/browse/IGNITE-6611

Right now my recommendation is to change column name when you do ADD COLUMN so that it does not clash with any columns that ever existed on that table.

Regards,
--
Ilya Kasnacheev


пт, 2 авг. 2019 г. в 11:55, radha jai <[hidden email]>:
Hi,
 Insertion is failing, after altering the table.
 Followed below steps:

-> CREATE TABLE student (id_ VARCHAR, firstName VARCHAR, lastName VARCHAR, birthDate TIMESTAMP, height DOUBLE, PRIMARY KEY(id))
-> INSERT INTO student (id, firstName, lastName, birthDate, height) VALUES (1000, 'huxt', 'abx', CURRENT_TIMESTAMP(), 5.6);
-> ALTER TABLE student DROP COLUMN birthDate;
-> ALTER TABLE student ADD COLUMN birthDate VARCHAR;
-> INSERT INTO student (id, firstName, lastName, birthDate, height) VALUES (1001, 'luan', 'qwst', '11223', 6.6);   

Getting below error:
Error: class org.apache.ignite.binary.BinaryObjectException: Wrong value has been set [typeName=SQL_PUBLIC_STUDENT_e910ba3a_3a65_4d53_9265_8c12a9b0bac3, fieldName=BIRTHDATE, fieldType=Timestamp, assignedValueType=String] (state=50000,code=1)

Issues faced:
-> unable to insert the data after modifying the datatype of the field in a table.
-> If i do " select * from student;" , I am seeing the old data being inserted for the birthdate column, after dropping birthdate colmun and adding the colmn with the same name but different datatype.

Is this a know issue? Or soemthing i am doing wrong.
If it is a know issue please provide the workaround.

Thanks
radha