karthikbhat13 commented on issue #10204:
URL: https://github.com/apache/druid/issues/10204#issuecomment-673054574
Hey @gianm, I am just going through the code and haven't able to figure out
a solution yet. But I was going through the documentation and I came upon this
rule,
`[ EXPLAIN PLAN FOR ]
[ WITH tableName [ ( column1, column2, ... ) ] AS ( query ) ]
SELECT [ ALL | DISTINCT ] { * | exprs }
FROM { <table> | (<subquery>) | <o1> [ INNER | LEFT ] JOIN <o2> ON condition
}
[ WHERE expr ]
[ GROUP BY [ exprs | GROUPING SETS ( (exprs), ... ) | ROLLUP (exprs) | CUBE
(exprs) ] ]
[ HAVING expr ]
[ ORDER BY expr [ ASC | DESC ], expr [ ASC | DESC ], ... ]
[ LIMIT limit ]
[ UNION ALL <another query> ]`
According to this, you can't have a subquery inside the select block.
Basically the query which was giving the error is not allowed? In that case, I
can look into returning some error code or something.
Unless that doc is out of date, you do support subqueries inside the select
block.
Let me know what you think.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
