[jira] [Created] (CALCITE-2617) FilterProjectTransposeRule should allow filter conditions with correlated variables to be pushed down

2018-10-10 Thread Stamatis Zampetakis (JIRA)
Stamatis Zampetakis created CALCITE-2617: Summary: FilterProjectTransposeRule should allow filter conditions with correlated variables to be pushed down Key: CALCITE-2617 URL: https://issues.apache.org/jir

Calcite IN operator handling

2018-10-10 Thread Mykola Zerniuk
Hello calcite devs! My name is Mykola, a am software engineer. We actively use calcite framework in our project, and recently faced with next issue: Some of SQL has huge IN list (more than 1500). Right now Calcite's SQL parser replaces INs with ORs or sub-queries depending on the inSubQueryThresho

[jira] [Created] (CALCITE-2618) It is not possible to execute IN on Enumerable: "cannot translate call IN"

2018-10-10 Thread Anton Haidai (JIRA)
Anton Haidai created CALCITE-2618: - Summary: It is not possible to execute IN on Enumerable: "cannot translate call IN" Key: CALCITE-2618 URL: https://issues.apache.org/jira/browse/CALCITE-2618 Projec

Hints support

2018-10-10 Thread Arina Yelchiyeva
Hi all, currently Calcite does not support hints. Since usually hints are expressed as multi-line comment after SELECT keyword followed by the plus sign [1], Calcite ignores them as all others comments.It can be useful if Calcite will provide functionality to store hints and allow source system to

Re: Hints support

2018-10-10 Thread Julian Hyde
We’ve discussed hints before. There may even be a JIRA case. I’d like to see a concrete proposal, not just for syntax, but how the hints would make their way through relational algebra. Julian > On Oct 10, 2018, at 07:57, Arina Yelchiyeva > wrote: > > Hi all, > > currently Calcite does not

Re: Hints support

2018-10-10 Thread Arina Yelchiyeva
Thanks, Julian. I'll take a look at the Jiras first. Though for my use case I just need Calcite to store the hints, how they would be applied would be decided outside of Calcite. Kind regards, Arina On Wed, Oct 10, 2018 at 6:06 PM Julian Hyde wrote: > We’ve discussed hints before. There may eve

Re: Calcite IN operator handling

2018-10-10 Thread Michael Mior
You should be able to work around this by setting inSubQueryThreshold to Integer.MAX_VALUE.. -- Michael Mior mm...@apache.org Le mer. 10 oct. 2018 à 10:04, Mykola Zerniuk a écrit : > Hello calcite devs! > My name is Mykola, a am software engineer. We actively use calcite > framework in our pro

Re: Hints support

2018-10-10 Thread Julian Hyde
Can you explain what you mean by “store”? Describe the API changes you’d like, or unit tests. Julian > On Oct 10, 2018, at 08:16, Arina Yelchiyeva > wrote: > > Thanks, Julian. I'll take a look at the Jiras first. > Though for my use case I just need Calcite to store the hints, how they > wo

[jira] [Created] (CALCITE-2619) Reduce string literal creation cost by removing charset check

2018-10-10 Thread Ted Xu (JIRA)
Ted Xu created CALCITE-2619: --- Summary: Reduce string literal creation cost by removing charset check Key: CALCITE-2619 URL: https://issues.apache.org/jira/browse/CALCITE-2619 Project: Calcite Issu