Re: Help in understanding entities and abstractions in Calcite

2019-04-16 Thread Walaa Eldin Moustafa
You might also read this paper: https://arxiv.org/pdf/1802.10233.pdf There is a SIGMOD version of it as well. Thanks, Walaa. On Tue, Apr 16, 2019 at 9:22 AM Chunwei Lei wrote: > > Hi, Naveen > > You can find some helpful docs in > https://calcite.apache.org/docs/algebra.html. Wish it can help yo

[jira] [Created] (CALCITE-3009) It should fail if there are duplicate keys in a .xml file

2019-04-16 Thread Chunwei Lei (JIRA)
Chunwei Lei created CALCITE-3009: Summary: It should fail if there are duplicate keys in a .xml file Key: CALCITE-3009 URL: https://issues.apache.org/jira/browse/CALCITE-3009 Project: Calcite

[jira] [Created] (CALCITE-3008) Making AuxiliaryConverter Pluggable

2019-04-16 Thread Rong Rong (JIRA)
Rong Rong created CALCITE-3008: -- Summary: Making AuxiliaryConverter Pluggable Key: CALCITE-3008 URL: https://issues.apache.org/jira/browse/CALCITE-3008 Project: Calcite Issue Type: Improvement

Re: [DISCUSS] RelCompositeTrait

2019-04-16 Thread Hongze Zhang
You are right, removing the collations could only workaround what causes us to find the issue on multi-sort. Maybe we'd better not to remove them (at least currently) since they provide a way to easily test against composite trait. Hongze > On Apr 17, 2019, at 01:15, Haisheng Yuan wrote: > >>

support for array subquery expression?

2019-04-16 Thread James Taylor
Hello SQL experts, Does Calcite support the ARRAY subquery expression[1]? It looks liked based on SqlArrayQueryConstructor, it does [2]? Do folks know if this is standard SQL and supported in very many databases? The use case is to simplify queries that process arrays. Instead of doing a cross joi

[jira] [Created] (CALCITE-3007) Type mismatch for > ANY subquery in project

2019-04-16 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created CALCITE-3007: -- Summary: Type mismatch for > ANY subquery in project Key: CALCITE-3007 URL: https://issues.apache.org/jira/browse/CALCITE-3007 Project: Calcite Issue Typ

Re: Re: [DISCUSS] RelCompositeTrait

2019-04-16 Thread Vladimir Sitnikov
> Regarding the composite traits, one embarrassing thing I can see so far > is about the method RelTraitSet#simplify[3]. >the traits just simply get wiped. Exactly. Of course no one knows how it should work, however making "RelTraitSet#simplify" a no-op does heal certain cases, and it looks like i

[jira] [Created] (CALCITE-3006) Inaccurate information on site, example code doesn't compile

2019-04-16 Thread Nandor Kollar (JIRA)
Nandor Kollar created CALCITE-3006: -- Summary: Inaccurate information on site, example code doesn't compile Key: CALCITE-3006 URL: https://issues.apache.org/jira/browse/CALCITE-3006 Project: Calcite

Re: Re: [DISCUSS] RelCompositeTrait

2019-04-16 Thread Haisheng Yuan
> it looks like if we want to get these problems fixed quickly we can just > remove > EnumerableValues's collation emitting. I am afraid even removing Values collation enumeration won't actually give it a quick fix, because Multi-sorted table, if there is, might still encounter the same issue

Re: Help in understanding entities and abstractions in Calcite

2019-04-16 Thread Chunwei Lei
Hi, Naveen You can find some helpful docs in https://calcite.apache.org/docs/algebra.html. Wish it can help you. Best, Chunwei Naveen Kumar 于2019年4月16日周二 下午8:05写道: > > Hi, > > I am a engineer at Flipkart, we are building SQL over our stream processing > platform using Calcite. > I am finding i

Connecting Calcite with Apache Phoenix

2019-04-16 Thread Rakesh Nair
Hi, So I've trying to connect Calcite with Apache Phoenix. Code given below: *public Frameworks.ConfigBuilder configPhoenix() {* * SchemaPlus rootSchema = Frameworks.createRootSchema(true);* * DataSource dataSource = JdbcSchema.dataSource("jdbc:phoenix:::/hbase-unsecure", "org.apache.phoenix.jdbc

Delegate queries to source system

2019-04-16 Thread Mark Pasterkamp
Dear all, I have setup calcite to use postgres as a datasource. Right now I am running into an out of memory exception while executing the following query: "select * from table order by id limit 10". Checking the log of postgres it seems like calcite is wanting to first load all data into the memo

Help in understanding entities and abstractions in Calcite

2019-04-16 Thread Naveen Kumar
Hi, I am a engineer at Flipkart, we are building SQL over our stream processing platform using Calcite. I am finding it hard to develop intuition for abstractions and entities in Apache Calcite, is there a book or documentation that walks through them? I would love if I could chat with one of you

Re: [DISCUSS] RelCompositeTrait

2019-04-16 Thread Hongze Zhang
If we minimize the issue scope to Calcite itself, I think the 3 JIRA tickets: CALCITE-2010, CALCITE-2593, CALCITE-2764 that Haisheng has listed (thanks, Haisheng!) are all related to the multi-sorted EnumerableValue more or less. An it looks like if we want to get these problems fixed quickly w

[jira] [Created] (CALCITE-3005) Implement string functions: LEFT, RIGHT

2019-04-16 Thread Forward Xu (JIRA)
Forward Xu created CALCITE-3005: --- Summary: Implement string functions: LEFT, RIGHT Key: CALCITE-3005 URL: https://issues.apache.org/jira/browse/CALCITE-3005 Project: Calcite Issue Type: New Fea