[ https://issues.apache.org/jira/browse/HIVE-10659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hari Sankar Sivarama Subramaniyan updated HIVE-10659: ----------------------------------------------------- Summary: Beeline command which contains semi-colon as a non-command terminator will fail (was: Beeline commands which contains semi-colon as a non-command terminator will fail) > Beeline command which contains semi-colon as a non-command terminator will > fail > ------------------------------------------------------------------------------- > > Key: HIVE-10659 > URL: https://issues.apache.org/jira/browse/HIVE-10659 > Project: Hive > Issue Type: Bug > Reporter: Hari Sankar Sivarama Subramaniyan > Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-10659.1.patch > > > Consider beeline for connecting to mysql and creating commands involving > stored procedures. MySQL stored procedures have semi-colon as the statement > terminator. Since this coincides with beeline's only available command > terminator , semi-colon, beeline will not able to execute the original > command successfully. > The above scenario can happen when Hive SchemaTool is used to upgrade a mysql > metastore db which contains stored procedure in the script(as the one > introduced initially by HIVE-7018). As of now, we cannot have any stored > procedures as part of MySQL scripts because schemaTool uses beeline as the > jdbc client to connect to MySQL. This is a serious limitation and needs to be > fixed by providing an option to beeline to not use ";" as the command > delimiter and process the entire line send to it as a single command. -- This message was sent by Atlassian JIRA (v6.3.4#6332)