Paul Rogers created IMPALA-8287:
-----------------------------------
Summary: SHOW CREATE TABLE does not escape column names
Key: IMPALA-8287
URL: https://issues.apache.org/jira/browse/IMPALA-8287
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 3.1.0
Reporter: Paul Rogers
Create a table that includes a column called `location`. Issue a SHOW CREATE
TABLE command for that table. You will get the sql with the name unquoted. Try
to execute that statement. You'll get an error:
{noformat}
Syntax error in line 11:
location STRING,
^
Encountered: LOCATION
Expected: DEFAULT, PRIMARY, IDENTIFIER
{noformat}
Reason: {{LOCATION}} is a SQL reserved word. The implementation of SHOW CREATE
TABLE should escape reserved column names. Using the {{ToSqlUtils}} method for
that purpose.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
