[jira] [Created] (CALCITE-4593) DiffRepository tests should fail if XML resources are not in alphabetical order

2021-04-27 Thread Julian Hyde (Jira)
Julian Hyde created CALCITE-4593: Summary: DiffRepository tests should fail if XML resources are not in alphabetical order Key: CALCITE-4593 URL: https://issues.apache.org/jira/browse/CALCITE-4593

Re: Proposal to extend Calcite into a incremental query optimizer

2021-04-27 Thread Botong Huang
Hi all, The meeting yesterday was fun and productive. As discussed, this is the call to schedule our second meeting. We encourage everyone to add their time preferences during 05/01 - 05/15 here: https://docs.google.com/document/d/1wyNjB94uSGwHtVvGYDwaLlCghUJE-7aDLnCdKKXJN1o/edit?usp=sharing

Re: Do we have plans to do more work about CTE

2021-04-27 Thread Julian Hyde
Can you define CTE? (I know of a few concepts that could be described as such.) Give an example SQL query and the kind of optimization you had in mind. > On Apr 27, 2021, at 6:51 AM, JiaTao Tao wrote: > > Seems we have very limited optimize about CTE current, do we have any plan > to improve

Re: How to extend SQL type system?

2021-04-27 Thread Julian Hyde
If the type is widely used we could consider supporting it. Which databases have a UUID type? Is there a standard ODBC/JDBC type code for it? Are there any built-in functions that operate on UUIDs? Another option is to create a user-defined type. Julian > On Apr 27, 2021, at 7:04 AM, JiaTao

Re: How to extend SQL type system?

2021-04-27 Thread JiaTao Tao
I think the only way is to add your type to SqlTypeName and override RelDataTypeSystem/RelDataTypeFactory if needed Regards! Aron Tao Taras Ledkov 于2021年4月27日周二 下午5:42写道: > Hi all, > > I'm looking for the way to extend SQL types for my engine based on Calcite. > Now calcite doesn't support

Do we have plans to do more work about CTE

2021-04-27 Thread JiaTao Tao
Seems we have very limited optimize about CTE current, do we have any plan to improve this? Regards! Aron Tao

How to extend SQL type system?

2021-04-27 Thread Taras Ledkov
Hi all, I'm looking for the way to extend SQL types for my engine based on Calcite. Now calcite doesn't support UUID sql type. This could be fixed by calcite patch, but what are the best practices for adding new engine-specific type? e.g. I have to introduce new SQL type MY_UUID etc.