[
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)
