clickhouse 字段显示 readonly no corresponding table column 是什么意思
时间: 2024-02-09 09:12:35 浏览: 55
`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.
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)