Re: Creating a parser for Big query

2021-12-17 Thread Maxim Gramin
gt; FROM 307320.test_dataset.customers > > > > On Fri, Dec 17, 2021 at 5:47 AM Maxim Gramin > wrote: > > > Can you show the query? I don't see this one. > > > > On Thu, Dec 16, 2021 at 10:12 PM Arash Bizhan zadeh > > wrote: > > > > > Hi,

Re: Creating a parser for Big query

2021-12-17 Thread Maxim Gramin
Can you show the query? I don't see this one. On Thu, Dec 16, 2021 at 10:12 PM Arash Bizhan zadeh wrote: > Hi, > I am trying to create a parser to parse big query statements like this - > this is kotlin btw: > > val sqlParserConfig = BigQuerySqlDialect( > > BigQuerySqlDialect.DEFAULT_CONTEXT.wit

Re: Using LogicalCalc in ProjectCalcMergeRule and FilterCalcMergeRule

2021-12-14 Thread Maxim Gramin
Thanks, I registered Jira task and PR https://issues.apache.org/jira/browse/CALCITE-4936 On Sat, Dec 11, 2021 at 4:52 AM Julian Hyde wrote: > Comments inline. > > > On Dec 10, 2021, at 4:34 AM, Максим Грамин wrote: > > > > 1. In FilterCalcMergeRule get rid of casting to LogicalCalc and > Logica

Re: how to represent and optimize a query over partitioned storage

2021-12-10 Thread Maxim Gramin
I assume that some of the filter conditions (which are involved in the choice of partitions ) may by pushdown'ed to TableScan On Fri, Dec 10, 2021 at 7:29 PM Константин Новиков wrote: > > Hi, > > Given some partitioned storage, we can omit the scan of some partitions > when a filter is present.