[jira] [Comment Edited] (HIVE-6013) Supporting Quoted Identifiers in Column Names

[Eva Mariam (Jira)]

    [ 
https://issues.apache.org/jira/browse/HIVE-6013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17316825#comment-17316825
 ] 

Eva Mariam edited comment on HIVE-6013 at 4/8/21, 3:10 AM:
-----------------------------------------------------------

Tables with special character in column name are  created.
but the data for views created over tables having columns with special 
characters for delta tables is not fetched.

Hive: 0.13
Databricks Runtime: 7.5 
in Azure

{code:java}
create table test (`stats_broadcastpkt` string, `sta”s_mpkt` string) using 
delta location '/mnt/table';

create view test_vw as select * from test;
{code}

com.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: 
org.apache.spark.sql.AnalysisException: Attribute with name 'sta?s_mpkt' is not 
found in '(stats_broadcastpkt,sta”s_mpkt)';;


was (Author: evamariam):
Tables with special character in column name are  created.
but Views cannot be created over tables having columns with special characters 
for delta tables.

Hive: 0.13
Databricks Runtime: 7.5 
in Azure

{code:java}
create table test (`stats_broadcastpkt` string, `sta”s_mpkt` string) using 
delta location '/mnt/table';

create view test-vw as select * from test;
{code}

Caused by: java.sql.SQLException: Incorrect string value: '\xC2\x94s_mu...' for 
column 'PARAM_VALUE' at row 1
Query is: INSERT INTO TABLE_PARAMS (PARAM_VALUE,TBL_ID,PARAM_KEY) VALUES 
(?,?,?) ,
 

> Supporting Quoted Identifiers in Column Names
> ---------------------------------------------
>
>                 Key: HIVE-6013
>                 URL: https://issues.apache.org/jira/browse/HIVE-6013
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Harish Butani
>            Assignee: Harish Butani
>            Priority: Major
>             Fix For: 0.13.0
>
>         Attachments: HIVE-6013.1.patch, HIVE-6013.2.patch, HIVE-6013.3.patch, 
> HIVE-6013.4.patch, HIVE-6013.5.patch, HIVE-6013.6.patch, HIVE-6013.7.patch, 
> QuotedIdentifier.html
>
>
> Hive's current behavior on Quoted Identifiers is different from the normal 
> interpretation. Quoted Identifier (using backticks) has a special 
> interpretation for Select expressions(as Regular Expressions). Have 
> documented current behavior and proposed a solution in attached doc.
> Summary of solution is:
> - Introduce 'standard' quoted identifiers for columns only. 
> - At the langauage level this is turned on by a flag.
> - At the metadata level we relax the constraint on column names.



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