[jira] [Commented] (HIVE-21885) Add pg-style dollar quoted string constant support

["Shawn Weeks (JIRA)" <ji...@apache.org>]

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

Shawn Weeks commented on HIVE-21885:
------------------------------------

Support for Oracle style quotes might also be useful here. For Oracle you provide a q followed by a single quote and then delimiter you want to use. You end the quote by using that delimter followed by another singel quote.


{code:sql}
begin
dbms_output.put_line(q'~'''''''Lots of Quotes'''~');
end;
/
{code}


> Add pg-style dollar quoted string constant support
> --------------------------------------------------
>
>                 Key: HIVE-21885
>                 URL: https://issues.apache.org/jira/browse/HIVE-21885
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Zoltan Haindrich
>            Priority: Major
>
> I think it would be good to have a better option to supply constant string block for Hive
> Although I think the standard doesn't specify this - but I think the pg style "dollar-quote string constants" would be great.
> https://www.postgresql.org/docs/11/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)