[jira] [Commented] (CALCITE-1911) Support within clause in MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16108289#comment-16108289 ] Dian Fu commented on CALCITE-1911: -- Right, I think the {{rowtime}} column can be seen as the timestamp

[jira] [Commented] (CALCITE-1911) Support within clause in MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16108279#comment-16108279 ] Julian Hyde commented on CALCITE-1911: -- Here's a possible solution. If people want to use WITHIN,

[jira] [Commented] (CALCITE-1905) Varargs in user-defined functions

[ https://issues.apache.org/jira/browse/CALCITE-1905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16108263#comment-16108263 ] yuqi commented on CALCITE-1905: --- Ok. thanks for your attention > Varargs in user-defined functions >

[jira] [Comment Edited] (CALCITE-1911) Support within clause in MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16108257#comment-16108257 ] Dian Fu edited comment on CALCITE-1911 at 8/1/17 1:36 AM: -- Correct, this is not

[jira] [Commented] (CALCITE-1911) Support within clause in MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16108257#comment-16108257 ] Dian Fu commented on CALCITE-1911: -- Yes, this is not in Oracle 12 and also not in the SQL standard, but

[jira] [Closed] (CALCITE-283) Add TPC-DS data generator

[ https://issues.apache.org/jira/browse/CALCITE-283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde closed CALCITE-283. --- Fixed a long time ago in

[jira] [Resolved] (CALCITE-283) Add TPC-DS data generator

[ https://issues.apache.org/jira/browse/CALCITE-283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-283. - Resolution: Fixed Fix Version/s: 0.8 > Add TPC-DS data generator >

[jira] [Updated] (CALCITE-283) Add TPC-DS data generator

[ https://issues.apache.org/jira/browse/CALCITE-283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-283: Description: Add a generator for TPC-DS data set, similar to what CALCITE-238 did for TPC-H. This

[jira] [Comment Edited] (CALCITE-1909) The output rowType should also include partition by and order by key columns

[ https://issues.apache.org/jira/browse/CALCITE-1909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107996#comment-16107996 ] Julian Hyde edited comment on CALCITE-1909 at 7/31/17 9:43 PM: --- [~ransom],

[jira] [Comment Edited] (CALCITE-1911) Support within clause in MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107993#comment-16107993 ] Julian Hyde edited comment on CALCITE-1911 at 7/31/17 9:42 PM: --- To be

[jira] [Resolved] (CALCITE-1905) Varargs in user-defined functions

[ https://issues.apache.org/jira/browse/CALCITE-1905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-1905. -- Resolution: Won't Fix Marking "won't fix". But if you disagree I'm open to a discussion. >

[jira] [Commented] (CALCITE-1909) The output rowType should also include partition by and order by key columns

[ https://issues.apache.org/jira/browse/CALCITE-1909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107996#comment-16107996 ] Julian Hyde commented on CALCITE-1909: -- [~zhiqiang,he] What do you think? > The output rowType

[jira] [Commented] (CALCITE-1911) Support within clause in MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107993#comment-16107993 ] Julian Hyde commented on CALCITE-1911: -- To be clear, this is not in Oracle 12, and it is not in the

[jira] [Resolved] (CALCITE-1901) SQL reference should say that "ONLY" is required after "FETCH ... ROWS"

[ https://issues.apache.org/jira/browse/CALCITE-1901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-1901. -- Resolution: Fixed Fix Version/s: 1.14.0 Fixed in

[jira] [Comment Edited] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

[ https://issues.apache.org/jira/browse/CALCITE-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107842#comment-16107842 ] Julian Hyde edited comment on CALCITE-1588 at 7/31/17 7:40 PM: --- As [~gian]

[jira] [Commented] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

[ https://issues.apache.org/jira/browse/CALCITE-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107842#comment-16107842 ] Julian Hyde commented on CALCITE-1588: -- As [~gian] points out, Oracle, BigQuery and MemSQL support

[jira] [Commented] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

[ https://issues.apache.org/jira/browse/CALCITE-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107708#comment-16107708 ] Julian Hyde commented on CALCITE-1588: -- [~gian], That's OK. If we're going to add an on-off switch

[jira] [Commented] (CALCITE-1882) Can't obtain the user defined aggregate function such as sum,avg by calcite

[ https://issues.apache.org/jira/browse/CALCITE-1882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107704#comment-16107704 ] Julian Hyde commented on CALCITE-1882: -- Obviously, hundreds of failing test cases is not OK. What

[jira] [Commented] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

[ https://issues.apache.org/jira/browse/CALCITE-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16107560#comment-16107560 ] Gian Merlino commented on CALCITE-1588: --- In Druid at least, you don't get to specify the accuracy

[jira] [Commented] (CALCITE-1588) Add SQL syntax to allow approximate LIMIT and distinct-COUNT

[ https://issues.apache.org/jira/browse/CALCITE-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16106858#comment-16106858 ] Ethan Wang commented on CALCITE-1588: - regarding syntax {code}COUNT(DISTINCT customerId) APPROXIMATE