Unable to Do "With" Statement: "Sql Error [57]: .. . Schema Must Be Specified When Session Schema Is Not Set"
I'm Trying to Use a with Statement in Dbeaver Built on Presto (I May Have a Gap in Knowledge of the Underlying Tools and Structure). Simple Query: with T1 as...
![Unable to Do "With" Statement: "Sql Error [57]: .. . Schema Must Be Specified When Session Schema Is Not Set"](https://www.alledaags.nl/uploads/unable-to-do-with-statement-sql-error_1200.jpg)
I'm trying to use a WITH statement in DBeaver built on Presto (I may have a gap in knowledge of the underlying tools and structure).
Simple query:
with t1 as (select run_id from john.link_budget limit 10)
select a.run_id
from a
Error:
SQL Error [57]: Query failed (#20230313_181242_00253_h9j4c): line 6:6: Schema must be specified when session schema is not set
What does Schema must be specified when session schema is not set mean and how could I fix it?
1 Answer
This is just a typo. Change from a to from t1, query runs successfully.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
