?????? how to set string representation in calcite SQL??

Fri, 18 Dec 2020 01:13:10 -0800 

not like this??I said  string contant 
?? setQuoting(Quoting.DOUBLE_QUOTE)  
 affect  identifiers??like column name??table name??not 
affect  string contant
setQuoting(Quoting.DOUBLE_QUOTE)    make      
 select * from table1 where "column1" = 'word'  Ok




------------------ ???????? ------------------
??????:                                                                         
                                               "dev"                            
                                                        <[email protected]&gt;;
????????:&nbsp;2020??12??17??(??????) ????3:48
??????:&nbsp;"[email protected]"<[email protected]&gt;;

????:&nbsp;Re: how to set string representation in calcite SQL??



Alessandro is correct. But also, you can set using connect-string
parameters: lex=BIG_QUERY will, I believe, have the desired effect.

On Wed, Dec 16, 2020 at 3:13 AM Alessandro Solimando
<[email protected]&gt; wrote:
&gt;
&gt; Hello,
&gt; you can achieve what you want via the SqlParser configuration
&gt; (.setQuoting() method), for instance:
&gt;
&gt;&nbsp; private static final SqlParser.Config SQL_PARSER_CONFIG =
&gt;
&gt;&nbsp;&nbsp; SqlParser.configBuilder(SqlParser.Config.DEFAULT)
&gt; &gt;&nbsp;&nbsp; .setCaseSensitive(false)
&gt; &gt;&nbsp;&nbsp; .setConformance(SqlConformanceEnum.DEFAULT)
&gt; &gt;&nbsp;&nbsp; .setQuoting(Quoting.DOUBLE_QUOTE) <----
&gt; &gt;&nbsp;&nbsp; .build();
&gt;
&gt;
&gt; Hth,
&gt; Alessandro
&gt;
&gt; On Wed, 16 Dec 2020 at 09:55, ???????? <[email protected]&gt; wrote:
&gt;
&gt; &gt; Default ??String representation is apostrophe in calcite SQL
&gt; &gt; ??like&amp;nbsp;'word'. how do I set this to Double quotes 
??like&amp;nbsp;"word".
&gt; &gt;
&gt; &gt; Default is :
&gt; &gt; select * from table1 where column1 = 'word'
&gt; &gt; I hope to support??
&gt; &gt; select * from table1 where column1 = "word"

Reply via email to