WORKS: SELECT id from transaction ERROR: SELECT id as test from transaction

Could be the word test? Or maybe try it without the “AS”. i.e.

SELECT id testidalias FROM transaction

My queries worked in Dbeaver but not in pyspark, we have changed to using Scala (as it is java) to do the queries and now it works 🙂