schema appended to query

[yousef199]

@aadel I am facing an issue when creating a dataset where the schema is appended to the query.

Superset Logs:

sqlglot.errors.ParseError: Invalid expression / Unexpected token. Line 2, Col: 14.

SELECT *

FROM default.ucm2

LIMIT 100

it appears that the issue is regarding the schema appended to the core name. it is mentioned that this shouldn't be an issue with version > 0.2.3.0, I've verified that the version used by the docker container is 0.2.4.0. As you can see the schema name default is getting appended to the query. I've verified that executing queries with sqllab works which means there are no connection issues with my solr envirnoment.

Envirnoment:
Superset: 5.0.0
sqlalchemy-solr: 0.2.4.0
postgres: 16

[aadel]

@yousef199 The latest version of sqlalchemy-solr has not been tested with Superset 5.x or later. Superset 4.x is the latest version the current version of the driver is compatible with. There are major changes in Superset 5, sqlglot library upgrade is the most probable cause of this issue.

Superset 5.x, and most likely 6.x, will be supported in the next release of the driver.

[aadel]

@yousef199 you can upgrade sqlglot to version v27.18.0 to resolve this issue.