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

+1 (non-binding) On macOS Sierra 10.12.6 and jdk1.8.0_201 - mvn clean install OK - checked signatures and checksums OK - release note OK Thank you for the release, Michael. Best, Chunwei On Sat, Jun 22, 2019 at 1:39 AM Michael Mior wrote: > Thanks Stamatis! Can you open a JIRA case for

Re: Cannot connect to hive

Thanks all for the advice, but nothing works for me. If it works for you, do you use an official Spark build or your own custom build with possible bug fixes that make it work? I found this bug in Spark that could cause my issue: https://issues.apache.org/jira/browse/SPARK-9686. I'll let you know

Avatica java.sql.Date offset calculation bug

The java docs says that the calculated timezone offset needs to be *added* [1] while avatica *subtracts* it [2]. I even saw this happening multiple times in the same class which makes me think, is this actually a bug or not ? I'm facing a case supporting that this is a bug and the javadocs

Re: Re: Re: [DISCUSSION] Problem caused by flattening of struct fields

I am not familiar with the usage of NEW. But checking the comments of SqlNewOperator, the NEW operator accepts 1 argument, so I guess you are right. But need someone else's confirmation. - Haisheng -- 发件人：Igor Guzenko 日　

Re: Pluggable JDBC types

I believe you're correct. Thanks a lot for your help. Thanks, Gelbana On Fri, Jun 21, 2019 at 3:51 PM Stamatis Zampetakis wrote: > For the use-case that you described, I think what needs to be changed is in > CalcitePrepareImpl#getTypeName [1]. > Possibly instead of using

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

Thanks Stamatis! Can you open a JIRA case for the test fixes? I'm certainly not opposed to recognizing other contributors in the release notes although it's something I haven't done in the past. If we really want those in, I can go back and add when the site is updated post-release. -- Michael

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

+1 (non-binding). Thank you for the release, Michael. Environment: MacOS. Maven 3.6.0. AdoptOpenJDK 11.0.3 mvn clean install - OK sh256 check - OK GPG check - OK Release notes - OK On Fri, Jun 21, 2019 at 12:25 PM Stamatis Zampetakis wrote: > Windows 10 Pro, jdk1.8.0_202, maven 3.6.1 > *

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

Windows 10 Pro, jdk1.8.0_202, maven 3.6.1 * Checked signatures and checksums OK * Went over release note OK I've noticed that the contributors (non committers) names do not appear in the release note. I had the impression that the purpose of adding their name in the commit message was mainly for

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

+1 On macOS 10.14.5, openjdk 11.0.2: - Built and ran unit tests from tarball OK - Built and ran unit tests from target commit 3979b460c OK - Checked signatures and hashes OK Thanks Michael! Hongze > On Jun 21, 2019, at 06:42, Michael Mior wrote: > > Thanks for noting the issue in the

Re: Re: [DISCUSSION] Problem caused by flattening of struct fields

Thanks for quick answer, I'll work on the CALCITE-3138 jira. If I'm not wrong this collection of fields back after flatten supposed to be done like rex invocation to create new row. For example, collecting projection might look like:

Re: JIRA contributor permission - cuixiaozong

Hi Xiaozong, I added you as a contributor in JIRA. Welcome to the project! Stamatis On Fri, Jun 21, 2019 at 12:43 PM cuixiaozong wrote: > Hi, > I want to contribute to Apache Calcite. > Would you please give me the contributor permission? > My JIRA ID is cuixiaozong > > > Regards!

JIRA contributor permission - cuixiaozong

Hi, I want to contribute to Apache Calcite. Would you please give me the contributor permission? My JIRA ID is cuixiaozong Regards!

Re: Joining two tables while each table returns a single row of nulls

Hi Muhammad, It seems to be the problem with Linq4q[1]. When the current value is null in left side (i.e., outers), Linq4q sets (innerEnumerable=null) directly, resulting an emptyEnumerator. You can also try Q1: result expected (1, NULL, NULL) SELECT *FROM (SELECT 1, NULLIF(5, 5)) a, (SELECT

Re: Sybase Dialect for LIMIT / OFFSET

Hi Andrei It may not be in scope to support but to note, Sybase (certainly IQ, but likely ASE?) does not support the limit / top in nested / sub queries. You need to simulate it via adding an olap row number column and performing a filter on that (and then dropping the row number column from