Polber commented on issue #30498: URL: https://github.com/apache/beam/issues/30498#issuecomment-2030487932
I played around with this a bit more and realized it has to do with Calcite (the engine that ultimately decides on the SQL plan) developing a slightly different syntax for the inputs that Beam SQL does not treat properly. I am not well-versed in the Beam SQL framework itself, so it is difficult to say what needs to be fixed on that end, but as far as your issue, we just need to "trick" Beam SQL into developing the same Beam Plan. Using our example above, I accomplished that by changing the query the following: ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
