[jira] [Resolved] (CALCITE-5826) Add FIND_IN_SET function (enabled in Hive and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5826?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5826. - Resolution: Fixed > Add FIND_IN_SET function (enabled in Hive and Spark library) >

[jira] [Commented] (CALCITE-5826) Add FIND_IN_SET function (enabled in Hive and Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5826?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17781596#comment-17781596 ] Jiajun Xie commented on CALCITE-5826: - Fixed in

[jira] [Resolved] (CALCITE-6037) The function category of ARRAY/EXTRACT_VALUE/XML_TRANSFORM/EXTRACT_XML/EXISTSNODE is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6037. - Resolution: Fixed > The function category of >

[jira] [Commented] (CALCITE-6037) The function category of ARRAY/EXTRACT_VALUE/XML_TRANSFORM/EXTRACT_XML/EXISTSNODE is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-6037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17780786#comment-17780786 ] Jiajun Xie commented on CALCITE-6037: - Fixed in

[jira] [Resolved] (CALCITE-5825) Add URL_ENCODE and URL_DECODE function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5825?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5825. - Resolution: Fixed > Add URL_ENCODE and URL_DECODE function (enabled in Spark library) >

[jira] [Commented] (CALCITE-5825) Add URL_ENCODE and URL_DECODE function (enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17780310#comment-17780310 ] Jiajun Xie commented on CALCITE-5825: - Fixed in

[jira] [Commented] (CALCITE-6038) Remove 'ORDER BY ... LIMIT n' when input has at most one row, n >= 1, and there is no 'OFFSET' clause

[ https://issues.apache.org/jira/browse/CALCITE-6038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17778896#comment-17778896 ] Jiajun Xie commented on CALCITE-6038: - Sorry, [~shenlang]  I've been too busy lately to review

[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: Fix Version/s: 1.36.0 > Babel parser support Spark INSERT OVERWRITE TABLE/DIRECTORY statement >

[jira] [Resolved] (CALCITE-6022) Support "CREATE TABLE ... LIKE" DDL in server module

[ https://issues.apache.org/jira/browse/CALCITE-6022?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6022. - Resolution: Fixed > Support "CREATE TABLE ... LIKE" DDL in server module >

[jira] [Commented] (CALCITE-6022) Support "CREATE TABLE ... LIKE" DDL in server module

[ https://issues.apache.org/jira/browse/CALCITE-6022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17776968#comment-17776968 ] Jiajun Xie commented on CALCITE-6022: - Fixed in

[jira] [Commented] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17775190#comment-17775190 ] Jiajun Xie commented on CALCITE-5570: - [~MasseGuillaume] , Thank you for your notification. Would

[jira] [Commented] (CALCITE-6049) Exception when using division with dynamic param

[ https://issues.apache.org/jira/browse/CALCITE-6049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17774885#comment-17774885 ] Jiajun Xie commented on CALCITE-6049: - - Before 1.22, here is the validate SqlNode for 

[jira] [Resolved] (CALCITE-6006) RelToSqlConverter loses charset information

[ https://issues.apache.org/jira/browse/CALCITE-6006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6006. - Resolution: Fixed > RelToSqlConverter loses charset information >

[jira] [Commented] (CALCITE-6006) RelToSqlConverter loses charset information

[ https://issues.apache.org/jira/browse/CALCITE-6006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17774757#comment-17774757 ] Jiajun Xie commented on CALCITE-6006: - Fixed in

[jira] [Resolved] (CALCITE-6009) Add optimization to remove redundant LIMIT that is more than input row count

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-6009. - Resolution: Fixed > Add optimization to remove redundant LIMIT that is more than input row

[jira] [Comment Edited] (CALCITE-6009) Add optimization to remove redundant LIMIT that is more than input row count

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17771377#comment-17771377 ] Jiajun Xie edited comment on CALCITE-6009 at 10/3/23 8:25 AM: -- Fixed in

[jira] [Commented] (CALCITE-6009) Add optimization to remove redundant LIMIT that is more than input row count

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17771377#comment-17771377 ] Jiajun Xie commented on CALCITE-6009: - Fixed in

[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=17770990#comment-17770990 ] Jiajun Xie commented on CALCITE-4455: - Would anyone review it?

[jira] [Commented] (CALCITE-6022) Support "CREATE TABLE ... LIKE" DDL

[ https://issues.apache.org/jira/browse/CALCITE-6022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770985#comment-17770985 ] Jiajun Xie commented on CALCITE-6022: - Should we add `server module` in Jira summary? e.g. Support

[jira] [Commented] (CALCITE-6009) Add optimization to remove redundant Limit when its input's row number is less or equal to Limit's fetch

[ https://issues.apache.org/jira/browse/CALCITE-6009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770829#comment-17770829 ] Jiajun Xie commented on CALCITE-6009: - The PR looks good to me. Just a small suggestion: `Add

[jira] [Resolved] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5570. - Fix Version/s: 1.36.0 Resolution: Fixed > Support nested map type for SqlDataTypeSpec >

[jira] [Commented] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770817#comment-17770817 ] Jiajun Xie commented on CALCITE-5570: - Fixed in

[jira] [Commented] (CALCITE-5962) Support parse Spark-style syntax "LEFT ANTI JOIN" in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17770006#comment-17770006 ] Jiajun Xie commented on CALCITE-5962: - Fixed in

[jira] [Resolved] (CALCITE-5962) Support parse Spark-style syntax "LEFT ANTI JOIN" in Babel parser

[ https://issues.apache.org/jira/browse/CALCITE-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5962. - Resolution: Fixed > Support parse Spark-style syntax "LEFT ANTI JOIN" in Babel parser >

[jira] [Commented] (CALCITE-5940) Add the Rule to merge Limit

[ https://issues.apache.org/jira/browse/CALCITE-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17769535#comment-17769535 ] Jiajun Xie commented on CALCITE-5940: - Fixed in

[jira] [Resolved] (CALCITE-5940) Add the Rule to merge Limit

[ https://issues.apache.org/jira/browse/CALCITE-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5940. - Resolution: Fixed > Add the Rule to merge Limit > --- > >

[jira] [Commented] (CALCITE-5940) Add the Rule to optimize Limit

[ https://issues.apache.org/jira/browse/CALCITE-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17769394#comment-17769394 ] Jiajun Xie commented on CALCITE-5940: - I will merge the PR, but I think that we can use a more

[jira] [Resolved] (CALCITE-5997) OFFSET operator is incorrectly unparsed

[ https://issues.apache.org/jira/browse/CALCITE-5997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5997. - Fix Version/s: 1.36.0 Assignee: Mihai Budiu Resolution: Fixed > OFFSET

[jira] [Commented] (CALCITE-5997) OFFSET operator is incorrectly unparsed

[ https://issues.apache.org/jira/browse/CALCITE-5997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766961#comment-17766961 ] Jiajun Xie commented on CALCITE-5997: - Fixed in

[jira] [Commented] (CALCITE-5999) DECIMAL literals are sometimes unparsed looking as DOUBLE literals

[ https://issues.apache.org/jira/browse/CALCITE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766621#comment-17766621 ] Jiajun Xie commented on CALCITE-5999: - Fixed in

[jira] [Resolved] (CALCITE-5999) DECIMAL literals are sometimes unparsed looking as DOUBLE literals

[ https://issues.apache.org/jira/browse/CALCITE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5999. - Fix Version/s: 1.36.0 Assignee: Mihai Budiu Resolution: Fixed > DECIMAL

[jira] [Comment Edited] (CALCITE-5523) RelToSql converter generates GROUP BY clause with window expression

[ https://issues.apache.org/jira/browse/CALCITE-5523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766053#comment-17766053 ] Jiajun Xie edited comment on CALCITE-5523 at 9/17/23 8:14 AM: --

[jira] [Commented] (CALCITE-5523) RelToSql converter generates GROUP BY clause with window expression

[ https://issues.apache.org/jira/browse/CALCITE-5523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17766053#comment-17766053 ] Jiajun Xie commented on CALCITE-5523: - [~lchistov1987] , Oracle support it.   {code:java} //

[jira] [Comment Edited] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765921#comment-17765921 ] Jiajun Xie edited comment on CALCITE-6007 at 9/16/23 7:51 AM: --

[jira] [Commented] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765921#comment-17765921 ] Jiajun Xie commented on CALCITE-6007: - [~wenruimeng] , Maybe `CTE` or `With  clause` will be better

[jira] [Comment Edited] (CALCITE-6007) Sqlwith as subquery without alias doesn't have correct alias setup

[ https://issues.apache.org/jira/browse/CALCITE-6007?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765921#comment-17765921 ] Jiajun Xie edited comment on CALCITE-6007 at 9/16/23 7:50 AM: --

[jira] [Commented] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765897#comment-17765897 ] Jiajun Xie commented on CALCITE-5570: - [~Sergey Nuyanzin] , Do you have any suggestions? I plan to

[jira] [Resolved] (CALCITE-5836) Implement Rel2Sql for MERGE

[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5836. - Fix Version/s: 1.36.0 Resolution: Fixed > Implement Rel2Sql for MERGE >

[jira] [Commented] (CALCITE-5836) Implement Rel2Sql for MERGE

[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17765417#comment-17765417 ] Jiajun Xie commented on CALCITE-5836: - Fixed in

[jira] [Comment Edited] (CALCITE-5985) FilterTableFunctionTransposeRule should not use "Logical" RelNodes

[ https://issues.apache.org/jira/browse/CALCITE-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763397#comment-17763397 ] Jiajun Xie edited comment on CALCITE-5985 at 9/10/23 7:12 AM: -- I can't

[jira] [Comment Edited] (CALCITE-5985) FilterTableFunctionTransposeRule should not use "Logical" RelNodes

[ https://issues.apache.org/jira/browse/CALCITE-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763397#comment-17763397 ] Jiajun Xie edited comment on CALCITE-5985 at 9/10/23 7:10 AM: -- I can't

[jira] [Commented] (CALCITE-5985) FilterTableFunctionTransposeRule should not use "Logical" RelNodes

[ https://issues.apache.org/jira/browse/CALCITE-5985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763397#comment-17763397 ] Jiajun Xie commented on CALCITE-5985: - I can't find any unit tests for

[jira] [Resolved] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5931. - Resolution: Fixed > Allow integers like 1.00 in window frame >

[jira] [Commented] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763395#comment-17763395 ] Jiajun Xie commented on CALCITE-5931: - Fixed in

[jira] [Commented] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763309#comment-17763309 ] Jiajun Xie commented on CALCITE-5931: - [~cbrisson] , Your PR is already dirty because force-pushed

[jira] [Commented] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17762924#comment-17762924 ] Jiajun Xie commented on CALCITE-5944: - Fixed in

[jira] [Resolved] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5944. - Fix Version/s: 1.36.0 Resolution: Fixed > Add metadata for Sample >

[jira] [Commented] (CALCITE-5931) Allow integers like 1.00 in window frame

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17760668#comment-17760668 ] Jiajun Xie commented on CALCITE-5931: - [~cbrisson] , You can add a test to `winagg.iq`. e.g.

[jira] [Commented] (CALCITE-5836) Implement Rel2Sql for MERGE

[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759415#comment-17759415 ] Jiajun Xie commented on CALCITE-5836: - [~hongyuguo] , you can refer to

[jira] [Updated] (CALCITE-5836) Implement Rel2Sql for MERGE

[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5836: Attachment: image-2023-08-28-10-28-57-584.png > Implement Rel2Sql for MERGE >

[jira] [Commented] (CALCITE-5836) Implement Rel2Sql for MERGE

[ https://issues.apache.org/jira/browse/CALCITE-5836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759412#comment-17759412 ] Jiajun Xie commented on CALCITE-5836: - [~hongyuguo] , I noticed that you used a lot of his code.

[jira] [Comment Edited] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759235#comment-17759235 ] Jiajun Xie edited comment on CALCITE-5944 at 8/26/23 10:34 AM: --- Would

[jira] [Commented] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759235#comment-17759235 ] Jiajun Xie commented on CALCITE-5944: - Would anyone please  review it?     > Add metadata for

[jira] [Commented] (CALCITE-5956) Support parsing non-standard collection types

[ https://issues.apache.org/jira/browse/CALCITE-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759231#comment-17759231 ] Jiajun Xie commented on CALCITE-5956: - IMO: The core module supports too many parsing methods,

[jira] [Commented] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL

[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17759009#comment-17759009 ] Jiajun Xie commented on CALCITE-5922: - Fixed in

[jira] [Resolved] (CALCITE-5922) The SQL generated for the POSITION function(with 3 input arguments) by the SparkSqlDialect is not recognized by Spark SQL

[ https://issues.apache.org/jira/browse/CALCITE-5922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5922. - Resolution: Fixed > The SQL generated for the POSITION function(with 3 input arguments) by the

[jira] [Commented] (CALCITE-5954) Support MERGE in RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17758836#comment-17758836 ] Jiajun Xie commented on CALCITE-5954: - [~hongyuguo] ，Thanks for you create JIRA. I mark it as

[jira] [Resolved] (CALCITE-5954) Support MERGE in RelToSqlConverter

[ https://issues.apache.org/jira/browse/CALCITE-5954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5954. - Fix Version/s: (was: 1.36.0) Resolution: Duplicate > Support MERGE in

[jira] [Updated] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5944: Description: For the sql {code:java} select * from emp tablesample system(20) {code}

[jira] [Commented] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17757171#comment-17757171 ] Jiajun Xie commented on CALCITE-5944: - Initially, I planned to discuss separately, so I create

[jira] [Updated] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5944: Description: For the sql {code:java} select * from emp tablesample system(20) {code}

[jira] [Closed] (CALCITE-5943) RelMdSelectivity can return more precise selectivity for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie closed CALCITE-5943. --- Resolution: Duplicate > RelMdSelectivity can return more precise selectivity for Sample >

[jira] [Updated] (CALCITE-5944) Add metadata for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5944: Description: For the sql {code:java} select * from emp tablesample system(20) {code}

[jira] [Commented] (CALCITE-5943) RelMdSelectivity can return more precise selectivity for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756686#comment-17756686 ] Jiajun Xie commented on CALCITE-5943: - [~libenchao]  No, this is discussion about `Selectivity`.  

[jira] [Updated] (CALCITE-5944) RelMdRowCount can return more accurate rowCount for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5944: Summary: RelMdRowCount can return more accurate rowCount for Sample (was: RelMdRowCount can

[jira] [Updated] (CALCITE-5944) RelMdRowCount can return more accurate rowCount

[ https://issues.apache.org/jira/browse/CALCITE-5944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5944: Description: For the sql {code:java} select * from emp tablesample system(20) {code}

[jira] [Created] (CALCITE-5944) RelMdRowCount can return more accurate rowCount

Jiajun Xie created CALCITE-5944: --- Summary: RelMdRowCount can return more accurate rowCount Key: CALCITE-5944 URL: https://issues.apache.org/jira/browse/CALCITE-5944 Project: Calcite Issue

[jira] [Commented] (CALCITE-5943) RelMdSelectivity can return more precise selectivity for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756466#comment-17756466 ] Jiajun Xie commented on CALCITE-5943: - Selectivity is for predicate, maybe it is not suitable for

[jira] [Updated] (CALCITE-5943) RelMdSelectivity can return more precise selectivity for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5943: Issue Type: Improvement (was: Bug) Priority: Minor (was: Major) > RelMdSelectivity can

[jira] [Updated] (CALCITE-5943) RelMdSelectivity can return more precise selectivity for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5943: Description: For the SQL ``` select * from emp tablesample bernoulli(50) ``` selectivity is

[jira] [Updated] (CALCITE-5943) RelMdSelectivity can return more precise selectivity for Sample

[ https://issues.apache.org/jira/browse/CALCITE-5943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie updated CALCITE-5943: Description: For the SQL {code:java} select * from emp tablesample bernoulli(50) {code}

[jira] [Created] (CALCITE-5943) RelMdSelectivity can return more precise selectivity for Sample

Jiajun Xie created CALCITE-5943: --- Summary: RelMdSelectivity can return more precise selectivity for Sample Key: CALCITE-5943 URL: https://issues.apache.org/jira/browse/CALCITE-5943 Project: Calcite

[jira] [Resolved] (CALCITE-985) Validate MERGE

[ https://issues.apache.org/jira/browse/CALCITE-985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-985. Resolution: Fixed > Validate MERGE > -- > > Key: CALCITE-985 >

[jira] [Commented] (CALCITE-985) Validate MERGE

[ https://issues.apache.org/jira/browse/CALCITE-985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756459#comment-17756459 ] Jiajun Xie commented on CALCITE-985: Fixed in

[jira] [Commented] (CALCITE-5937) The parsing error should not be thrown even if there is no Hint in Hint Statement

[ https://issues.apache.org/jira/browse/CALCITE-5937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756454#comment-17756454 ] Jiajun Xie commented on CALCITE-5937: - [~shenlang], You didn't answer my question.   I think JIRA

[jira] [Commented] (CALCITE-5937) The parsing error should not be thrown even if there is no Hint in Hint Statement

[ https://issues.apache.org/jira/browse/CALCITE-5937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756257#comment-17756257 ] Jiajun Xie commented on CALCITE-5937: - [~shenlang],  `no Hint` maybe strange. WDYT? `if there is

[jira] [Commented] (CALCITE-5583) JDBC adapter generates 'SELECT *', which is invalid SQL if there are duplicate column names

[ https://issues.apache.org/jira/browse/CALCITE-5583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756255#comment-17756255 ] Jiajun Xie commented on CALCITE-5583: - [~leepb] , Thank you for your PR.   I have left some

[jira] [Commented] (CALCITE-5931) Fix integral number detection

[ https://issues.apache.org/jira/browse/CALCITE-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756248#comment-17756248 ] Jiajun Xie commented on CALCITE-5931: - [~cbrisson] Thank you for your commit, but we can do even

[jira] [Commented] (CALCITE-5870) Allow literals like DECIMAL '12.3' (consistent with Postgres)

[ https://issues.apache.org/jira/browse/CALCITE-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17756225#comment-17756225 ] Jiajun Xie commented on CALCITE-5870: - Fixed in

[jira] [Resolved] (CALCITE-5870) Allow literals like DECIMAL '12.3' (consistent with Postgres)

[ https://issues.apache.org/jira/browse/CALCITE-5870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5870. - Resolution: Fixed > Allow literals like DECIMAL '12.3' (consistent with Postgres) >

[jira] [Resolved] (CALCITE-5906) JDBC adapter should generate TABLESAMPLE

[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5906. - Resolution: Fixed > JDBC adapter should generate TABLESAMPLE >

[jira] [Commented] (CALCITE-5906) JDBC adapter should generate TABLESAMPLE

[ https://issues.apache.org/jira/browse/CALCITE-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754828#comment-17754828 ] Jiajun Xie commented on CALCITE-5906: - Fixed via

[jira] [Commented] (CALCITE-5830) Add ARRAY_INSERT function(enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17754363#comment-17754363 ] Jiajun Xie commented on CALCITE-5830: - [~taoran] , I got it. Thank you for your detailed

[jira] [Commented] (CALCITE-5830) Add ARRAY_INSERT function(enabled in Spark library)

[ https://issues.apache.org/jira/browse/CALCITE-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17753673#comment-17753673 ] Jiajun Xie commented on CALCITE-5830: - [~taoran] , ARRAY_INSERT is a function only available in the

[jira] [Commented] (CALCITE-5813) Type inference for sql functions REPEAT, SPACE, XML_TRANSFORM, and XML_EXTRACT is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17753481#comment-17753481 ] Jiajun Xie commented on CALCITE-5813: - Fixed in

[jira] [Resolved] (CALCITE-5813) Type inference for sql functions REPEAT, SPACE, XML_TRANSFORM, and XML_EXTRACT is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5813. - Resolution: Fixed > Type inference for sql functions REPEAT, SPACE, XML_TRANSFORM, and >

[jira] [Resolved] (CALCITE-5885) SqlNode#toSqlString() does not honor dialect's supportsCharSet() flag on nested types

[ https://issues.apache.org/jira/browse/CALCITE-5885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5885. - Fix Version/s: 1.36.0 Resolution: Fixed > SqlNode#toSqlString() does not honor

[jira] [Commented] (CALCITE-5885) SqlNode#toSqlString() does not honor dialect's supportsCharSet() flag on nested types

[ https://issues.apache.org/jira/browse/CALCITE-5885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17753012#comment-17753012 ] Jiajun Xie commented on CALCITE-5885: - Fixed in

[jira] [Commented] (CALCITE-5904) The result should be empty list when table sample rate is 0

[ https://issues.apache.org/jira/browse/CALCITE-5904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17752264#comment-17752264 ] Jiajun Xie commented on CALCITE-5904: - You closed it, do you plan to create new PR? > The result

[jira] [Commented] (CALCITE-5885) SqlNode#toSqlString() does not honor dialect's supportsCharSet() flag on nested types

[ https://issues.apache.org/jira/browse/CALCITE-5885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17751368#comment-17751368 ] Jiajun Xie commented on CALCITE-5885: - Hi, [~chrisrice]  I fixed it, welcome to review it:

[jira] [Assigned] (CALCITE-5885) SqlNode#toSqlString() does not honor dialect's supportsCharSet() flag on nested types

[ https://issues.apache.org/jira/browse/CALCITE-5885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie reassigned CALCITE-5885: --- Assignee: Jiajun Xie > SqlNode#toSqlString() does not honor dialect's supportsCharSet()

[jira] [Commented] (CALCITE-5813) Type inference for REPEAT sql function is incorrect

[ https://issues.apache.org/jira/browse/CALCITE-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17750926#comment-17750926 ] Jiajun Xie commented on CALCITE-5813: - Hi, [~mbudiu]. The PR looks good, you also fixed SPACE,

[jira] [Commented] (CALCITE-3697) Implement BITCOUNT scalar function

[ https://issues.apache.org/jira/browse/CALCITE-3697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17748903#comment-17748903 ] Jiajun Xie commented on CALCITE-3697: - [~x1q1j1]  Would you please solve conflicting files?  >

[jira] [Commented] (CALCITE-5835) SqlParser.parseQuery() successfully parses DML and DDL statements without throwing a SqlParseException

[ https://issues.apache.org/jira/browse/CALCITE-5835?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17748890#comment-17748890 ] Jiajun Xie commented on CALCITE-5835: - Make sense. `top-level SqlNode representing stmt`  is more

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17746144#comment-17746144 ] Jiajun Xie commented on CALCITE-5688: - [~julianhyde] , so sorry. I should check the server parser,

[jira] [Commented] (CALCITE-5844) Make RelMdColumnOrigins to be extendable for getting columnOrigins from viewTable

[ https://issues.apache.org/jira/browse/CALCITE-5844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17746001#comment-17746001 ] Jiajun Xie commented on CALCITE-5844: - ViewTable will be expanded during query planning.  

[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=17741233#comment-17741233 ] Jiajun Xie commented on CALCITE-4455: - I implemented TRUNCATE TABLE statement that is DDL in

[jira] [Commented] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17740376#comment-17740376 ] Jiajun Xie commented on CALCITE-5688: - Fixed in

[jira] [Resolved] (CALCITE-5688) Support TRUNCATE TABLE DDL statement in server module

[ https://issues.apache.org/jira/browse/CALCITE-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiajun Xie resolved CALCITE-5688. - Fix Version/s: 1.35.0 Resolution: Fixed > Support TRUNCATE TABLE DDL statement in

[jira] [Commented] (CALCITE-5799) unnest(a) is wrong if a is structKind.PEEK_FIELDS_NO_EXPAND

[ https://issues.apache.org/jira/browse/CALCITE-5799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17739338#comment-17739338 ] Jiajun Xie commented on CALCITE-5799: - Maybe CALCITE-5126 can solve the issue. [~pyro] , can you

<    1   2   3   4   5   6   >