Want STRING but got TEXT

[madeirak]

sqlglot==23.15.8 newest
All STRING types in Spark SQL will be converted to TEXT. I don't want to convert them like this. What should I do

[georgesittas]

They are converted into TEXT because you didn't supply an output dialect. My guess is that you're doing str(ast) which invokes the .sql() method without a dialect. Try ast.sql("spark") or transpile(sql, "spark").

>>> import sqlglot
>>> sqlglot.transpile("cast(x as string)", "spark")
['CAST(x AS STRING)']

Check out https://github.com/tobymao/sqlglot/blob/main/posts/ast_primer.md