Re: Towards a spec for robust streaming SQL, Part 2

2017-08-01 Thread Tyler Akidau
Thank you all for the comments/input, I appreciate the time you've put into this. I've responded to a handful of the major ones. There are some more I'd like to respond to, but I'm out of time for tonight, so more tomorrow. -Tyler On Tue, Aug 1, 2017 at 12:24 PM Julian Hyde wrote: > I have prob

[jira] [Created] (CALCITE-1918) Add support for Regular Expression Operators (RLIKE)

2017-08-01 Thread sunjincheng (JIRA)
sunjincheng created CALCITE-1918: Summary: Add support for Regular Expression Operators (RLIKE) Key: CALCITE-1918 URL: https://issues.apache.org/jira/browse/CALCITE-1918 Project: Calcite Iss

[jira] [Created] (CALCITE-1917) Support column reference in "FOR SYSTEM_TIME AS OF"

2017-08-01 Thread Jark Wu (JIRA)
Jark Wu created CALCITE-1917: Summary: Support column reference in "FOR SYSTEM_TIME AS OF" Key: CALCITE-1917 URL: https://issues.apache.org/jira/browse/CALCITE-1917 Project: Calcite Issue Type: N

[jira] [Created] (CALCITE-1916) Use TPC-DS generator and run tests against TPC-DS at small scale

2017-08-01 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-1916: Summary: Use TPC-DS generator and run tests against TPC-DS at small scale Key: CALCITE-1916 URL: https://issues.apache.org/jira/browse/CALCITE-1916 Project: Calcite

[jira] [Created] (CALCITE-1915) Workaround Jetty SpnegoAuthenticator bug where no challenge is sent

2017-08-01 Thread Josh Elser (JIRA)
Josh Elser created CALCITE-1915: --- Summary: Workaround Jetty SpnegoAuthenticator bug where no challenge is sent Key: CALCITE-1915 URL: https://issues.apache.org/jira/browse/CALCITE-1915 Project: Calcite

[jira] [Created] (CALCITE-1914) Create a DOAP file for Avatica

2017-08-01 Thread Julian Hyde (JIRA)
Julian Hyde created CALCITE-1914: Summary: Create a DOAP file for Avatica Key: CALCITE-1914 URL: https://issues.apache.org/jira/browse/CALCITE-1914 Project: Calcite Issue Type: Bug

Re: Towards a spec for robust streaming SQL, Part 2

2017-08-01 Thread Julian Hyde
I have problems with a couple of the axioms: that a SQL object is either a table or a stream, but not both; and that a query is bounded if and only if it contains no unbounded streams. I don't have problems with other axioms, such that a query is either bounded or unbounded. And I haven't looked i

[jira] [Created] (CALCITE-1913) Include DB version in SqlDialect

2017-08-01 Thread Jess Balint (JIRA)
Jess Balint created CALCITE-1913: Summary: Include DB version in SqlDialect Key: CALCITE-1913 URL: https://issues.apache.org/jira/browse/CALCITE-1913 Project: Calcite Issue Type: Improvement

Re: Handling "HepRelVertex" and "RelSubset" as input

2017-08-01 Thread Jess Balint
Can you share your operand constraints? Where did you see HepRelVertex? As Julian described, the rel nodes are of the correct type when matched with operand constraints. Jess On Tue, Aug 1, 2017 at 7:25 AM, Muhammad Gelbana wrote: > I'm facing a similar problem but with Join inputs. Is there a

Re: Towards a spec for robust streaming SQL, Part 2

2017-08-01 Thread Fabian Hueske
As promised, I went of the document and made some comments. I also added a bit of information about the current SQL support in Flink and its internals. Thanks, Fabian 2017-07-30 13:22 GMT+02:00 Shaoxuan Wang : > Hi Tyler, > Thanks for putting all the efforts into a doc. It is really well written

Re: Handling "HepRelVertex" and "RelSubset" as input

2017-08-01 Thread Muhammad Gelbana
I'm facing a similar problem but with Join inputs. Is there a way to control the type of nodes returned as inputs to a join ? I wrote a rule for a join but it failed to match it because I expect the join inputs to be *JdbcRel* nodes while the inputs were actually *HepRelVertex*. I'm using Drill.

sql run error

2017-08-01 Thread apache_...@163.com
Hi, Kylin2.0 on HDP2.5.3. sql is not work. select T7.F16 as F3,SUM(T7.F0) as F4 from ( select T17.QTR_ID as F16,T8.I_eceb82a4498247aeb911ba59f82148f0 as F0 from KYLIN_CAL_DT T17 inner join ( select KYLIN_SALES.PART_DT, KYLIN_SALES.SELLER_ID, sum(KYLIN_SALES.PRICE) I_eceb82a4498247aeb9

Re: [DISCUSS] Temporal Feature in Calcite

2017-08-01 Thread 伍翀(云邪)
Hi Julian, We are interested in both and I have logged CALCITE-1912 for supporting “FOR SYSTEM_TIME AS OF” in regular queries. Regarding to (b), you mean it can be covered by standard. I agree, the query I posted in the previous mail can be rewrote as a subquery: SELECT * FROM Orders AS