GitHub user imedlee created a discussion: The Jinja Templates dataset macro
cannot be used in Oracle.
When querying an Oracle database using select * from {{ dataset(1) }}, the SQL
query generated by Superset automatically adds a table alias (such as AS
dataset_1) during parsing. As a result, the actual executed query becomes
SELECT * FROM (SELECT * FROM test) AS dataset_1, which causes the error
ORA-00907: missing right parenthesis.
In Oracle databases, AS cannot be used after a table alias. When executing
SELECT * FROM (SELECT * FROM test) dataset_1 in SQL Lab, the query works. How
to resolve the issue where {{ dataset() }} cannot be used?
GitHub link: https://github.com/apache/superset/discussions/34415
----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to:
notifications-unsubscr...@superset.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
