[jira] [Assigned] (CALCITE-3312) TIMESTAMPDIFF cannot be converted to SQL

2024-02-14 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-3312: Assignee: (was: TJ Banghart) > TIMESTAMPDIFF cannot be converted to SQL >

[jira] [Assigned] (CALCITE-1440) Implement planner for converting multiple SQL statements to unified RelNode Tree

2024-02-10 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-1440: Assignee: TJ Banghart > Implement planner for converting multiple SQL statements to

[jira] [Commented] (CALCITE-4013) Remove traitset derivation when creating logical operators

2024-02-09 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17816248#comment-17816248 ] TJ Banghart commented on CALCITE-4013: -- Hey [~Aron.tao] any update on this? If not I'd be happy to

[jira] [Commented] (CALCITE-5846) Preserve filters on non-distinct aggCalls in AggregateExpandWithinDistinctRule

2023-11-10 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17785096#comment-17785096 ] TJ Banghart commented on CALCITE-5846: -- Thanks for the test case [~jingda]! Opened

[jira] [Updated] (CALCITE-5846) Preserve filters on non-distinct aggCalls in AggregateExpandWithinDistinctRule

2023-11-10 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5846: - Summary: Preserve filters on non-distinct aggCalls in AggregateExpandWithinDistinctRule (was:

[jira] [Assigned] (CALCITE-5846) AggregateExpandWithinDistinctRule drops filters on non-distinct aggCalls

2023-11-07 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5846: Assignee: TJ Banghart > AggregateExpandWithinDistinctRule drops filters on non-distinct

[jira] [Updated] (CALCITE-6034) Add `isAutoIncrement` and `isGenerated` arguments to MetaColumn constructor

2023-10-05 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6034?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-6034: - Summary: Add `isAutoIncrement` and `isGenerated` arguments to MetaColumn constructor (was:

[jira] [Created] (CALCITE-6034) Allow `isAutoIncrement` and `isGenerated` arguments to MetaColumn constructor

2023-10-05 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-6034: Summary: Allow `isAutoIncrement` and `isGenerated` arguments to MetaColumn constructor Key: CALCITE-6034 URL: https://issues.apache.org/jira/browse/CALCITE-6034

[jira] [Assigned] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

2023-10-05 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-6021: Assignee: Tanner Clary (was: TJ Banghart) > Add CURRENT_DATETIME function (enabled in

[jira] [Assigned] (CALCITE-6021) Add CURRENT_DATETIME function (enabled in BigQuery library)

2023-09-26 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-6021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-6021: Assignee: TJ Banghart > Add CURRENT_DATETIME function (enabled in BigQuery library) >

[jira] [Assigned] (CALCITE-5290) Add DATE_TRUNC function consistent with Postgres

2023-08-08 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5290: Assignee: Guillaume Massé (was: TJ Banghart) > Add DATE_TRUNC function consistent with

[jira] [Commented] (CALCITE-5290) Add DATE_TRUNC function consistent with Postgres

2023-08-08 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17752127#comment-17752127 ] TJ Banghart commented on CALCITE-5290: -- [~MasseGuillaume] that would be great! I have not had time

[jira] [Commented] (CALCITE-521) Implement metadata requests in remote JDBC driver

2023-06-30 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739137#comment-17739137 ] TJ Banghart commented on CALCITE-521: - Came across this ticket when looking for a {{getFunctions()}}

[jira] [Assigned] (CALCITE-521) Implement metadata requests in remote JDBC driver

2023-06-30 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-521: --- Assignee: TJ Banghart > Implement metadata requests in remote JDBC driver >

[jira] [Comment Edited] (CALCITE-521) Implement metadata requests in remote JDBC driver

2023-06-30 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739137#comment-17739137 ] TJ Banghart edited comment on CALCITE-521 at 6/30/23 3:25 PM: -- Came across

[jira] [Updated] (CALCITE-5676) Appropriately set JDBC `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types

2023-06-02 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5676: - Description: Subtask of CALCITE-5549 to focus on the metadata we can control in calcite-core.

[jira] [Updated] (CALCITE-5676) Appropriately set JDBC `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types

2023-06-02 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5676: - Summary: Appropriately set JDBC `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE`

[jira] [Commented] (CALCITE-5687) lazy get scheme

2023-05-05 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720021#comment-17720021 ] TJ Banghart commented on CALCITE-5687: -- Hey [~yiku123], I've have a similar issue. I'm curious how

[jira] [Comment Edited] (CALCITE-5687) lazy get scheme

2023-05-05 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17720021#comment-17720021 ] TJ Banghart edited comment on CALCITE-5687 at 5/5/23 10:12 PM: --- Hey

[jira] [Commented] (CALCITE-5549) Appropriately set `DATA_TYPE` and `IS_GENERATEDCOLUMN` metadata values for `MEASURE` types

2023-04-25 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17716460#comment-17716460 ] TJ Banghart commented on CALCITE-5549: -- I opened

[jira] [Created] (CALCITE-5676) Appropriately set `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types

2023-04-25 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5676: Summary: Appropriately set `DATA_TYPE` and `TYPE_NAME` metadata values for `MEASURE` types Key: CALCITE-5676 URL: https://issues.apache.org/jira/browse/CALCITE-5676

[jira] [Commented] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

2023-04-20 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714757#comment-17714757 ] TJ Banghart commented on CALCITE-5449: -- We were looking into this a bit further and it seems like

[jira] [Commented] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

2023-04-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714355#comment-17714355 ] TJ Banghart commented on CALCITE-5449: -- We could keep these as custom time unit if we had a way to

[jira] [Comment Edited] (CALCITE-5449) Allow EXTRACT() to accept ISOWEEK and WEEK(WEEKDAY)

2023-04-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714355#comment-17714355 ] TJ Banghart edited comment on CALCITE-5449 at 4/20/23 1:09 AM: --- We could

[jira] [Commented] (CALCITE-5543) Implement BigQuery functions for parsing DATE, TIME, TIMESTAMP, DATETIME

2023-04-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714340#comment-17714340 ] TJ Banghart commented on CALCITE-5543: -- Took longer for me to get around to this than I would have

[jira] [Commented] (CALCITE-5659) Allow CAST in an INTERVAL definition

2023-04-18 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17713682#comment-17713682 ] TJ Banghart commented on CALCITE-5659: -- I wonder if it is better to ease the requirement that 

[jira] [Commented] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-04-03 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17708051#comment-17708051 ] TJ Banghart commented on CALCITE-5625: -- Thanks for the notes Julian! Given that context (and

[jira] [Commented] (CALCITE-5621) Support UDT declarations from root of JSON schema model

2023-04-03 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17708043#comment-17708043 ] TJ Banghart commented on CALCITE-5621: -- Hey Julian, thanks for taking a look. Yes - the order of

[jira] [Comment Edited] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707374#comment-17707374 ] TJ Banghart edited comment on CALCITE-5625 at 3/31/23 5:56 PM: --- Hey

[jira] [Comment Edited] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707374#comment-17707374 ] TJ Banghart edited comment on CALCITE-5625 at 3/31/23 5:55 PM: --- Hey

[jira] [Comment Edited] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707374#comment-17707374 ] TJ Banghart edited comment on CALCITE-5625 at 3/31/23 5:55 PM: --- Hey

[jira] [Commented] (CALCITE-5625) Expand SEARCH RexNode when converting toJson

2023-03-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707374#comment-17707374 ] TJ Banghart commented on CALCITE-5625: -- Hey [~julianhyde] thanks for taking a look! When

[jira] [Commented] (CALCITE-5346) Support for type aliases

2023-03-29 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17706583#comment-17706583 ] TJ Banghart commented on CALCITE-5346: -- I opened CALCITE-5621 for root schema UDT declarations. It

[jira] [Created] (CALCITE-5621) Support UDT declarations from root of JSON schema model

2023-03-29 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5621: Summary: Support UDT declarations from root of JSON schema model Key: CALCITE-5621 URL: https://issues.apache.org/jira/browse/CALCITE-5621 Project: Calcite

[jira] [Commented] (CALCITE-5616) Allow unparsing of SqlIntervalQualifier in EXTRACT to be overridden by dialects

2023-03-28 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17706216#comment-17706216 ] TJ Banghart commented on CALCITE-5616: -- [~tanclary] - this might relate to some of work on

[jira] [Comment Edited] (CALCITE-5616) Allow unparsing of SqlIntervalQualifier in EXTRACT to be overridden by dialects

2023-03-28 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17706216#comment-17706216 ] TJ Banghart edited comment on CALCITE-5616 at 3/29/23 4:59 AM: ---

[jira] [Created] (CALCITE-5616) Allow unparsing of SqlIntervalQualifier in EXTRACT to be overridden by dialects

2023-03-28 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5616: Summary: Allow unparsing of SqlIntervalQualifier in EXTRACT to be overridden by dialects Key: CALCITE-5616 URL: https://issues.apache.org/jira/browse/CALCITE-5616

[jira] [Comment Edited] (CALCITE-3312) TIMESTAMPDIFF cannot be converted to SQL

2023-03-28 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17706098#comment-17706098 ] TJ Banghart edited comment on CALCITE-3312 at 3/29/23 4:03 AM: --- The

[jira] [Commented] (CALCITE-3312) TIMESTAMPDIFF cannot be converted to SQL

2023-03-28 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17706098#comment-17706098 ] TJ Banghart commented on CALCITE-3312: -- The problem begins in {{StandardConvertletTable.java}}

[jira] [Assigned] (CALCITE-3312) TIMESTAMPDIFF cannot be converted to SQL

2023-03-28 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-3312: Assignee: TJ Banghart (was: TANG Wen-hui) > TIMESTAMPDIFF cannot be converted to SQL >

[jira] [Commented] (CALCITE-3312) TIMESTAMPDIFF cannot be converted to SQL

2023-03-27 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705703#comment-17705703 ] TJ Banghart commented on CALCITE-3312: -- Hey [~winipanda] have you started work on this? If not I'd

[jira] [Commented] (CALCITE-5549) Appropriately set `DATA_TYPE` and `IS_GENERATEDCOLUMN` metadata values for `MEASURE` types

2023-03-20 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17702963#comment-17702963 ] TJ Banghart commented on CALCITE-5549: -- The Avatica change is very simple:

[jira] [Commented] (CALCITE-5543) Implement BigQuery functions for parsing DATE, TIME, TIMESTAMP, DATETIME

2023-03-13 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17699719#comment-17699719 ] TJ Banghart commented on CALCITE-5543: -- I hope to start work this week and will try to get

[jira] [Assigned] (CALCITE-5543) Implement missing PARSE BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME.

2023-03-03 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5543: Assignee: TJ Banghart > Implement missing PARSE BigQuery functions for DATE, TIME,

[jira] [Created] (CALCITE-5549) Appropriately set `DATA_TYPE` and `IS_GENERATEDCOLUMN` metadata values for `MEASURE` types

2023-03-01 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5549: Summary: Appropriately set `DATA_TYPE` and `IS_GENERATEDCOLUMN` metadata values for `MEASURE` types Key: CALCITE-5549 URL: https://issues.apache.org/jira/browse/CALCITE-5549

[jira] [Assigned] (CALCITE-5290) Add DATE_TRUNC function consistent with Postgres

2023-02-28 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5290: Assignee: TJ Banghart > Add DATE_TRUNC function consistent with Postgres >

[jira] [Comment Edited] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP, FORMAT_DATE

2023-02-24 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693279#comment-17693279 ] TJ Banghart edited comment on CALCITE-5357 at 2/24/23 5:17 PM: ---

[jira] [Commented] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP, FORMAT_DATE

2023-02-24 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17693279#comment-17693279 ] TJ Banghart commented on CALCITE-5357: -- [~julianhyde] those changes look great - thank you for

[jira] [Updated] (CALCITE-5534) Add `userAgent` JDBC param to Avatica

2023-02-17 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Description: It could be beneficial to add a {{userAgent}} parameter to the JDBC URL

[jira] [Updated] (CALCITE-5534) Add `userAgent` JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Summary: Add `userAgent` JDBC param to Avatica (was: Add `userAgent` as JDBC param to

[jira] [Updated] (CALCITE-5534) Add `userAgent` as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Description: It could be beneficial to add a {{userAgent}} parameter to the JDBC URL

[jira] [Updated] (CALCITE-5534) Add `userAgent` as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Description: It could be beneficial to add a {{userAgent}} parameter to the JDBC

[jira] [Assigned] (CALCITE-5534) Add `userAgent` as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5534: Assignee: TJ Banghart > Add `userAgent` as JDBC param to Avatica >

[jira] [Updated] (CALCITE-5534) Add `userAgent` as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Summary: Add `userAgent` as JDBC param to Avatica (was: Add {{userAgent}} as JDBC param to

[jira] [Updated] (CALCITE-5534) Add {{userAgent}} as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Summary: Add {{userAgent}} as JDBC param to Avatica (was: Add `userAgent` as JDBC param to

[jira] [Updated] (CALCITE-5534) Add `userAgent` as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Description: It could be beneficial to add a {{userAgent}} like parameter to the JDBC

[jira] [Created] (CALCITE-5534) Add `userAgent` as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5534: Summary: Add `userAgent` as JDBC param to Avatica Key: CALCITE-5534 URL: https://issues.apache.org/jira/browse/CALCITE-5534 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-5534) Add `userAgent` as JDBC param to Avatica

2023-02-16 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5534: - Description: It could be beneficial to add a {{userAgent}} like parameter to the JDBC

[jira] [Commented] (CALCITE-5526) Handle unparsing of literals based on type system

2023-02-15 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17689422#comment-17689422 ] TJ Banghart commented on CALCITE-5526: -- So here's an idea given Julian's comments: We add to the

[jira] [Commented] (CALCITE-5526) Handle unparsing of literals based on type system

2023-02-15 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17689357#comment-17689357 ] TJ Banghart commented on CALCITE-5526: -- [~wnoble] Elsewhere you expressed concern on relying on

[jira] [Comment Edited] (CALCITE-5526) Handle unparsing of literals based on type system

2023-02-15 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17689357#comment-17689357 ] TJ Banghart edited comment on CALCITE-5526 at 2/15/23 9:43 PM: --- [~wnoble]

[jira] [Updated] (CALCITE-5520) Improve MSSQL support for datetime literals

2023-02-08 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5520: - Description: Datetime literals in MSSQL can mistakenly be unparsed as string literals. For

[jira] [Created] (CALCITE-5520) Improve MSSQL support for datetime literals

2023-02-08 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5520: Summary: Improve MSSQL support for datetime literals Key: CALCITE-5520 URL: https://issues.apache.org/jira/browse/CALCITE-5520 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-5514) Add a public toRex() instance method for RelJson

2023-02-03 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5514: - Description: CALCITE-5349 added several improvements for creating

[jira] [Updated] (CALCITE-5514) Add a public toRex() instance method for RelJson

2023-02-03 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5514: - Description: CALCITE-5349 added several improvements for creating

[jira] [Updated] (CALCITE-5514) Add a public toRex() instance method for RelJson

2023-02-03 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5514: - Summary: Add a public toRex() instance method for RelJson (was: Add a public toRex() instance

[jira] [Created] (CALCITE-5514) Add a public toRex() instance method for RelJson.

2023-02-03 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5514: Summary: Add a public toRex() instance method for RelJson. Key: CALCITE-5514 URL: https://issues.apache.org/jira/browse/CALCITE-5514 Project: Calcite Issue

[jira] [Commented] (CALCITE-5349) RelJson should support non-standard operators

2023-01-26 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681176#comment-17681176 ] TJ Banghart commented on CALCITE-5349: -- Hey [~julianhyde] thank you for cleaning this up! >

[jira] [Comment Edited] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-26 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681148#comment-17681148 ] TJ Banghart edited comment on CALCITE-5489 at 1/26/23 10:41 PM:

[jira] [Commented] (CALCITE-5489) Cannot convert TIMESTAMP literal to class org.apache.calcite.avatica.util.TimeUnit

2023-01-26 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681148#comment-17681148 ] TJ Banghart commented on CALCITE-5489: -- Sergey's RexBuilderTest seems to validate something that

[jira] [Assigned] (CALCITE-5490) Add a 'naiveMeasures' connection property to allow regular aggregate functions (e.g. SUM, MIN) to be used instead of AGGREGATE

2023-01-25 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5490: Assignee: Will Noble > Add a 'naiveMeasures' connection property to allow regular

[jira] [Assigned] (CALCITE-5490) Add a 'naiveMeasures' connection property to allow regular aggregate functions (e.g. SUM, MIN) to be used instead of AGGREGATE

2023-01-25 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5490: Assignee: (was: TJ Banghart) > Add a 'naiveMeasures' connection property to allow

[jira] [Assigned] (CALCITE-5490) Add a 'naiveMeasures' connection property to allow regular aggregate functions (e.g. SUM, MIN) to be used instead of AGGREGATE

2023-01-23 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5490: Assignee: TJ Banghart > Add a 'naiveMeasures' connection property to allow regular

[jira] [Commented] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2023-01-10 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17657010#comment-17657010 ] TJ Banghart commented on CALCITE-2980: -- Leaving some notes on how we could address format strings

[jira] [Assigned] (CALCITE-2980) Implement the FORMAT clause of the CAST operator

2023-01-04 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-2980: Assignee: TJ Banghart > Implement the FORMAT clause of the CAST operator >

[jira] [Commented] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP, FORMAT_DATE

2023-01-04 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17654646#comment-17654646 ] TJ Banghart commented on CALCITE-5357: -- For me it makes sense to work on

[jira] [Assigned] (CALCITE-5360) Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF

2022-11-15 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart reassigned CALCITE-5360: Assignee: TJ Banghart > Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF >

[jira] [Commented] (CALCITE-5360) Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF

2022-11-10 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17631988#comment-17631988 ] TJ Banghart commented on CALCITE-5360: -- Hey Julian, given that  CALCITE-5155 has been merged,

[jira] [Commented] (CALCITE-5346) Support for type aliases

2022-11-02 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17628035#comment-17628035 ] TJ Banghart commented on CALCITE-5346: -- I was looking at this again and it seems that user-defined

[jira] [Created] (CALCITE-5360) Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF

2022-11-01 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5360: Summary: Implement BigQuery TIMESTAMP_ADD and TIMESTAMP_DIFF Key: CALCITE-5360 URL: https://issues.apache.org/jira/browse/CALCITE-5360 Project: Calcite

[jira] [Created] (CALCITE-5357) Implement BigQuery FORMAT_TIMESTAMP/DATE

2022-10-31 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5357: Summary: Implement BigQuery FORMAT_TIMESTAMP/DATE Key: CALCITE-5357 URL: https://issues.apache.org/jira/browse/CALCITE-5357 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-5346) Support for type aliases

2022-10-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626729#comment-17626729 ] TJ Banghart commented on CALCITE-5346: -- Adding a parser extension to convert custom types to

[jira] [Comment Edited] (CALCITE-5346) Support for type aliases

2022-10-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626709#comment-17626709 ] TJ Banghart edited comment on CALCITE-5346 at 10/31/22 5:19 PM:

[jira] [Commented] (CALCITE-5346) Support for type aliases

2022-10-31 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626709#comment-17626709 ] TJ Banghart commented on CALCITE-5346: -- [~libenchao] pointed out in the mailing list taht Flink

[jira] [Updated] (CALCITE-5349) RelJson should support non-standard operators

2022-10-27 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5349: - Priority: Minor (was: Major) > RelJson should support non-standard operators >

[jira] [Commented] (CALCITE-5349) RelJson should support non-standard operators

2022-10-27 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17625287#comment-17625287 ] TJ Banghart commented on CALCITE-5349: -- Hey Julian, yes that sounds like a better option. In that

[jira] [Commented] (CALCITE-5349) RelJson should support non-standard operators

2022-10-26 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17624788#comment-17624788 ] TJ Banghart commented on CALCITE-5349: -- A solution could be adding a new instance variable of type

[jira] [Updated] (CALCITE-5349) RelJson should support non-standard operators

2022-10-26 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5349: - Description: I am attempting to deserialize {{RexNodes}} that contain non-standard operators

[jira] [Created] (CALCITE-5349) RelJson should support non-standard operators

2022-10-26 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5349: Summary: RelJson should support non-standard operators Key: CALCITE-5349 URL: https://issues.apache.org/jira/browse/CALCITE-5349 Project: Calcite Issue

[jira] [Commented] (CALCITE-5291) Make BigQuery lexical policy case insensitive

2022-09-20 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17607425#comment-17607425 ] TJ Banghart commented on CALCITE-5291: -- This will make the dialect's lex policy and default

[jira] [Updated] (CALCITE-5291) Make BigQuery lexical policy case insensitive

2022-09-20 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5291: - Summary: Make BigQuery lexical policy case insensitive (was: Make lexical policy for BigQuery

[jira] [Commented] (CALCITE-5269) Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC functions

2022-09-20 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17607417#comment-17607417 ] TJ Banghart commented on CALCITE-5269: -- Hey [~julianhyde] thanks for taking a look. It's great to

[jira] [Updated] (CALCITE-5291) Make lexical policy for BigQuery case insensitive

2022-09-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5291: - Summary: Make lexical policy for BigQuery case insensitive (was: Make Lex policy for BigQuery

[jira] [Updated] (CALCITE-5291) Make Lex policy for BigQuery case insensitive

2022-09-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5291: - Description:

[jira] [Updated] (CALCITE-5291) Make Lex policy for BigQuery case insensitive

2022-09-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5291?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5291: - Affects Version/s: 1.27.0 1.26.0 > Make Lex policy for BigQuery case

[jira] [Created] (CALCITE-5291) Make Lex policy for BigQuery case insensitive

2022-09-19 Thread TJ Banghart (Jira)
TJ Banghart created CALCITE-5291: Summary: Make Lex policy for BigQuery case insensitive Key: CALCITE-5291 URL: https://issues.apache.org/jira/browse/CALCITE-5291 Project: Calcite Issue

[jira] [Commented] (CALCITE-5269) Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC functions

2022-09-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17606775#comment-17606775 ] TJ Banghart commented on CALCITE-5269: -- Opened [https://github.com/apache/calcite/pull/2913] but

[jira] [Comment Edited] (CALCITE-5269) Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC functions

2022-09-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17606775#comment-17606775 ] TJ Banghart edited comment on CALCITE-5269 at 9/19/22 9:30 PM: --- Opened

[jira] [Updated] (CALCITE-5269) Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC functions

2022-09-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5269: - Description: Implement missing BigQuery functions for: * TIME_TRUNC * TIMESTAMP_TRUNC

[jira] [Updated] (CALCITE-5269) Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC functions

2022-09-19 Thread TJ Banghart (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] TJ Banghart updated CALCITE-5269: - Summary: Implement BigQuery TIME_TRUNC and TIMESTAMP_TRUNC functions (was: Implement BigQuery

  1   2   >