Re: SQL column names - double quoted

2022-05-26 Thread Sandeep N
Thank you Yanjing, that fix addressed it. --Sandeep On Thu, May 26, 2022 at 5:33 PM Yanjing Wang wrote: > Hi Sandeep, > > try select.toSqlString(new > > AnsiSqlDialect(AnsiSqlDialect.DEFAULT_CONTEXT.withIdentifierQuoteString(""))).getSql(). > > Sandeep N 于2022年5月27日周五 06:03写道: > > > Hi

Re: [ANNOUNCE] Vladimir Ozerov joins Calcite PMC

2022-05-26 Thread Yanjing Wang
Congrats Vladimir! Forward Xu 于2022年5月25日周三 15:18写道: > Congratulations Vladimir! > > > Best, > > ForwardXu > > Stamatis Zampetakis 于2022年5月25日周三 15:05写道: > > > Congratulations Vladimir. You have shown that you care for the project in > > many different ways and it's only natural to see you in

Re: [ANNOUNCE] Chunwei Lei joins Calcite PMC

2022-05-26 Thread Yanjing Wang
Congrats, Chunwei! Forward Xu 于2022年5月25日周三 15:17写道: > Congratulations, Chunwei! > > > Best, > > Forwardxu > > Stamatis Zampetakis 于2022年5月25日周三 14:46写道: > > > Congratulations Chunwei. You have been doing a lot of work for the > project > > and this is very much appreciated! > > Thanks for all

Re: SQL column names - double quoted

2022-05-26 Thread Chunwei Lei
Hi Sandeep, In my project, I used the same way as what Yanjing proposed and it works well. Best, Chunwei On Fri, May 27, 2022 at 8:34 AM Yanjing Wang wrote: > Hi Sandeep, > > try select.toSqlString(new > >

[DISCUSS] not equal operator vs less than combining greater than

2022-05-26 Thread Yanjing Wang
Hi community, I have this sql: select * from "emps" where "name" <> '' and "name" <> '3' I thought it would generate the same plan with select * from "emps" where ("name" > '' or "name" < '') and ("name" > '3' or "name" < '3') but not, the not equal operator consistency is different with less

Re: SQL column names - double quoted

2022-05-26 Thread Yanjing Wang
Hi Sandeep, try select.toSqlString(new AnsiSqlDialect(AnsiSqlDialect.DEFAULT_CONTEXT.withIdentifierQuoteString(""))).getSql(). Sandeep N 于2022年5月27日周五 06:03写道: > Hi Stamatis, > > Thanks for the quick response, I tried your suggestion as follows > > RelToSqlConverter converter = new

Re: SQL column names - double quoted

2022-05-26 Thread Sandeep N
Hi Stamatis, Thanks for the quick response, I tried your suggestion as follows RelToSqlConverter converter = new RelToSqlConverter(new AnsiSqlDialect(AnsiSqlDialect.DEFAULT_CONTEXT.withIdentifierQuoteString(""))); SqlSelect select = converter.visitRoot(relNode).asSelect(); SqlWriterConfig config

Re: SQL column names - double quoted

2022-05-26 Thread Stamatis Zampetakis
Hi Sandeep, If you want to turn off quoting (which I am not sure if it is a good idea) when you go from relational algebra to SQL you have to customize the SqlDialect that you are using via Context#withIdentifierQuoteString [1]. You can find a small example as part of RelToSqlConverterTest here

SQL column names - double quoted

2022-05-26 Thread Sandeep N
Hi all, I am pretty aware that this question may have been asked before as I have found references on stackoverflow but have yet to stumble on a response which lays out the path on solving this. Here is the problem I am facing - I am using relational algebra to generate SQL on a table test_table

Re: [DISCUSS] Towards Calcite 1.31.0

2022-05-26 Thread xiong duan
+1 for mid-June for the first RC. Benchao Li 于2022年5月26日周四 10:31写道: > +1 for mid-June for the first RC. > Thanks Ruben for driving this, and Andrei for being the RM. > > For me, I have two PRs[1][2] which I think it's good to have them in 1.31.0 > And for other issues which I've not opened pr