You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jin Sun (JIRA)" <ji...@apache.org> on 2017/11/28 19:34:00 UTC

[jira] [Created] (HIVE-18168) Block create table statement with colon and dot in column name

Jin Sun created HIVE-18168:
------------------------------

             Summary: Block create table statement with colon and dot in column name
                 Key: HIVE-18168
                 URL: https://issues.apache.org/jira/browse/HIVE-18168
             Project: Hive
          Issue Type: Improvement
            Reporter: Jin Sun
            Priority: Minor


According to the documentation:
In Hive 0.13 and later, column names can contain any Unicode character (see HIVE-6013), however, dot (.) and colon (:) yield errors on querying, so they are disallowed in Hive 1.2.0 (see HIVE-10120). Any column name that is specified within backticks (`) is treated literally. Within a backtick string, use double backticks (``) to represent a backtick character. Backtick quotation also enables the use of reserved keywords for table and column identifiers.

We should not only fail on querying but block users from creating such tables as well.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)