clickhouse 字段显示 readonly no corresponding table column 是什么意思
时间: 2024-02-09 12:12:35 浏览: 309
`readonly no` is an error message in ClickHouse, which is thrown when a query tries to modify a read-only column or a column that does not exist in a table. This error message can occur when:
1. You are trying to modify a column that is marked as `READONLY` in the table definition. In this case, you need to remove the `READONLY` attribute from the table definition or modify the query to exclude the read-only column.
2. You are trying to modify a column that does not exist in the table. In this case, you need to modify the query to reference a valid column in the table.
For example, the following query will throw a `readonly no` error if the `my_column` column is defined as `READONLY` or does not exist in the `my_table` table:
```
UPDATE my_table SET my_column = 123 WHERE id = 1;
```
To fix this error, you need to ensure that the `my_column` column is not read-only and exists in the `my_table` table.
阅读全文