from sqlalchemy import text query = """ SELECT * ...
# questions-and-troubleshooting
d
from sqlalchemy import text query = """ SELECT * FROM analytics.iceberg_testing_partitioned WHERE category_code = 'sedan';""" with engine.connect() as conn: res= conn.execute(text(query)) rows = res.fetchall() print(rows) Error:
Copy code
ProgrammingError: (pymysql.err.ProgrammingError) (1064, "Getting analyzing error. Detail message: Table of iceberg catalog doesn't support [DELETE].")
[SQL:  DELETE FROM analytics.iceberg_testing_partitioned
WHERE category_code = 'sedan'; ]
Iceberg supports row-level deletions, but there are issues when performing them through StarRocks.