Zoltan Haindrich created HIVE-22773:
---------------------------------------

             Summary: Accept identifiers starting with underscore
                 Key: HIVE-22773
                 URL: https://issues.apache.org/jira/browse/HIVE-22773
             Project: Hive
          Issue Type: Improvement
          Components: Parser
            Reporter: Zoltan Haindrich


I think we may also want to consider to accept identifiers starting with _

mysql, psql accepts: 
{code}
create table _t(_a integer)
{code}
meanwhile hive and oracle does not.

the sql2011 standard suggest that the first char can be:
{code}
1) An  is any character in the Unicode General Category classes “Lu”, “Ll”, 
“Lt”, “Lm”, “Lo”, or “Nl”.
{code}
which includes the a _ named "low macron"
https://www.fileformat.info/info/unicode/char/02cd/index.htm
but... the "low line"
https://www.fileformat.info/info/unicode/char/005f/index.htm
is in the Pc class...




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to