[jira] [Commented] (CALCITE-482) Implement SQL and planner hints

2020-01-13 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014905#comment-17014905 ] Vladimir Sitnikov commented on CALCITE-482: --- {quote} Why do you think we shoul

[jira] [Resolved] (CALCITE-3644) Calc on the Intersect in target is not being matched

2020-01-13 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3644. Fix Version/s: 1.22.0 Resolution: Fixed Fixed in https://github.com/apache/calcit

[jira] [Commented] (CALCITE-482) Implement SQL and planner hints

2020-01-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014869#comment-17014869 ] Danny Chen commented on CALCITE-482: bq. Now you add BiFunction handler function tha

[jira] [Updated] (CALCITE-3716) ResultSetMetaData.getTableName should return empty string, not null, when column does not map to a table

2020-01-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3716: Labels: pull-request-available (was: ) > ResultSetMetaData.getTableName should return em

[jira] [Assigned] (CALCITE-3717) Query fails with "division by zero" exception

2020-01-13 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu reassigned CALCITE-3717: - Assignee: Feng Zhu > Query fails with "division by zero" exception > -

[jira] [Updated] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-1824: Labels: pull-request-available (was: ) > GROUP_ID returns wrong result > ---

[jira] [Commented] (CALCITE-3593) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

2020-01-13 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014815#comment-17014815 ] Jin Xing commented on CALCITE-3593: --- Thanks a lot, [~julianhyde] ~ > RelToSqlConvert

[jira] [Resolved] (CALCITE-3466) JDBC adapter incorrectly drops GROUP BY clause of sub-query

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3466. -- Resolution: Fixed Fixed in [571cf95a|https://github.com/apache/calcite/commit/571cf95a1564c9

[jira] [Resolved] (CALCITE-3593) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3593. -- Resolution: Fixed Fixed in  [3621b61e|https://github.com/apache/calcite/commit/3621b61ea0bca9

[jira] [Commented] (CALCITE-3730) Add hints to RelBuilder

2020-01-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014774#comment-17014774 ] Danny Chen commented on CALCITE-3730: - All the "hints" arguments are added as optio

[jira] [Updated] (CALCITE-3466) JDBC adapter incorrectly drops GROUP BY clause of sub-query

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3466: - Component/s: (was: core) jdbc-adapter > JDBC adapter incorrectly drops GRO

[jira] [Updated] (CALCITE-3593) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3593: - Component/s: jdbc-adapter > RelToSqlConverter changes target of ambiguous HAVING clause with a

[jira] [Commented] (CALCITE-3593) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014760#comment-17014760 ] Julian Hyde commented on CALCITE-3593: -- Reviewing and will commit shortly. > RelT

[jira] [Updated] (CALCITE-3593) RelToSqlConverter changes target of ambiguous HAVING clause with a Project on Filter on Aggregate

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3593: - Fix Version/s: 1.22.0 > RelToSqlConverter changes target of ambiguous HAVING clause with a Proj

[jira] [Updated] (CALCITE-3466) JDBC adapter incorrectly drops GROUP BY clause of sub-query

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3466: - Summary: JDBC adapter incorrectly drops GROUP BY clause of sub-query (was: JDBC adapter droppe

[jira] [Commented] (CALCITE-3730) Add hints to RelBuilder

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014636#comment-17014636 ] Julian Hyde commented on CALCITE-3730: -- I had a different idea, which would preven

[jira] [Commented] (CALCITE-1824) GROUP_ID returns wrong result

2020-01-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014579#comment-17014579 ] Julian Hyde commented on CALCITE-1824: -- My first rewrite duplicated rows before th

[jira] [Assigned] (CALCITE-3716) ResultSetMetaData.getTableName should return empty string, not null, when column does not map to a table

2020-01-13 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing reassigned CALCITE-3716: - Assignee: Jin Xing > ResultSetMetaData.getTableName should return empty string, not null, when

[jira] [Updated] (CALCITE-3731) Add IF function for BigQuery, Hive and Spark Dialects

2020-01-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3731: Labels: pull-request-available (was: ) > Add IF function for BigQuery, Hive and Spark Di

[jira] [Created] (CALCITE-3731) Add IF function for BigQuery, Hive and Spark Dialects

2020-01-13 Thread vaibhav jain (Jira)
vaibhav jain created CALCITE-3731: - Summary: Add IF function for BigQuery, Hive and Spark Dialects Key: CALCITE-3731 URL: https://issues.apache.org/jira/browse/CALCITE-3731 Project: Calcite I

[jira] [Comment Edited] (CALCITE-482) Implement SQL and planner hints

2020-01-13 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014287#comment-17014287 ] Vladimir Sitnikov edited comment on CALCITE-482 at 1/13/20 12:45 PM: -

[jira] [Commented] (CALCITE-482) Implement SQL and planner hints

2020-01-13 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014287#comment-17014287 ] Vladimir Sitnikov commented on CALCITE-482: --- What I mean is CALCITE-482 create

[jira] [Commented] (CALCITE-482) Implement SQL and planner hints

2020-01-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014282#comment-17014282 ] Danny Chen commented on CALCITE-482: The handler was designed to make the copy behav

[jira] [Commented] (CALCITE-3272) TUMBLE Table-valued Function

2020-01-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014278#comment-17014278 ] Danny Chen commented on CALCITE-3272: - I'm preparing to merge the PR soon if there

[jira] [Commented] (CALCITE-482) Implement SQL and planner hints

2020-01-13 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014265#comment-17014265 ] Vladimir Sitnikov commented on CALCITE-482: --- [~danny0405], thanks for the feat

[jira] [Updated] (CALCITE-3730) Add hints to RelBuilder

2020-01-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3730: Labels: pull-request-available (was: ) > Add hints to RelBuilder > -

[jira] [Created] (CALCITE-3730) Add hints to RelBuilder

2020-01-13 Thread Danny Chen (Jira)
Danny Chen created CALCITE-3730: --- Summary: Add hints to RelBuilder Key: CALCITE-3730 URL: https://issues.apache.org/jira/browse/CALCITE-3730 Project: Calcite Issue Type: Sub-task Comp

[jira] [Resolved] (CALCITE-3729) Filters failed to be pushed down when it's identical to join condition.

2020-01-13 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov resolved CALCITE-3729. Fix Version/s: 1.22.0 Resolution: Fixed Merged in https://github.com/apac

[jira] [Updated] (CALCITE-3729) Filters failed to be pushed down when it's identical to join condition.

2020-01-13 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3729: Labels: pull-request-available (was: ) > Filters failed to be pushed down when it's iden

[jira] [Created] (CALCITE-3729) Filters failed to be pushed down when it's identical to join condition.

2020-01-13 Thread Jin Xing (Jira)
Jin Xing created CALCITE-3729: - Summary: Filters failed to be pushed down when it's identical to join condition. Key: CALCITE-3729 URL: https://issues.apache.org/jira/browse/CALCITE-3729 Project: Calcite

[jira] [Commented] (CALCITE-3728) Eliminate the warnings for Gradle build task

2020-01-13 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014102#comment-17014102 ] Vladimir Sitnikov commented on CALCITE-3728: [~danny0405], I agree it would

[jira] [Comment Edited] (CALCITE-3728) Eliminate the warnings for Gradle build task

2020-01-13 Thread Vladimir Sitnikov (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17014102#comment-17014102 ] Vladimir Sitnikov edited comment on CALCITE-3728 at 1/13/20 8:06 AM: