I get an error when using Alter Table statement. The error is “CatalogException: Table with name tablename does not exist!” This is strange because I used the Describe select statement just before it and it described the table, thus read the table.
I want to change the column type from BIGINT to VARCHAR. I am running DuckDB in Python JuypterLab Version 4.0.2
duckdb.sql(“”" ALTER TABLE ‘/XXXX/XXXXX/tablename.parquet’ ALTER YYYYY TYPE VARCHAR “”")
Put code inside backticks
to preserve indentation
which is especially important
for Python and YAML!