[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16694318#comment-16694318 ] Jark Wu commented on CALCITE-1912: -- Hi [~julianhyde], do you have time to have a look

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16735430#comment-16735430 ] Jark Wu commented on CALCITE-1912: -- Hi [~francischuang], [~julianhyde] sorry to bothe

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16735448#comment-16735448 ] Jark Wu commented on CALCITE-1912: -- Thanks [~francischuang] , I will rebase and fix it

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16736576#comment-16736576 ] Jark Wu commented on CALCITE-1912: -- I have rebased the PR, and all tests passed. Welco

[jira] [Updated] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jark Wu updated CALCITE-1912: - Fix Version/s: 1.19.0 > Support "FOR SYSTEM_TIME AS OF" in regular queries > --

[jira] [Commented] (CALCITE-3271) TVF windowing and EMIT syntax support in Calcite

[ https://issues.apache.org/jira/browse/CALCITE-3271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16911978#comment-16911978 ] Jark Wu commented on CALCITE-3271: -- EMIT is very helpful to early fire windows and tri

[jira] [Commented] (CALCITE-4282) Promote the window table functions window attribute data type with precision 3

[ https://issues.apache.org/jira/browse/CALCITE-4282?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17204446#comment-17204446 ] Jark Wu commented on CALCITE-4282: -- Hi [~danny0405], shouldn't the TIMESTAMP precision

[jira] [Commented] (CALCITE-3780) SESSION Table-valued Function

[ https://issues.apache.org/jira/browse/CALCITE-3780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17213566#comment-17213566 ] Jark Wu commented on CALCITE-3780: -- Hi all, what's the plan to support PARTITION BY sy

[jira] [Commented] (CALCITE-3780) SESSION Table-valued Function

[ https://issues.apache.org/jira/browse/CALCITE-3780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17213578#comment-17213578 ] Jark Wu commented on CALCITE-3780: -- Hi [~amaliujia], I just think the PARTITION BY cla

[jira] [Commented] (CALCITE-3780) SESSION Table-valued Function

[ https://issues.apache.org/jira/browse/CALCITE-3780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17213582#comment-17213582 ] Jark Wu commented on CALCITE-3780: -- This can also help the optimizer know how to add a

[jira] [Commented] (CALCITE-4337) Supports PARTITION BY clause for table function table argument

[ https://issues.apache.org/jira/browse/CALCITE-4337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17214373#comment-17214373 ] Jark Wu commented on CALCITE-4337: -- I dont' think SESSION window TVF must be used with

[jira] [Commented] (CALCITE-4396) Allows table valued functions of FROM and JOIN context without TABLE clause

[ https://issues.apache.org/jira/browse/CALCITE-4396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17230510#comment-17230510 ] Jark Wu commented on CALCITE-4396: -- +1 for this. > Allows table valued functions of F

[jira] [Commented] (CALCITE-4508) Related to FLINK-21162,SQL optimization in OR syntax

[ https://issues.apache.org/jira/browse/CALCITE-4508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17288783#comment-17288783 ] Jark Wu commented on CALCITE-4508: -- This is a duplicate issue of CALCITE-4507, and I a

[jira] [Created] (CALCITE-4545) Unparse a new function of FUNCTION_ID syntax will be quoted

Jark Wu created CALCITE-4545: Summary: Unparse a new function of FUNCTION_ID syntax will be quoted Key: CALCITE-4545 URL: https://issues.apache.org/jira/browse/CALCITE-4545 Project: Calcite Issu

[jira] [Commented] (CALCITE-4545) Unparse a new function of FUNCTION_ID syntax will be quoted

[ https://issues.apache.org/jira/browse/CALCITE-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17306773#comment-17306773 ] Jark Wu commented on CALCITE-4545: -- The {{CURRENT_ROW_TIMESTAMP}} in {{SELECT CURRENT_

[jira] [Updated] (CALCITE-4545) Unparse a new function of FUNCTION_ID syntax will be quoted

[ https://issues.apache.org/jira/browse/CALCITE-4545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jark Wu updated CALCITE-4545: - Fix Version/s: (was: 1.27.0) (was: 1.26.0) > Unparse a new function of FUNCT

[jira] [Created] (CALCITE-3476) ParameterScope should override resolveColumn interface

Jark Wu created CALCITE-3476: Summary: ParameterScope should override resolveColumn interface Key: CALCITE-3476 URL: https://issues.apache.org/jira/browse/CALCITE-3476 Project: Calcite Issue Type

[jira] [Updated] (CALCITE-3476) ParameterScope should override resolveColumn interface

[ https://issues.apache.org/jira/browse/CALCITE-3476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jark Wu updated CALCITE-3476: - Description: I want to validate a SqlNode expression and find this interface {{SqlValidator.validatePa

[jira] [Updated] (CALCITE-3476) ParameterScope should override resolveColumn interface

[ https://issues.apache.org/jira/browse/CALCITE-3476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jark Wu updated CALCITE-3476: - Description: I want to validate a SqlNode expression and find this interface {{SqlValidator.validatePa

[jira] [Commented] (CALCITE-3476) ParameterScope should override resolveColumn interface

[ https://issues.apache.org/jira/browse/CALCITE-3476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16969941#comment-16969941 ] Jark Wu commented on CALCITE-3476: -- Hi [~yanlin-Lynn], I'm already working on it. Will

[jira] [Commented] (CALCITE-3943) Remove the JSON functions keyword from parser

[ https://issues.apache.org/jira/browse/CALCITE-3943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17088412#comment-17088412 ] Jark Wu commented on CALCITE-3943: -- big +1 for this > Remove the JSON functions keywo

[jira] [Commented] (CALCITE-1903) Support charset in LIKE expression

[ https://issues.apache.org/jira/browse/CALCITE-1903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16127221#comment-16127221 ] Jark Wu commented on CALCITE-1903: -- Hi [~julianhyde] , if this is not allowed, how to u

[jira] [Commented] (CALCITE-1903) Support charset in LIKE expression

[ https://issues.apache.org/jira/browse/CALCITE-1903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16262800#comment-16262800 ] Jark Wu commented on CALCITE-1903: -- [~yuqi], it is fixed in Flink FLINK-7451 > Suppor

[jira] [Commented] (CALCITE-1903) Support charset in LIKE expression

[ https://issues.apache.org/jira/browse/CALCITE-1903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16263680#comment-16263680 ] Jark Wu commented on CALCITE-1903: -- Yes, non-ascii should be used like {{_UTF16'测试'}}.

[jira] [Created] (CALCITE-2150) CurrentTimestamp is reduced in subquery

Jark Wu created CALCITE-2150: Summary: CurrentTimestamp is reduced in subquery Key: CALCITE-2150 URL: https://issues.apache.org/jira/browse/CALCITE-2150 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-2150) CurrentTimestamp is reduced in subquery

[ https://issues.apache.org/jira/browse/CALCITE-2150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jark Wu updated CALCITE-2150: - Description: I add two unit test with ReduceExpressionsRule.PROJECT_INSTANCE reduce rule in the commit:

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16541094#comment-16541094 ] Jark Wu commented on CALCITE-1912: -- Hi [~julianhyde] , I have created a PR for this i

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16673003#comment-16673003 ] Jark Wu commented on CALCITE-1912: -- Thanks [~julianhyde], I am looking forward to see

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16674676#comment-16674676 ] Jark Wu commented on CALCITE-1912: -- Thanks. I think the Snapshot operator is a good i

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686454#comment-16686454 ] Jark Wu commented on CALCITE-1912: -- Hi [~julianhyde] , I have updated the PR and addre

[jira] [Created] (CALCITE-1295) ReduceExpressionRule should not reduce AS operator

Jark Wu created CALCITE-1295: Summary: ReduceExpressionRule should not reduce AS operator Key: CALCITE-1295 URL: https://issues.apache.org/jira/browse/CALCITE-1295 Project: Calcite Issue Type: Bu

[jira] [Created] (CALCITE-1297) RelBuilder does not translate identity projects even if they rename fields

Jark Wu created CALCITE-1297: Summary: RelBuilder does not translate identity projects even if they rename fields Key: CALCITE-1297 URL: https://issues.apache.org/jira/browse/CALCITE-1297 Project: Calcite

[jira] [Commented] (CALCITE-1297) RelBuilder does not translate identity projects even if they rename fields

[ https://issues.apache.org/jira/browse/CALCITE-1297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15335277#comment-15335277 ] Jark Wu commented on CALCITE-1297: -- Say we have a Table(f0, f1, f2) , and we want to ma

[jira] [Comment Edited] (CALCITE-1297) RelBuilder does not translate identity projects even if they rename fields

[ https://issues.apache.org/jira/browse/CALCITE-1297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15335294#comment-15335294 ] Jark Wu edited comment on CALCITE-1297 at 6/17/16 3:08 AM: --- Ho

[jira] [Commented] (CALCITE-1297) RelBuilder does not translate identity projects even if they rename fields

[ https://issues.apache.org/jira/browse/CALCITE-1297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15335294#comment-15335294 ] Jark Wu commented on CALCITE-1297: -- However, when I build next expression, such as {rel

[jira] [Commented] (CALCITE-1297) RelBuilder does not translate identity projects even if they rename fields

[ https://issues.apache.org/jira/browse/CALCITE-1297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15337616#comment-15337616 ] Jark Wu commented on CALCITE-1297: -- I'm sorry to disturb you again. I do not get what y

[jira] [Created] (CALCITE-1309) Support LATERAL TABLE

Jark Wu created CALCITE-1309: Summary: Support LATERAL TABLE Key: CALCITE-1309 URL: https://issues.apache.org/jira/browse/CALCITE-1309 Project: Calcite Issue Type: New Feature Component

[jira] [Commented] (CALCITE-1297) RelBuilder does not translate identity projects even if they rename fields

[ https://issues.apache.org/jira/browse/CALCITE-1297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15367225#comment-15367225 ] Jark Wu commented on CALCITE-1297: -- [~julianhyde], I'm glad to work on it. And I have u

[jira] [Commented] (CALCITE-1356) Release Calcite 1.9.0

[ https://issues.apache.org/jira/browse/CALCITE-1356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15434400#comment-15434400 ] Jark Wu commented on CALCITE-1356: -- Hi , I hope CALCITE-1309 could be get into 1.9 rele

[jira] [Commented] (CALCITE-1309) Support LATERAL TABLE

[ https://issues.apache.org/jira/browse/CALCITE-1309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15434440#comment-15434440 ] Jark Wu commented on CALCITE-1309: -- Hi, Julian, it's a little more complex. After chang

[jira] [Commented] (CALCITE-1356) Release Calcite 1.9.0

[ https://issues.apache.org/jira/browse/CALCITE-1356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15435061#comment-15435061 ] Jark Wu commented on CALCITE-1356: -- Ok, I will try to work on it. > Release Calcite 1.

[jira] [Created] (CALCITE-1461) Hard code in JaninoRelMetadataProvider makes shading for Calcite failed

Jark Wu created CALCITE-1461: Summary: Hard code in JaninoRelMetadataProvider makes shading for Calcite failed Key: CALCITE-1461 URL: https://issues.apache.org/jira/browse/CALCITE-1461 Project: Calcite

[jira] [Commented] (CALCITE-1461) Hard coded class name in JaninoRelMetadataProvider breaks shading

[ https://issues.apache.org/jira/browse/CALCITE-1461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15601168#comment-15601168 ] Jark Wu commented on CALCITE-1461: -- Here is the PR link: https://github.com/apache/calc

[jira] [Created] (CALCITE-1472) Support CROSS/OUTER APPLY syntax

Jark Wu created CALCITE-1472: Summary: Support CROSS/OUTER APPLY syntax Key: CALCITE-1472 URL: https://issues.apache.org/jira/browse/CALCITE-1472 Project: Calcite Issue Type: New Feature

[jira] [Commented] (CALCITE-1472) Support CROSS/OUTER APPLY syntax

[ https://issues.apache.org/jira/browse/CALCITE-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15611128#comment-15611128 ] Jark Wu commented on CALCITE-1472: -- Yes, you are right. APPLY should be a non-reserved

[jira] [Commented] (CALCITE-1472) Support CROSS/OUTER APPLY syntax

[ https://issues.apache.org/jira/browse/CALCITE-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15614072#comment-15614072 ] Jark Wu commented on CALCITE-1472: -- I'm not sure I understand correctly. Could you expl

[jira] [Commented] (CALCITE-1472) Support CROSS/OUTER APPLY syntax

[ https://issues.apache.org/jira/browse/CALCITE-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15614178#comment-15614178 ] Jark Wu commented on CALCITE-1472: -- Thank you for the detailed explanation. > Support

[jira] [Commented] (CALCITE-1472) Support CROSS/OUTER APPLY syntax

[ https://issues.apache.org/jira/browse/CALCITE-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15661186#comment-15661186 ] Jark Wu commented on CALCITE-1472: -- Hi [~julianhyde], sorry for the late response. Coul

[jira] [Commented] (CALCITE-1472) Support CROSS/OUTER APPLY syntax

[ https://issues.apache.org/jira/browse/CALCITE-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15662597#comment-15662597 ] Jark Wu commented on CALCITE-1472: -- Yes, you are right, see [this link|https://msdn.mi

[jira] [Commented] (CALCITE-1472) Support CROSS/OUTER APPLY syntax

[ https://issues.apache.org/jira/browse/CALCITE-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15704538#comment-15704538 ] Jark Wu commented on CALCITE-1472: -- Hi [~julianhyde] , I think the change is very good.

[jira] [Created] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

Jark Wu created CALCITE-1912: Summary: Support "FOR SYSTEM_TIME AS OF" in regular queries Key: CALCITE-1912 URL: https://issues.apache.org/jira/browse/CALCITE-1912 Project: Calcite Issue Type: Ne

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

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] [Updated] (CALCITE-1917) Support column reference in "FOR SYSTEM_TIME AS OF"

[ https://issues.apache.org/jira/browse/CALCITE-1917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jark Wu updated CALCITE-1917: - Description: As discussed in mailing list[1], the standard says QSTPS can’t contain a column reference.

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

[ https://issues.apache.org/jira/browse/CALCITE-1917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jark Wu updated CALCITE-1917: - Description: As discussed in mailing list[1], the standard says QSTPS can’t contain a column reference.

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

[ https://issues.apache.org/jira/browse/CALCITE-1917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16110168#comment-16110168 ] Jark Wu commented on CALCITE-1917: -- Hi [~julianhyde] , I expect that we can continue th

[jira] [Commented] (CALCITE-1912) Support "FOR SYSTEM_TIME AS OF" in regular queries

[ https://issues.apache.org/jira/browse/CALCITE-1912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16113902#comment-16113902 ] Jark Wu commented on CALCITE-1912: -- Hi [~julianhyde] do you have suggestions/reference

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

[ https://issues.apache.org/jira/browse/CALCITE-1917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16113904#comment-16113904 ] Jark Wu commented on CALCITE-1917: -- I'm glad to see you agree with it. I will work for