When we are connected to the local database from qloader and for pulling the data from different shafts when we apply the SQL query, then we are unable to use union or any other SQL keyword except the general select * from table statement
We tried using something like
SELECT
*
FROM
nimbus_0.tenant
UNION ALL
SELECT
*
FROM
nimbus_1.tenant
WITH tenants AS
(SELECT * FROM nimbus_0.tenant
UNION ALL
SELECT * FROM nimbus_1.tenant)
SELECT * FROM tenants
Both were throwing an error saying that
"No valid SQL query was found"
