dadepo commented on issue #9122: URL: https://github.com/apache/arrow-datafusion/issues/9122#issuecomment-1926312552
> I guess this is an unfortunate side effect of having JSON_TABLE be a keyword for a MySQL function. Indeed. > You can remedy this by escaping it in the SQL via backticks to indicate it shouldn't be a keyword But since Datafusion is agnostic of any specific database, I think this issue should be circumvent within Datafusion itself. I actually wasted a huge amount of time, trying to figure out why my queries were failing with ParseError, and it was only by chance I spotted it was related to the name `json_table`. So indeed escaping with backticks is a workaround, it would be nicer if this can be handled within Datafusion itself - if possible. -- 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]
