liutang123 commented on PR #61799: URL: https://github.com/apache/doris/pull/61799#issuecomment-4159681457
This issue occurs because `double` types cannot be set as key columns, and the BE cannot find a corresponding encoder. For the `ADD COLUMNS` operation, if an aggregate function is not specified for a double-type column, the system should return an error, consistent with the current prompt for the `ADD COLUMN` statement: ``` >alter table t2 add column k3 double comment 'add column';ERROR 1105 (HY000): errCode = 2, detailMessage = Float or double cannot be used as a key, use decimal instead. ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
