Hi All, We have a situation where we have to change the datatype of the existing column of a phoenix table from INTEGER to BIGINT. is there a way to alter the datatype without loosing the existing data?
Have tried to take the snapshot of hbase table and restored it in a new pheonix table with new datatype. but when selecting the altered columns it throws the following error. java.lang.RuntimeException: java.sql.SQLException: ERROR 201 (22000): Illegal data. ERROR 201 (22000): Illegal data. ERROR 201 (22000): Illegal data. Expected length of *at least 8 bytes, but had 4* at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) at sqlline.SqlLine.print(SqlLine.java:1735) at sqlline.SqlLine$Commands.execute(SqlLine.java:3683) at sqlline.SqlLine$Commands.sql(SqlLine.java:3584) at sqlline.SqlLine.dispatch(SqlLine.java:821) at sqlline.SqlLine.begin(SqlLine.java:699) at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) at sqlline.SqlLine.main(SqlLine.java:424) -- * Regards* * Sandeep Nemuri* ᐧ
