Re: Cannot connect to hive

2019-06-19 Thread Zhu Feng
In our environment (Hive-2.2x), the following configuration works well. (jdbcCatalog=null, jdbcSchema=db_name) Therefore, maybe you need to add a line in your Shema's json .. jdbcSchema: 'thrift' . Best, DonnyZone Valeriy Trofimov 于2019年6月19日周三

Re: Cannot connect to hive

2019-06-19 Thread Danny Chan
“thrift" is not even a schema, why do you use it here ? Maybe you should try “default" as schema name, and be caution that you should quote the “default” keyword because it’s a reserved word for Calcite. Best, Danny Chan 在 2019年6月19日 +0800 PM11:41,Valeriy Trofimov ,写道: > Hi Zhu, > > Setting it t

Re: [VOTE] Release apache-calcite-1.20.0 (release candidate 0)

2019-06-19 Thread Michael Mior
Francis, Thanks for the note on the commit. You're correct that the commit is the following. My apologies for the mistake. https://github.com/apache/calcite/commit/31a3321a23e995e6c7bdc7f4be5dbee275c5a61f As I noted in my previous email, the key at the link is currently out of date. I have updat

Re: [VOTE] Release apache-calcite-1.20.0 (release candidate 0)

2019-06-19 Thread Francis Chuang
Thanks for being RM for this massive release, Michael! Checked GPG signature - OK Checked hash - OK Ran tests per HOWTO (./mvnw -DskipTests clean install and ./mvnw test) -OK Release notes - OK Had a quick look at the maven artifacts and everything seems to be in place - OK Environment (in Doc

[VOTE] Release apache-calcite-1.20.0 (release candidate 0)

2019-06-19 Thread Michael Mior
Hi all, I have created a build for Apache Calcite 1.20.0, release candidate 0. Thanks to everyone who has contributed to this release. We've got support for anti-joins, recursive queries, new functions, support for recursive queries in the relational algebra, a new adapter, and more! You can rea

Re: Cannot connect to hive

2019-06-19 Thread Valeriy Trofimov
Hi Zhu, Setting it to null shows "database null not found". My schema is missing jdbcCatalog entry. What value should I put there? I could not find anything in hive doc: https://cwiki.apache.org/confluence/display/Hive/HiveClient After playing with it more I've realized that it is able to connect

Re: [DISCUSS] Towards Calcite 1.20.0

2019-06-19 Thread Michael Mior
Thanks to Vladimir and Andrei for coming to the party. I'm rolling out rc0 now and I'll start the vote ASAP. -- Michael Mior mm...@apache.org Le mer. 19 juin 2019 à 11:23, Andrei Sereda a écrit : > > Here is mine > 25E7 0310 6B1B 3D7B 1050 32BD C41C FDDF ED34 C028 > > > On Wed, Jun 19, 201

Re: [DISCUSS] Towards Calcite 1.20.0

2019-06-19 Thread Andrei Sereda
Here is mine 25E7 0310 6B1B 3D7B 1050 32BD C41C FDDF ED34 C028 On Wed, Jun 19, 2019 at 11:04 AM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > Here's mine: > 1A60 90D3 223D CA95 BFD2 5C0E 38F4 7D3E 410C 47B1 > > Vladimir >

Re: [DISCUSS] Towards Calcite 1.20.0

2019-06-19 Thread Vladimir Sitnikov
Here's mine: 1A60 90D3 223D CA95 BFD2 5C0E 38F4 7D3E 410C 47B1 Vladimir

Re: [DISCUSS] Towards Calcite 1.20.0

2019-06-19 Thread Michael Mior
Thanks! Here's my fingerprint. 3114 4918 1CE5 FAA2 71DD 398F 9EFE 53B0 7EE7 CA71 -- Michael Mior mm...@apache.org Le mer. 19 juin 2019 à 10:32, Andrei Sereda a écrit : > > Yes will do. > > I'm on my work so might be late 10-15min (11:10 EST) > > On Wed, Jun 19, 2019 at 9:33 AM Stamatis Zampeta

Re: [DISCUSS] Towards Calcite 1.20.0

2019-06-19 Thread Andrei Sereda
Yes will do. I'm on my work so might be late 10-15min (11:10 EST) On Wed, Jun 19, 2019 at 9:33 AM Stamatis Zampetakis wrote: > Hi Michael, > > I am really sorry but I am afraid I cannot help in the end :( > > I cannot remember the passphrase for my key so I'm also blocked and cannot > sign anyt

Re: [DISCUSS] Towards Calcite 1.20.0

2019-06-19 Thread Stamatis Zampetakis
Hi Michael, I am really sorry but I am afraid I cannot help in the end :( I cannot remember the passphrase for my key so I'm also blocked and cannot sign anything at the moment. Can somebody else sign Michael's key today? Andrei? On Wed, Jun 19, 2019 at 4:47 AM Michael Mior wrote: > Thanks St

[jira] [Created] (CALCITE-3136) Fix the default rule description of ConverterRule.

2019-06-19 Thread TANG Wen-hui (JIRA)
TANG Wen-hui created CALCITE-3136: - Summary: Fix the default rule description of ConverterRule. Key: CALCITE-3136 URL: https://issues.apache.org/jira/browse/CALCITE-3136 Project: Calcite Issu

[jira] [Created] (CALCITE-3135) Calcite decimal literal validation

2019-06-19 Thread Praveen Kumar Desabandu (JIRA)
Praveen Kumar Desabandu created CALCITE-3135: Summary: Calcite decimal literal validation Key: CALCITE-3135 URL: https://issues.apache.org/jira/browse/CALCITE-3135 Project: Calcite

Re: Sybase Dialect for LIMIT / OFFSET

2019-06-19 Thread Zhu Feng
Hi Andrei, You can add a flag in SqlDialect and implement SybaseSqlDialect. public class SqlDialect { private boolean fetchLast = true; .. } Then, you can control the unparse order according to your flag(fetchLast) in dialect (SqlWriter.getDialect()) in SelectSqlOperator. Best, DonnyZone