Sorry,
It is CALCITE-3261.
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
On 09/29/2019 16:29，Juan Pan wrote：
Thanks Danny,
Got it. I will watch CALCITE-326.
Regards,
Trista
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
On 09/29/2019
Thanks Danny,
Got it. I will watch CALCITE-326.
Regards,
Trista
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
On 09/29/2019 16:15，Danny Chan wrote：
No worries, Juan Pan, welcome to contribute to Apache Calcite.
Calcite always put the JIRA issues in the first place
No worries, Juan Pan, welcome to contribute to Apache Calcite.
Calcite always put the JIRA issues in the first place instead of GitHub page
because it is really food for bug/problem tracing.
If you have any questions or want to discuss something, welcome to send mail
into the DEV mailing list.
Actually, i think this problem should be already raised by others, for it is
obvious enough. But i visited Calcite gitHub, and can not find issue list, so i
sent this email. Yes, Calcite is using Jira for issues, i got.
Given Calcite implements the interfaces of ResultSetMetadata, ResultSet
There is already a JIRA issue to trace this problem[1], maybe we can move the
discussion to there.
[1] https://issues.apache.org/jira/browse/CALCITE-3261
Best,
Danny Chan
在 2019年9月29日 +0800 AM11:39，Juan Pan ，写道：
>
>
> Hi everyone,
>
>
> I executed SQL `select count(*) from tb1` through Calcite
It's my pleasure, you are welcome ~
Juan Pan 于2019年9月29日周日 下午2:24写道：
> Hi XING,
> I appreciate your kindness. :-D Your detailed and prompt replies really
> helped me a lot.
> I will review the java doc you mentioned.
>
>
> Best wishes,
> Trista
>
>
> Juan Pan
>
>
> panj...@apache.org
> Juan
Hi XING,
I appreciate your kindness. :-D Your detailed and prompt replies really helped
me a lot.
I will review the java doc you mentioned.
Best wishes,
Trista
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
On 09/29/2019 13:58，XING JIN wrote：
You can check the below
You can check the below doc of SqlValidatorUtil#getAlias for explanation:
/**
* Derives an alias for a node, and invents a mangled identifier if it
* cannot.
*
* Examples:
*
*
* Alias: "1 + 2 as foo" yields "foo"
* Identifier: "foo.bar.baz" yields "baz"
* Anything
That means Calcite can only return real columnName or columnLabel from simple
column or alias. And any aggregate function, or calculate expression without
alias, parsing expression, i.e, `EXPR$0` will be returned?
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
On
If no column name given explicitly, e.g. by alias or simple identifier,
Calcite will derive one but not from the aggregate function.
Juan Pan 于2019年9月29日周日 下午1:12写道：
> Thank for your reply. It is a indirect way to get columnName.
>
>
> Calcite can not return the real columnName from SQL, is it
Thank for your reply. It is a indirect way to get columnName.
Calcite can not return the real columnName from SQL, is it right?
Juan Pan
panj...@apache.org
Juan Pan(Trista), Apache ShardingSphere
On 09/29/2019 12:21，XING JIN wrote：
You can try to give an alias for the selected column.
You can try to give an alias for the selected column.
Juan Pan 于2019年9月29日周日 上午11:39写道：
>
>
> Hi everyone,
>
>
> I executed SQL `select count(*) from tb1` through Calcite and
> resultSet.getMetaData().getColumnName(i) in my project. But the result is
> `EXPR$0` not `COUNT(*)`.
>
>
> Is there
Hi everyone,
I executed SQL `select count(*) from tb1` through Calcite and
resultSet.getMetaData().getColumnName(i) in my project. But the result is
`EXPR$0` not `COUNT(*)`.
Is there any way to get real columnName?
Thanks for your attention.
Regard,
Trista
Juan Pan
13 matches
Mail list logo
