twalthr commented on issue #8738: [FLINK-12845][sql-client] Execute multiple statements in command line… URL: https://github.com/apache/flink/pull/8738#issuecomment-525214337 As far as I know Hive is also not SQL compliant and backslashes should not be used for escaping unless used with the following syntax: ``` String literals must be enclosed in single quotes (e.g., SELECT 'Hello World'). Duplicate a single quote for escaping (e.g., SELECT 'It''s me.'). Unicode characters are supported in string literals. If explicit unicode code points are required, use the following syntax: Use the backslash (\) as escaping character (default): SELECT U&'\263A' Use a custom escaping character: SELECT U&'#263A' UESCAPE '#' ``` What we need is a slightly different architecture for the SQL Client. Currently the DDL, DCL commands are parsed on the CLI side. However, this should happen in TableEnvironment instead such that the CLI is just a thin wrapper around the core API.
---------------------------------------------------------------- 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] With regards, Apache Git Services
