[jira] [Commented] (CALCITE-5518) RelToSql converter generates invalid order of ROLLUP fields

[ https://issues.apache.org/jira/browse/CALCITE-5518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17687541#comment-17687541 ] Jiajun Xie commented on CALCITE-5518: - Here is my understanding of {*}Natural Order{*}: * 2 fileds

[jira] [Assigned] (CALCITE-5518) RelToSql converter generates invalid order of ROLLUP fields

[ https://issues.apache.org/jira/browse/CALCITE-5518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5518: --- Assignee: Jiajun Xie > RelToSql converter generates invalid order of ROLLUP fields >

[jira] [Updated] (CALCITE-5525) GROUPING_ID() should be rewritten to GROUPING() for some dialects in RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-5525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5525: Summary: GROUPING_ID() should be rewritten to GROUPING() for some dialects in RelToSqlConverter

[jira] [Commented] (CALCITE-5525) GROUPING_ID() should be rewritten to GROUPING() in some dialects

[ https://issues.apache.org/jira/browse/CALCITE-5525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17686983#comment-17686983 ] Jiajun Xie commented on CALCITE-5525: - If other databases have the same problem, you can add it to

[jira] [Created] (CALCITE-5525) GROUPING_ID() should be rewritten to GROUPING() in some dialects

Jiajun Xie created CALCITE-5525: --- Summary: GROUPING_ID() should be rewritten to GROUPING() in some dialects Key: CALCITE-5525 URL: https://issues.apache.org/jira/browse/CALCITE-5525 Project: Calcite

[jira] [Commented] (CALCITE-5248) Support Extended Column Aliasing

[ https://issues.apache.org/jira/browse/CALCITE-5248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17683840#comment-17683840 ] Jiajun Xie commented on CALCITE-5248: - [~jhyde] , Is the Jira link right? > Support Extended

[jira] [Commented] (CALCITE-5248) Support Extended Column Aliasing

[ https://issues.apache.org/jira/browse/CALCITE-5248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17683015#comment-17683015 ] Jiajun Xie commented on CALCITE-5248: - I found a Jira ticket in Spark:

[jira] [Commented] (CALCITE-5043) GROUP BY alias or SELECT field should be determined by using sql dialect when alias and field are same

[ https://issues.apache.org/jira/browse/CALCITE-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17683010#comment-17683010 ] Jiajun Xie commented on CALCITE-5043: - [~yanjing.wang] , are you working for it?   Spark also

[jira] [Comment Edited] (CALCITE-5507) HAVING alias failed when aggregate function in condition

[ https://issues.apache.org/jira/browse/CALCITE-5507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17683007#comment-17683007 ] Jiajun Xie edited comment on CALCITE-5507 at 2/1/23 12:43 PM: -- Hi,

[jira] [Commented] (CALCITE-5507) HAVING alias failed when aggregate function in condition

[ https://issues.apache.org/jira/browse/CALCITE-5507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17683007#comment-17683007 ] Jiajun Xie commented on CALCITE-5507: - Hi, [~nobigo] , ^ mean the error position.    In Calcite,

[jira] [Commented] (CALCITE-5416) RelToSql converter generates invalid code when merging rollup and sort clauses

[ https://issues.apache.org/jira/browse/CALCITE-5416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17682565#comment-17682565 ] Jiajun Xie commented on CALCITE-5416: - [~julianhyde] , would you please review it again? Thanks

[jira] [Assigned] (CALCITE-5507) HAVING alias failed when aggregate function in condition

[ https://issues.apache.org/jira/browse/CALCITE-5507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5507: --- Assignee: Jiajun Xie > HAVING alias failed when aggregate function in condition >

[jira] [Updated] (CALCITE-5486) SubQuery not support HAVING alias in where condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Summary: SubQuery not support HAVING alias in where condition (was: SubQuery not support HAVING

[jira] [Updated] (CALCITE-5486) SubQuery not support HAVING alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Summary: SubQuery not support HAVING alias in condition (was: Subquery not support HAVING alias

[jira] [Assigned] (CALCITE-5506) RelToSqlConverter get error result because RelFieldTrimmer lost aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5506: --- Assignee: Jiajun Xie > RelToSqlConverter get error result because RelFieldTrimmer lost

[jira] [Created] (CALCITE-5507) HAVING alias failed when aggregate function in condition

Jiajun Xie created CALCITE-5507: --- Summary: HAVING alias failed when aggregate function in condition Key: CALCITE-5507 URL: https://issues.apache.org/jira/browse/CALCITE-5507 Project: Calcite

[jira] [Assigned] (CALCITE-5486) Subquery not support HAVING alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5486: --- Assignee: Jiajun Xie > Subquery not support HAVING alias in condition >

[jira] [Comment Edited] (CALCITE-5486) Subquery not support HAVING alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681511#comment-17681511 ] Jiajun Xie edited comment on CALCITE-5486 at 1/28/23 9:46 AM: -- Agree with

[jira] [Updated] (CALCITE-5506) RelToSqlConverter get error result because RelFieldTrimmer lost aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-5506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5506: Description: Here is a sql {code:java} select  l.v as l_cost from    (             select  0 as

[jira] [Created] (CALCITE-5506) RelToSqlConverter get error result because RelFieldTrimmer lost aggregate function

Jiajun Xie created CALCITE-5506: --- Summary: RelToSqlConverter get error result because RelFieldTrimmer lost aggregate function Key: CALCITE-5506 URL: https://issues.apache.org/jira/browse/CALCITE-5506

[jira] [Comment Edited] (CALCITE-5486) Subquery not support HAVING alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681511#comment-17681511 ] Jiajun Xie edited comment on CALCITE-5486 at 1/28/23 4:37 AM: -- Agree with

[jira] [Comment Edited] (CALCITE-5486) Subquery not support HAVING alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681511#comment-17681511 ] Jiajun Xie edited comment on CALCITE-5486 at 1/28/23 3:55 AM: -- Agree with

[jira] [Commented] (CALCITE-5486) Subquery not support HAVING alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17681511#comment-17681511 ] Jiajun Xie commented on CALCITE-5486: - Agree with [~julianhyde] , it should apply to sub-queries as

[jira] [Updated] (CALCITE-5486) Subquery not support HAVING alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Summary: Subquery not support HAVING alias in condition (was: Subquery not support having alias

[jira] [Updated] (CALCITE-5486) Subquery not support having alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Description: Spark can allow HAVING alias in condition. We also should allow HAVING alias in

[jira] [Updated] (CALCITE-5486) Subquery not support having alias in condition

[ https://issues.apache.org/jira/browse/CALCITE-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5486: Summary: Subquery not support having alias in condition (was: Subquery not support having alias

[jira] [Created] (CALCITE-5486) Subquery not support having alias in condition.

Jiajun Xie created CALCITE-5486: --- Summary: Subquery not support having alias in condition. Key: CALCITE-5486 URL: https://issues.apache.org/jira/browse/CALCITE-5486 Project: Calcite Issue

[jira] [Commented] (CALCITE-3557) ResultSet.getObject throws ClassCastException when accessing a MULTISET or ARRAY value inside a MULTISET

[ https://issues.apache.org/jira/browse/CALCITE-3557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17677371#comment-17677371 ] Jiajun Xie commented on CALCITE-3557: - [~julianhyde] , thanks for your review patiently.   

[jira] [Commented] (CALCITE-5416) RelToSql converter generates invalid code when merging rollup and sort clauses

[ https://issues.apache.org/jira/browse/CALCITE-5416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17648643#comment-17648643 ] Jiajun Xie commented on CALCITE-5416: - [~julianhyde] , I'm sorry to bother you. Because the ticket

[jira] [Commented] (CALCITE-5416) RelToSql converter generates invalid code when merging rollup and sort clauses

[ https://issues.apache.org/jira/browse/CALCITE-5416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17642949#comment-17642949 ] Jiajun Xie commented on CALCITE-5416: - [~lchistov1987], thank you for your clarification. You are

[jira] [Assigned] (CALCITE-5416) RelToSql converter generates invalid code when merging rollup and sort clauses

[ https://issues.apache.org/jira/browse/CALCITE-5416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5416: --- Assignee: Jiajun Xie > RelToSql converter generates invalid code when merging rollup and

[jira] [Commented] (CALCITE-5416) RelToSql converter generates invalid code when merging rollup and sort clauses

[ https://issues.apache.org/jira/browse/CALCITE-5416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17642795#comment-17642795 ] Jiajun Xie commented on CALCITE-5416: - [~lchistov1987] , maybe it is expected. There are a unit

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17641915#comment-17641915 ] Jiajun Xie commented on CALCITE-5354: - Hello [~libenchao] , Would you please review the PR?

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17641304#comment-17641304 ] Jiajun Xie commented on CALCITE-5354: - Hi [~kramerul], The issue is about {*}UNNEST{*}, but

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17639627#comment-17639627 ] Jiajun Xie commented on CALCITE-5354: - [~kramerul] Thank you for your unit test. I added a new

[jira] [Commented] (CALCITE-5395) RelToSql converter fails when SELECT * is under a semi-join node

[ https://issues.apache.org/jira/browse/CALCITE-5395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17638831#comment-17638831 ] Jiajun Xie commented on CALCITE-5395: - For star, alias replacement is unnecessary. Here is my

[jira] [Assigned] (CALCITE-5395) RelToSql converter fails when SELECT * is under a semi-join node

[ https://issues.apache.org/jira/browse/CALCITE-5395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5395: --- Assignee: Jiajun Xie > RelToSql converter fails when SELECT * is under a semi-join node >

[jira] [Commented] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

[ https://issues.apache.org/jira/browse/CALCITE-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17638824#comment-17638824 ] Jiajun Xie commented on CALCITE-5394: - Only add neededAlias for SemiJoin SqlNode to fix it, here is

[jira] [Assigned] (CALCITE-5394) RelToSql converter fails when semi-join is under a join node

[ https://issues.apache.org/jira/browse/CALCITE-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5394: --- Assignee: Jiajun Xie > RelToSql converter fails when semi-join is under a join node >

[jira] [Commented] (CALCITE-5377) RelFieldTrimmer support Sort with dynamic param

[ https://issues.apache.org/jira/browse/CALCITE-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17637780#comment-17637780 ] Jiajun Xie commented on CALCITE-5377: - Hi, [~rubenql].  I believe you are familiar with the

[jira] [Commented] (CALCITE-4611) Ambiguous column exception occurred when a table function has same column name in its input and output column list

[ https://issues.apache.org/jira/browse/CALCITE-4611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636272#comment-17636272 ] Jiajun Xie commented on CALCITE-4611: - - For the JoinScope   {code:java} Left:

[jira] [Commented] (CALCITE-5392) Support Snapshot in RelMdExpressionLineage

[ https://issues.apache.org/jira/browse/CALCITE-5392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17636267#comment-17636267 ] Jiajun Xie commented on CALCITE-5392: - Here is PR:https://github.com/apache/calcite/pull/2976 >

[jira] [Created] (CALCITE-5392) Support Snapshot in RelMdExpressionLineage

Jiajun Xie created CALCITE-5392: --- Summary: Support Snapshot in RelMdExpressionLineage Key: CALCITE-5392 URL: https://issues.apache.org/jira/browse/CALCITE-5392 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-5141) Incomplete implicit type conversion for insert values

[ https://issues.apache.org/jira/browse/CALCITE-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17635825#comment-17635825 ] Jiajun Xie commented on CALCITE-5141: - Would anyone review it? It was mentioned again in

[jira] [Comment Edited] (CALCITE-5382) Values are not casted to correct type in insertion

[ https://issues.apache.org/jira/browse/CALCITE-5382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17635761#comment-17635761 ] Jiajun Xie edited comment on CALCITE-5382 at 11/18/22 9:43 AM: ---

[jira] [Commented] (CALCITE-5382) Values are not casted to correct type in insertion

[ https://issues.apache.org/jira/browse/CALCITE-5382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17635761#comment-17635761 ] Jiajun Xie commented on CALCITE-5382: - I mock your table {code:java} final MockTable t3 =

[jira] [Comment Edited] (CALCITE-5382) Values are not casted to correct type in insertion

[ https://issues.apache.org/jira/browse/CALCITE-5382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633671#comment-17633671 ] Jiajun Xie edited comment on CALCITE-5382 at 11/14/22 10:39 AM: Is this

[jira] [Comment Edited] (CALCITE-5382) Values are not casted to correct type in insertion

[ https://issues.apache.org/jira/browse/CALCITE-5382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633671#comment-17633671 ] Jiajun Xie edited comment on CALCITE-5382 at 11/14/22 10:39 AM: Is this

[jira] [Commented] (CALCITE-5382) Values are not casted to correct type in insertion

[ https://issues.apache.org/jira/browse/CALCITE-5382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633671#comment-17633671 ] Jiajun Xie commented on CALCITE-5382: - Is this a duplicate of CALCITE-5141? > Values are not

[jira] [Comment Edited] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633236#comment-17633236 ] Jiajun Xie edited comment on CALCITE-5354 at 11/13/22 8:52 AM: ---

[jira] [Assigned] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5354: --- Assignee: Jiajun Xie > JDBC with UNNEST not working > > >

[jira] [Comment Edited] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633236#comment-17633236 ] Jiajun Xie edited comment on CALCITE-5354 at 11/13/22 8:50 AM: ---

[jira] [Commented] (CALCITE-5354) JDBC with UNNEST not working

[ https://issues.apache.org/jira/browse/CALCITE-5354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633236#comment-17633236 ] Jiajun Xie commented on CALCITE-5354: - [~kramerul] , sorry I missed your message. I fixed it in

[jira] [Commented] (CALCITE-5377) RelFieldTrimmer support Sort with dynamic param

[ https://issues.apache.org/jira/browse/CALCITE-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17633222#comment-17633222 ] Jiajun Xie commented on CALCITE-5377: - Good catch! Because fetch and offset must be integer for

[jira] [Assigned] (CALCITE-5377) RelFieldTrimmer support Sort with dynamic param

[ https://issues.apache.org/jira/browse/CALCITE-5377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5377: --- Assignee: Jiajun Xie > RelFieldTrimmer support Sort with dynamic param >

[jira] [Comment Edited] (CALCITE-4455) Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17632672#comment-17632672 ] Jiajun Xie edited comment on CALCITE-4455 at 11/12/22 1:15 PM: --- I used

[jira] [Commented] (CALCITE-4455) Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17632672#comment-17632672 ] Jiajun Xie commented on CALCITE-4455: - I used `SqlKind.OTHER_DML` to validate INSERT OVERWRITE and

[jira] [Updated] (CALCITE-5376) Support Spark’s FIRST and LAST functions

[ https://issues.apache.org/jira/browse/CALCITE-5376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5376: Description: Following on from the mailing list thread -

[jira] [Updated] (CALCITE-5376) Support Spark’s FIRST and LAST functions

[ https://issues.apache.org/jira/browse/CALCITE-5376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5376: Description: # Following on from the mailing list thread -

[jira] [Comment Edited] (CALCITE-4455) Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17629426#comment-17629426 ] Jiajun Xie edited comment on CALCITE-4455 at 11/6/22 7:34 AM: --

[jira] [Commented] (CALCITE-4455) Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17629426#comment-17629426 ] Jiajun Xie commented on CALCITE-4455: - "SqlOverwriteTable" maybe better than

[jira] [Commented] (CALCITE-3588) JDBC adapter should handle join conditions containing IS TRUE, SIMILAR TO etc. when generating SQL

[ https://issues.apache.org/jira/browse/CALCITE-3588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626583#comment-17626583 ] Jiajun Xie commented on CALCITE-3588: - [~julianhyde] , I found that your

[jira] [Closed] (CALCITE-3588) JDBC adapter should handle join conditions containing IS TRUE, SIMILAR TO etc. when generating SQL

[ https://issues.apache.org/jira/browse/CALCITE-3588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie closed CALCITE-3588. --- Fix Version/s: 1.27.0 Resolution: Fixed > JDBC adapter should handle join conditions

[jira] [Commented] (CALCITE-4804) Support Snapshot operator serialization and deserizalization

[ https://issues.apache.org/jira/browse/CALCITE-4804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626184#comment-17626184 ] Jiajun Xie commented on CALCITE-4804: - PR is ready for review:

[jira] [Assigned] (CALCITE-4804) Support Snapshot operator serialization and deserizalization

[ https://issues.apache.org/jira/browse/CALCITE-4804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-4804: --- Assignee: Jiajun Xie > Support Snapshot operator serialization and deserizalization >

[jira] [Commented] (CALCITE-4455) Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17626029#comment-17626029 ] Jiajun Xie commented on CALCITE-4455: - Sorry, I only write code on weekends, so the reply was late.

[jira] [Updated] (CALCITE-4455) Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-4455: Summary: Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement (was: Calcite

[jira] [Updated] (CALCITE-4455) Calcite SQLParser: Provide support for INSERT OVERWRITE

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-4455: Description: Spark has [INSERT OVERWRITE TABLE

[jira] [Updated] (CALCITE-4455) Calcite SQLParser: Provide support for INSERT OVERWRITE

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-4455: Description: Spark has [INSERT OVERWRITE TABLE

[jira] [Updated] (CALCITE-4455) Calcite SQLParser: Provide support for INSERT OVERWRITE

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-4455: Description: Spark has [INSERT OVERWRITE TABLE

[jira] [Comment Edited] (CALCITE-3332) Query failed with AssertionError: cannot cast null as class java.math.BigDecimal

[ https://issues.apache.org/jira/browse/CALCITE-3332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17625636#comment-17625636 ] Jiajun Xie edited comment on CALCITE-3332 at 10/28/22 11:43 AM: The

[jira] [Closed] (CALCITE-3332) Query failed with AssertionError: cannot cast null as class java.math.BigDecimal

[ https://issues.apache.org/jira/browse/CALCITE-3332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie closed CALCITE-3332. --- Resolution: Fixed > Query failed with AssertionError: cannot cast null as class >

[jira] [Reopened] (CALCITE-3332) Query failed with AssertionError: cannot cast null as class java.math.BigDecimal

[ https://issues.apache.org/jira/browse/CALCITE-3332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reopened CALCITE-3332: - > Query failed with AssertionError: cannot cast null as class > java.math.BigDecimal >

[jira] [Comment Edited] (CALCITE-3332) Query failed with AssertionError: cannot cast null as class java.math.BigDecimal

[ https://issues.apache.org/jira/browse/CALCITE-3332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17625636#comment-17625636 ] Jiajun Xie edited comment on CALCITE-3332 at 10/28/22 11:42 AM: The

[jira] [Closed] (CALCITE-3332) Query failed with AssertionError: cannot cast null as class java.math.BigDecimal

[ https://issues.apache.org/jira/browse/CALCITE-3332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie closed CALCITE-3332. --- Fix Version/s: 1.26.0 Resolution: Fixed > Query failed with AssertionError: cannot cast

[jira] [Commented] (CALCITE-3332) Query failed with AssertionError: cannot cast null as class java.math.BigDecimal

[ https://issues.apache.org/jira/browse/CALCITE-3332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17625636#comment-17625636 ] Jiajun Xie commented on CALCITE-3332: - The issue has been fixed in

[jira] [Closed] (CALCITE-1518) Converting SELECT table.nested.field FROM (...) to RelNode throws ArrayIndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/CALCITE-1518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie closed CALCITE-1518. --- Resolution: Fixed > Converting SELECT table.nested.field FROM (...) to RelNode throws >

[jira] [Updated] (CALCITE-1518) Converting SELECT table.nested.field FROM (...) to RelNode throws ArrayIndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/CALCITE-1518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-1518: Fix Version/s: 1.25.0 > Converting SELECT table.nested.field FROM (...) to RelNode throws >

[jira] [Commented] (CALCITE-1518) Converting SELECT table.nested.field FROM (...) to RelNode throws ArrayIndexOutOfBoundsException

[ https://issues.apache.org/jira/browse/CALCITE-1518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17624853#comment-17624853 ] Jiajun Xie commented on CALCITE-1518: - The issue has been fixed in

[jira] [Commented] (CALCITE-5343) Type of division operator

[ https://issues.apache.org/jira/browse/CALCITE-5343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17623572#comment-17623572 ] Jiajun Xie commented on CALCITE-5343: - [~mbudiu], There some divide operator unit test in

[jira] [Commented] (CALCITE-4455) Calcite SQLParser: Provide support for INSERT OVERWRITE

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17622739#comment-17622739 ] Jiajun Xie commented on CALCITE-4455: - I implemented Spark syntax[1] as much as possible. Welcome

[jira] [Assigned] (CALCITE-4455) Calcite SQLParser: Provide support for INSERT OVERWRITE

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-4455: --- Assignee: Jiajun Xie > Calcite SQLParser: Provide support for INSERT OVERWRITE >

[jira] [Commented] (CALCITE-4455) Calcite SQLParser: Provide support for INSERT OVERWRITE

[ https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17622591#comment-17622591 ] Jiajun Xie commented on CALCITE-4455: - [~sambekar], Are you still working on it? I'm ready to

[jira] [Comment Edited] (CALCITE-5333) Query with "WITH" clause is failing after calcite upgrade

[ https://issues.apache.org/jira/browse/CALCITE-5333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17618200#comment-17618200 ] Jiajun Xie edited comment on CALCITE-5333 at 10/16/22 4:48 AM: --- Of

[jira] [Commented] (CALCITE-5333) Query with "WITH" clause is failing after calcite upgrade

[ https://issues.apache.org/jira/browse/CALCITE-5333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17618200#comment-17618200 ] Jiajun Xie commented on CALCITE-5333: - Of course, I add a 'related' link. > Query with "WITH"

[jira] [Comment Edited] (CALCITE-5333) Query with "WITH" clause is failing after calcite upgrade

[ https://issues.apache.org/jira/browse/CALCITE-5333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17617490#comment-17617490 ] Jiajun Xie edited comment on CALCITE-5333 at 10/16/22 4:42 AM: --- The error

[jira] [Comment Edited] (CALCITE-5333) Query with "WITH" clause is failing after calcite upgrade

[ https://issues.apache.org/jira/browse/CALCITE-5333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17617490#comment-17617490 ] Jiajun Xie edited comment on CALCITE-5333 at 10/16/22 4:41 AM: --- The error

[jira] [Commented] (CALCITE-5333) Query with "WITH" clause is failing after calcite upgrade

[ https://issues.apache.org/jira/browse/CALCITE-5333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17617490#comment-17617490 ] Jiajun Xie commented on CALCITE-5333: - The error from

[jira] [Comment Edited] (CALCITE-5326) SqlMerge generate extra bracket on toSqlString

[ https://issues.apache.org/jira/browse/CALCITE-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17616373#comment-17616373 ] Jiajun Xie edited comment on CALCITE-5326 at 10/12/22 11:48 AM:

[jira] [Commented] (CALCITE-5326) SqlMerge generate extra bracket on toSqlString

[ https://issues.apache.org/jira/browse/CALCITE-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17616373#comment-17616373 ] Jiajun Xie commented on CALCITE-5326: - [~clesaec] , there are some guidelines for commit

[jira] [Commented] (CALCITE-5326) SqlMerge generate extra bracket on toSqlString

[ https://issues.apache.org/jira/browse/CALCITE-5326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17615804#comment-17615804 ] Jiajun Xie commented on CALCITE-5326: - Brackets will be added if `operator.getRightPrec() <=

[jira] [Commented] (CALCITE-5307) Quoting of functions interferes with MySQL execution

[ https://issues.apache.org/jira/browse/CALCITE-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17614052#comment-17614052 ] Jiajun Xie commented on CALCITE-5307: - Not all function names will be quoted, there some

[jira] [Commented] (CALCITE-5304) RelJson should support RexSubQuery

[ https://issues.apache.org/jira/browse/CALCITE-5304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17611406#comment-17611406 ] Jiajun Xie commented on CALCITE-5304: - +1 for this ticket. Here is a relNode that contains

[jira] [Comment Edited] (CALCITE-5304) RelJson should support RexSubQuery

[ https://issues.apache.org/jira/browse/CALCITE-5304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17611406#comment-17611406 ] Jiajun Xie edited comment on CALCITE-5304 at 9/30/22 7:25 AM: -- +1 for this

[jira] [Commented] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17611027#comment-17611027 ] Jiajun Xie commented on CALCITE-5286: - Here is new PR to solve them:

[jira] [Assigned] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5286: --- Assignee: Jiajun Xie > Join with parameterized LIMIT throws AssertionError "not a

[jira] [Commented] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17608956#comment-17608956 ] Jiajun Xie commented on CALCITE-5286: - [~kramerul] , I can't reproduce your problem in this unit

[jira] [Commented] (CALCITE-5292) Add a policy that can prevent SQL statements from running if they contain certain functions / operators

[ https://issues.apache.org/jira/browse/CALCITE-5292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17607453#comment-17607453 ] Jiajun Xie commented on CALCITE-5292: - +1,  I already have  a policy that can prevent SQL

[jira] [Comment Edited] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17606223#comment-17606223 ] Jiajun Xie edited comment on CALCITE-5286 at 9/18/22 1:46 AM: -- [~kramerul]

[jira] [Comment Edited] (CALCITE-5286) Join with parameterized LIMIT throws AssertionError "not a literal"

[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17606223#comment-17606223 ] Jiajun Xie edited comment on CALCITE-5286 at 9/18/22 1:44 AM: -- [~kramerul]

<    1   2   3   4   5   6   >