Re: Help to parse spark dialect

2020-06-26 Thread Rui Wang
There was a relevant thread about PostgresQL dialect, you might check it as a reference: https://lists.apache.org/thread.html/r906f15c3f7a276ae5e2c68f79a11dc111c5862579848ab8f379b9925%40%3Cdev.calcite.apache.org%3E -Rui On Fri, Jun 26, 2020 at 1:26 PM Tang, Mingjun wrote: > Hi dear calcite

Re: Question about timestampdiff

2020-06-26 Thread Julian Hyde
Is your question about semantics or implementation? If it's semantics, it's useful if you provide an example where Calcite gives a different result than another DBMS. I find https://rextester.com/l/mysql_online_compiler useful for that. If it's implementation, you should know that YEAR and MONTH

Help to parse spark dialect

2020-06-26 Thread Tang, Mingjun
Hi dear calcite community, This is a developer from eBay, I’m trying to parse and optimize spark sql with calcite, but there’re many grammars not supported by default calcite parser.jj, such as ‘create or replace temporary view’ or ‘insert overwrite’, is there a template file I can use to

Re: CALCITE-4088

2020-06-26 Thread Julian Hyde
I think CALCITE-471 should have been marked 'fixed' a long time ago, when we resolved https://issues.apache.org/jira/browse/CALCITE-884. I don't think we should add this functionality to the file adapter. No new functionality in the demo adapter. I've explained my reasons in

CALCITE-4088

2020-06-26 Thread James Anderson
Hi Calcite developers, I'm new to the Calcite project and have opened CALCITE-4088 based on a use case of mine. I'd appreciate any feedback on that issue, and also to have my JIRA account (anderson.900) registered as a contributor so that it can be assigned to me. My plan is to make a very

Using the Calcite Babel Parser as a Blackbox

2020-06-26 Thread Subin Lee
Hello! I hope this email finds you well. My name is Subin and I am an intern at Google trying to utilize the Calcite Parser. In trying to use the parser, I've been a bit struggling on how to leverage the code in the Calcite code base through java. Essentially, I want to use Calcite's Sql Parser

Re: Calcite Tutorial "class not found error".

2020-06-26 Thread Michael Mior
Unfortunately I don't have a Windows environment I can readily test on, but could open a JIRA case? My first guess would be that there's an issue with the buildSqllineClasspath Gradle task on Windows. -- Michael Mior mm...@apache.org -- Michael Mior mm...@apache.org Le jeu. 25 juin 2020 à

Calcite-Master - Build # 1809 - Failure

2020-06-26 Thread Apache Jenkins Server
The Apache Jenkins build system has built Calcite-Master (build #1809) Status: Failure Check console output at https://builds.apache.org/job/Calcite-Master/1809/ to view the results.

Inquiry regarding handling of WITH clause without a corresponding SELECT FROM

2020-06-26 Thread James Kim
Hello, We recently discovered a NPE issue with a query and wasn't sure if the query should be considered valid or not. Please find more information regarding this on the ticket I just made: https://issues.apache.org/jira/browse/CALCITE-4092 I found that handling of queries like these differ

Calcite PR CI offten failed due to elasticsearch:test

2020-06-26 Thread JiaTao Tao
Seems an unstable case. Regards! Aron Tao