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)