StarRocks外部表使用注意事项(Precautions for using starrocks external table)

1.源表新增字段

新增字段无法自动映射,查不到

2.源表删除字段

报错:> 1064 – mysql query failed. Err: Unknown column ‘age’ in ‘field list’

3.源表修改字段类型

无法查到修改字段数据

注:int类型修改成varchar类型,数字还是可以查到,但是字符串数据查不到

4.删除源表

报错:> 1064 – mysql query failed. Err: Table ‘test.demo’ doesn’t exist

————————

1. New fields in source table

The new field cannot be mapped automatically and cannot be found

2. Delete field from source table

报错:> 1064 – mysql query failed. Err: Unknown column ‘age’ in ‘field list’

3. Modify field type in source table

Unable to find modified field data

Note: if the int type is changed to varchar type, the number can still be found, but the string data cannot be found

4. Delete source table

报错:> 1064 – mysql query failed. Err: Table ‘test.demo’ doesn’t exist