Error when do an alter table change column on an acid table
Hello,
We have done this before but now we are trying to make a change on a table column and we are getting the follow error:
Error while compiling statement: FAILED: Execution Error, return code 40013 from org.apache.hadoop.hive.ql.ddl.DDLTask. Unable to alter table. Cannot change stats state for a transactional table pro_con.dmcrp001_th_importe_consolidado_contrato without providing the transactional write state for verification (new write ID 327, valid write IDs null; current state null; new state {}
The statement that we are executing is:
alter table `pro_con`.`dmcrp001_th_importe_consolidado_contrato` change column `fecha_movimiento` `fecha_proceso_dia` timestamp comment 'Fecha de referencia de los datos.';

