Re: [ANNOUNCE] New committer: Vladimir Ozerov

[段雄]

Congratulations!

XING JIN  于2021年6月24日周四 上午10:21写道：

> Congratulations ~
>
> Best,
> Jin
>
> guangyuan wang  于2021年6月24日周四 上午9:50写道：
>
> > Congratulations!
> >
> > Francis Chuang  于2021年6月24日周四 上午6:39写道：
> >
> > > Congrats, Vladimir!
> > >
> > > Francis
> > >
> > > On 24/06/2021 7:48 am, Haisheng Yuan wrote:
> > > > Congratulations and thanks for your contributions, Vladimir!
> > > >
> > > > Regards,
> > > > Haisheng
> > > >
> > > > On 2021/06/23 21:34:40, Stamatis Zampetakis 
> wrote:
> > > >> Apache Calcite's Project Management Committee (PMC) has invited
> > Vladimir
> > > >> Ozerov to
> > > >> become a committer, and we are pleased to announce that he has
> > accepted.
> > > >>
> > > >> Vladimir is among the few people who know very well the internal
> > > workings
> > > >> of the
> > > >> Calcite optimizer. He started and participated in many discussions
> > about
> > > >> the core engine and contributed ideas and code for making it better.
> > > >> Moreover, Vladimir has blogged and talked about Calcite in various
> > > >> conferences and meetups giving publicity and showcasing the
> > > capabilities of
> > > >> the project.
> > > >>
> > > >> Vladimir, welcome, thank you for your contributions, and we look
> > > forward to
> > > >> your
> > > >> further interactions with the community! If you wish, please feel
> free
> > > to
> > > >> tell
> > > >> us more about yourself and what you are working on.
> > > >>
> > > >> Stamatis (on behalf of the Apache Calcite PMC)
> > > >>
> > >
> >
>

Re: PR for review

[段雄]

Thanks for your time.

JiaTao Tao  于2021年4月26日周一 上午10:46写道：

> I'll take a look
>
>
> Regards!
>
> Aron Tao
>
>
> 段雄  于2021年4月23日周五 下午2:54写道：
>
> > Hey guys, here is my PR needed one more review:
> > https://github.com/apache/calcite/pull/2402 I would appreciate if anyone
> > can review it.
> >
>

PR for review

[段雄]

Hey guys, here is my PR needed one more review:
https://github.com/apache/calcite/pull/2402 I would appreciate if anyone
can review it.

Support if function syntax: IF( condition, [value_if_true], [value_if_false] )

[段雄]

Hi all, I use calcite find can't handle if function well.
```
 No match found for function signature IF(, ,
) (state=,code=0)
```

So I want to add support this function in calcite, If you agree with this view.
I will create an issue and work on. Thank you very much.

Request to be a contributor in jira

[段雄]

Hi, My name is xiong duan,I'm working for Hikvision. I create a issue about
CALCITE-4585  . I want
try to be a contributor. can you assign this issue to me? Thank you very
much.

Re: how to use Avatica JDBC query druid, sql body contains Chinese

[段雄]

Hi. You can directly use AvaticaProtobufHandler to resolve about chinese
problem. The avatica default use AvaticaJsonHandler.

leeqiang wang  于2021年3月20日周六 上午12:20写道：

> Hi,All
> Recently,  i make Druid SQL queries using the Avatica JDBC driver,but i met
> a question ;
> if sql body contains  Chinese,then return nothing; so i open the source
> code,i find a method:
>
> when request contains Chinese,then sql body may translate into '???',so can
> you give me some
> advise.
>
> *org.apache.calcite.avatica.remote.RemoteService.apply*
>
> public String apply(String request) {
> byte[] response = client.send(request.getBytes(StandardCharsets.UTF_8));
> return new String(response, StandardCharsets.UTF_8);
>
> my *pom file* is :
>
> 
>org.apache.calcite.avatica
>avatica-core
>1.17.0
> 
>
>
> and *my connection code* is  like this:
>
> // Connect to /druid/v2/sql/avatica/ on your Broker. String url =
> "jdbc:avatica:remote:url=http://localhost:8082/druid/v2/sql/avatica/;; //
> Set any connection context parameters you need here (see "Connection
> context" below). // Or leave empty for default behavior. Properties
> connectionProperties = new Properties(); try (Connection connection =
> DriverManager.getConnection(url, connectionProperties)) { try ( final
> Statement statement = connection.createStatement(); final ResultSet
> resultSet = statement.executeQuery(query) ) { while (resultSet.next()) { //
> process result set } } }
>
> sql body like :
>
> select '连接' as link, age from test where name = '小猫'
>

Re: count(if(a=1, 1, null)) syntax support

[段雄]

Hi,you Zhuang I find clacite have SqlIfFunction,but it don't  accomplish.
you Zhuang  于2021年2月21日周日 上午2:39写道：

> when does calcite support count(if(a=1, 1, null)) syntax ? spark, hive,
> clickhouse, impala, presto support the syntax for a long time.
>