yaozhu commented on issue #2873: URL: https://github.com/apache/drill/issues/2873#issuecomment-1905216330
> I'm not yet convinced there is a bug in Drill here. I think the issue may actually be in your query. My hunch here is that there may be an issue in the `ORDER BY` statement. Your inner tables each have columns called `k1`. Then you are calling a sort on that without specifying which one it is. You might first try adding table names to the `ORDER BY` clause. > > Secondly, I'm not trying to be rude but what are you trying to achieve with this query? It looks like you are performing a union of a left and right join of the same table? Why not combine these? Then you have nested `SELECT *` statements that don't really seem to serve any purpose. This is a test case written by testers, without actual usage scenarios. What do you mean by combining them? -- 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. To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
