CODEWITHSUNDEEP
sqldruid
Abishek Prakash
Abishek Prakash

Reputation: 31

Apache Druid - Unable to build plan for SQL query with 'UNION ALL' operation

When running a simple SQL query containing the UNION ALL clause against Druid, the operation fails as it is unable to build the query plan. The official Druid documentation shows that Druid supports UNION ALL queries.

SELECT column_name FROM table_1 UNION ALL SELECT column_name FROM table_2

I expect a concatenated result set from the execution of both the queries. I am instead getting the following error - {"error":"Unknown exception","errorMessage":"Cannot build plan for query: .....","errorClass":"io.druid.java.util.common.ISE","host":null}

Upvotes: 1

Views: 1658

Answers (1)

Vadim Ogievetsky
Vadim Ogievetsky

Reputation: 61

What version of Druid are you on? I am on 0.16.0 and your query works for me Query console

Upvotes: 1

Related Questions