Thanks for the reply.
On Fri, 2 Aug 2019 at 14:32, Ilya Kasnacheev <[email protected]> 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 <[email protected]>: > >> 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 >> >> >> >> >> >> >> >> >
