[jira] [Resolved] (HIVE-28485) Skip CBO for union type

2024-10-30 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das resolved HIVE-28485. Fix Version/s: 4.1.0 Resolution: Abandoned Abandoning this as basic support for UNIO

[jira] [Updated] (HIVE-28571) Basic UNIONTYPE support in CBO

2024-10-30 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28571: --- Parent: HIVE-27831 Issue Type: Sub-task (was: Improvement) Security: (was:

[jira] [Assigned] (HIVE-26582) Cartesian join fails if the query has an empty table when cartesian product edge is used

2024-10-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26582: -- Assignee: Soumyakanti Das > Cartesian join fails if the query has an empty table when

[jira] [Created] (HIVE-28576) Add jdbc tests for tpcds queries

2024-10-14 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28576: -- Summary: Add jdbc tests for tpcds queries Key: HIVE-28576 URL: https://issues.apache.org/jira/browse/HIVE-28576 Project: Hive Issue Type: Improvement

[jira] [Updated] (HIVE-28564) AssertionError for jdbc queries when JDBCExpandExpressionsRule produces non flat Filter conditions

2024-10-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28564: --- Description: To repro this, create four tpcds table in postgres by copying [^q_test_tpcds_ta

[jira] [Updated] (HIVE-28560) AssertionError for jdbc queries because of incorrect expectedRel in SqlImplementor

2024-10-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28560: --- Summary: AssertionError for jdbc queries because of incorrect expectedRel in SqlImplementor

[jira] [Updated] (HIVE-28560) AssertionError for jdbc tpcds queries because of incorrect expectedRel in SqlImplementor

2024-10-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28560: --- Description: To reproduce this, we need to create tpcds tables in postgres. [^q_test_tpcds_t

[jira] [Updated] (HIVE-28564) AssertionError for jdbc queries when JDBCExpandExpressionsRule produces non flat Filter conditions

2024-10-08 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28564: --- Description: To repro this, create four tpcds table in postgres by copying [^q_test_tpcds_t

[jira] [Created] (HIVE-28564) AssertionError for jdbc queries when JDBCExpandExpressionsRule produces non flat Filter conditions

2024-10-08 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28564: -- Summary: AssertionError for jdbc queries when JDBCExpandExpressionsRule produces non flat Filter conditions Key: HIVE-28564 URL: https://issues.apache.org/jira/browse/HIVE-285

[jira] [Updated] (HIVE-28564) AssertionError for jdbc queries when JDBCExpandExpressionsRule produces non flat Filter conditions

2024-10-08 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28564: --- Description: To repro this, create four tpcds table in postgres by copying [^q_test_tpcds_t

[jira] [Updated] (HIVE-28564) AssertionError for jdbc queries when JDBCExpandExpressionsRule produces non flat Filter conditions

2024-10-08 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28564: --- Description: To repro this, create four tpcds table in postgres by copying q_test_tpcds_tabl

[jira] [Updated] (HIVE-28560) AssertionError for jdbc tpcds queries because of incorrect expectedRel in SqlImplementor

2024-10-07 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28560: --- Description: To reproduce this, we need to create tpcds tables in postgres. [^q_test_tpcds_t

[jira] [Updated] (HIVE-28560) AssertionError for jdbc tpcds queries because of incorrect expectedRel in SqlImplementor

2024-10-07 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28560: --- Attachment: test.q > AssertionError for jdbc tpcds queries because of incorrect expectedRel i

[jira] [Updated] (HIVE-28560) AssertionError for jdbc tpcds queries because of incorrect expectedRel in SqlImplementor

2024-10-07 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28560: --- Attachment: (was: test.q) > AssertionError for jdbc tpcds queries because of incorrect ex

[jira] [Created] (HIVE-28560) AssertionError for jdbc tpcds queries because of incorrect expectedRel in SqlImplementor

2024-10-07 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28560: -- Summary: AssertionError for jdbc tpcds queries because of incorrect expectedRel in SqlImplementor Key: HIVE-28560 URL: https://issues.apache.org/jira/browse/HIVE-28560

[jira] [Commented] (HIVE-28280) SemanticException when querying VIEW with DISTINCT clause

2024-09-18 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882821#comment-17882821 ] Soumyakanti Das commented on HIVE-28280: [~zabetak] [~kkasa]  I wasn't able to r

[jira] [Resolved] (HIVE-28333) Skip CBO for UNIQUEJOIN and TABLESAMPLE

2024-09-06 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das resolved HIVE-28333. Fix Version/s: 4.1.0 Resolution: Fixed > Skip CBO for UNIQUEJOIN and TABLESAMPLE > -

[jira] [Assigned] (HIVE-27080) Support project pushdown in JDBC storage handler even when filters are not pushed

2024-08-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-27080: -- Assignee: Soumyakanti Das > Support project pushdown in JDBC storage handler even when

[jira] [Created] (HIVE-28485) Skip CBO for union type

2024-08-27 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28485: -- Summary: Skip CBO for union type Key: HIVE-28485 URL: https://issues.apache.org/jira/browse/HIVE-28485 Project: Hive Issue Type: Sub-task Rep

[jira] [Updated] (HIVE-28333) Skip CBO for UNIQUEJOIN and TABLESAMPLE

2024-08-27 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28333: --- Summary: Skip CBO for UNIQUEJOIN and TABLESAMPLE (was: Skip CBO for UNIQUEJOIN, TABLESAMPLE,

[jira] [Updated] (HIVE-28333) Skip CBO for UNIQUEJOIN and TABLESAMPLE

2024-08-27 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28333: --- Description: CBO doesn't support TABLESAMPLE, UNIQUEJOIN, and UNIONTYPE. h3. TABLESAMPLE not

[jira] [Resolved] (HIVE-28313) Support ambiguous column references when CBO fallback is disabled

2024-08-15 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das resolved HIVE-28313. Fix Version/s: 4.1.0 Resolution: Fixed Resolving as this has been merged now. Thanks

[jira] [Commented] (HIVE-24907) Wrong results with LEFT JOIN and subqueries with UNION and GROUP BY

2024-08-14 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17873768#comment-17873768 ] Soumyakanti Das commented on HIVE-24907: >From my testing, it looks like this is

[jira] [Created] (HIVE-28427) HivePreFilteringRule gets applied multiple times

2024-08-01 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28427: -- Summary: HivePreFilteringRule gets applied multiple times Key: HIVE-28427 URL: https://issues.apache.org/jira/browse/HIVE-28427 Project: Hive Issue Type:

[jira] [Updated] (HIVE-28333) Skip CBO for UNIQUEJOIN, TABLESAMPLE, and UNIONTYPE

2024-06-27 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28333: --- Description: CBO doesn't support TABLESAMPLE, UNIQUEJOIN, and UNIONTYPE. h3. TABLESAMPLE not

[jira] [Updated] (HIVE-28333) Skip CBO for UNIQUEJOIN, TABLESAMPLE, and UNIONTYPE

2024-06-24 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28333: --- Description: CBO doesn't support TABLESAMPLE and UNIQUEJOIN.  h3. TABLESAMPLE not supported

[jira] [Updated] (HIVE-28333) Skip CBO for UNIQUEJOIN, TABLESAMPLE, and UNIONTYPE

2024-06-24 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28333: --- Summary: Skip CBO for UNIQUEJOIN, TABLESAMPLE, and UNIONTYPE (was: Skip CBO for UNIQUEJOIN a

[jira] [Created] (HIVE-28333) Skip CBO for UNIQUEJOIN and TABLESAMPLE

2024-06-17 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28333: -- Summary: Skip CBO for UNIQUEJOIN and TABLESAMPLE Key: HIVE-28333 URL: https://issues.apache.org/jira/browse/HIVE-28333 Project: Hive Issue Type: Sub-task

[jira] [Comment Edited] (HIVE-27831) Set hive.cbo.fallback.strategy to NEVER by default

2024-06-12 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17854553#comment-17854553 ] Soumyakanti Das edited comment on HIVE-27831 at 6/12/24 10:06 PM: -

[jira] [Commented] (HIVE-27831) Set hive.cbo.fallback.strategy to NEVER by default

2024-06-12 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17854553#comment-17854553 ] Soumyakanti Das commented on HIVE-27831: This test is no longer failing in the la

[jira] [Created] (HIVE-28314) Support literals as filter expression with non-boolean return type

2024-06-07 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28314: -- Summary: Support literals as filter expression with non-boolean return type Key: HIVE-28314 URL: https://issues.apache.org/jira/browse/HIVE-28314 Project: Hive

[jira] [Created] (HIVE-28313) Support ambiguous column references when CBO fallback is disabled

2024-06-07 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28313: -- Summary: Support ambiguous column references when CBO fallback is disabled Key: HIVE-28313 URL: https://issues.apache.org/jira/browse/HIVE-28313 Project: Hive

[jira] [Created] (HIVE-28197) Add deserializer to convert JSON plans to RelNodes

2024-04-14 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28197: -- Summary: Add deserializer to convert JSON plans to RelNodes Key: HIVE-28197 URL: https://issues.apache.org/jira/browse/HIVE-28197 Project: Hive Issue Typ

[jira] [Commented] (HIVE-28094) Improve HMS client cache and query cache performance for getTableInternal

2024-02-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17822328#comment-17822328 ] Soumyakanti Das commented on HIVE-28094: After further testing, I found that curr

[jira] [Updated] (HIVE-28094) Improve HMS client cache and query cache performance for getTableInternal

2024-02-26 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28094: --- Description: Currently we cache calls to {{getTableInternal}} method in HMS client cache and

[jira] [Updated] (HIVE-28094) Improve HMS client cache and query cache performance for getTableInternal

2024-02-26 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28094: --- Description: Currently we cache calls to {{getTableInternal}} method in HMS client cache and

[jira] [Updated] (HIVE-28094) Improve HMS client cache and query cache performance for getTableInternal

2024-02-26 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28094: --- Summary: Improve HMS client cache and query cache performance for getTableInternal (was: Imp

[jira] [Updated] (HIVE-28094) Improve HMS client and query cache performance for getTableInternal

2024-02-26 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28094: --- Summary: Improve HMS client and query cache performance for getTableInternal (was: Improve H

[jira] [Created] (HIVE-28094) Improve HMS client and query caching performance for getTableInternal

2024-02-26 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28094: -- Summary: Improve HMS client and query caching performance for getTableInternal Key: HIVE-28094 URL: https://issues.apache.org/jira/browse/HIVE-28094 Project: Hive

[jira] [Created] (HIVE-28083) Enable HMS client cache and HMS query cache for Explain plans

2024-02-20 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28083: -- Summary: Enable HMS client cache and HMS query cache for Explain plans Key: HIVE-28083 URL: https://issues.apache.org/jira/browse/HIVE-28083 Project: Hive

[jira] [Updated] (HIVE-28061) Fix PerfLogger for recursive methods

2024-02-05 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28061: --- Description: Currently PerfLogger stores its {{startTimes}} and {{endTimes}} in a Map, where

[jira] [Created] (HIVE-28061) Fix PerfLogger for recursive methods

2024-02-05 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28061: -- Summary: Fix PerfLogger for recursive methods Key: HIVE-28061 URL: https://issues.apache.org/jira/browse/HIVE-28061 Project: Hive Issue Type: Bug

[jira] [Updated] (HIVE-28054) SemanticException for join condition in subquery

2024-02-01 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-28054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-28054: --- Affects Version/s: 4.0.0-beta-1 > SemanticException for join condition in subquery >

[jira] [Created] (HIVE-28054) SemanticException for join condition in subquery

2024-02-01 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-28054: -- Summary: SemanticException for join condition in subquery Key: HIVE-28054 URL: https://issues.apache.org/jira/browse/HIVE-28054 Project: Hive Issue Type:

[jira] [Created] (HIVE-27949) GenericUDFAddMonths doesn't accept DECIMAL with scale zero for num_months

2023-12-11 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27949: -- Summary: GenericUDFAddMonths doesn't accept DECIMAL with scale zero for num_months Key: HIVE-27949 URL: https://issues.apache.org/jira/browse/HIVE-27949 Project:

[jira] [Updated] (HIVE-27533) Incorrect FOREIGN KEY constraints in SHOW CREATE TABLE

2023-11-14 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27533: --- Description: For a table that has a composite foreign key, SHOW CREATE TABLE returns multipl

[jira] [Updated] (HIVE-27531) Unparse identifiers in show create table output

2023-10-05 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27531: --- Description: Currently, {{SHOW CREATE TABLE}} on tables with constraints return {{ALTER TABL

[jira] [Updated] (HIVE-27531) Unparse identifiers in show create table output

2023-10-05 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27531: --- Summary: Unparse identifiers in show create table output (was: Incorrect constraint name for

[jira] [Updated] (HIVE-27761) Compilation of nested CTEs throws SemanticException

2023-09-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27761: --- Summary: Compilation of nested CTEs throws SemanticException (was: SemanticException for Nes

[jira] [Created] (HIVE-27761) SemanticException for Nested CTEs

2023-09-29 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27761: -- Summary: SemanticException for Nested CTEs Key: HIVE-27761 URL: https://issues.apache.org/jira/browse/HIVE-27761 Project: Hive Issue Type: Bug

[jira] [Updated] (HIVE-27532) Missing semicolon in show create table and show create database output

2023-08-24 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27532: --- Description: When we run SHOW CREATE TABLE on a table with constraints, it doesn't add a sem

[jira] [Updated] (HIVE-27532) Missing semicolon in show create table/database output

2023-08-24 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27532: --- Summary: Missing semicolon in show create table/database output (was: Missing semicolon in s

[jira] [Updated] (HIVE-27532) Missing semicolon in show create table and show create database output

2023-08-24 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27532: --- Summary: Missing semicolon in show create table and show create database output (was: Missin

[jira] [Created] (HIVE-27648) CREATE TABLE with CHECK constraint fails with SemanticException

2023-08-24 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27648: -- Summary: CREATE TABLE with CHECK constraint fails with SemanticException Key: HIVE-27648 URL: https://issues.apache.org/jira/browse/HIVE-27648 Project: Hive

[jira] [Resolved] (HIVE-27578) Refactor genJoinRelNode to use genAllRexNode instead of genAllExprNodeDesc

2023-08-17 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das resolved HIVE-27578. Resolution: Fixed > Refactor genJoinRelNode to use genAllRexNode instead of genAllExprNodeD

[jira] [Commented] (HIVE-27578) Refactor genJoinRelNode to use genAllRexNode instead of genAllExprNodeDesc

2023-08-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17752851#comment-17752851 ] Soumyakanti Das commented on HIVE-27578: Hey [~zabetak], I have updated the Jira

[jira] [Updated] (HIVE-27578) Refactor genJoinRelNode to use genAllRexNode instead of genAllExprNodeDesc

2023-08-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27578: --- Description: Currently {{genJoinRelNode}} method relies on {{genAllExprNodeDesc}} for adding

[jira] [Updated] (HIVE-27578) Refactor genJoinRelNode to use genAllRexNode instead of genAllExprNodeDesc

2023-08-07 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27578: --- Summary: Refactor genJoinRelNode to use genAllRexNode instead of genAllExprNodeDesc (was: Re

[jira] [Created] (HIVE-27578) Refactor genJoinRelNode to use only RexNodes

2023-08-07 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27578: -- Summary: Refactor genJoinRelNode to use only RexNodes Key: HIVE-27578 URL: https://issues.apache.org/jira/browse/HIVE-27578 Project: Hive Issue Type: Imp

[jira] [Resolved] (HIVE-27495) NPE when trying to transform using clause to on clause

2023-08-03 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das resolved HIVE-27495. Resolution: Fixed > NPE when trying to transform using clause to on clause > --

[jira] [Created] (HIVE-27533) Incorrect FOREIGN KEY constraints in SHOW CREATE TABLE

2023-07-26 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27533: -- Summary: Incorrect FOREIGN KEY constraints in SHOW CREATE TABLE Key: HIVE-27533 URL: https://issues.apache.org/jira/browse/HIVE-27533 Project: Hive Issue

[jira] [Created] (HIVE-27532) Missing semicolon in show create table output

2023-07-26 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27532: -- Summary: Missing semicolon in show create table output Key: HIVE-27532 URL: https://issues.apache.org/jira/browse/HIVE-27532 Project: Hive Issue Type: Bu

[jira] [Created] (HIVE-27531) Incorrect constraint name format in the output of show create table

2023-07-26 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27531: -- Summary: Incorrect constraint name format in the output of show create table Key: HIVE-27531 URL: https://issues.apache.org/jira/browse/HIVE-27531 Project: Hive

[jira] [Updated] (HIVE-27495) NPE when trying to transform using clause to on clause

2023-07-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-27495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-27495: --- Description: To reproduce, run the following: {code:java} create table test ( id int ); sel

[jira] [Created] (HIVE-27495) NPE when trying to transform using clause to on clause

2023-07-10 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27495: -- Summary: NPE when trying to transform using clause to on clause Key: HIVE-27495 URL: https://issues.apache.org/jira/browse/HIVE-27495 Project: Hive Issue

[jira] [Created] (HIVE-27349) Move HMS call to get stored procedure out of Udf

2023-05-16 Thread Soumyakanti Das (Jira)
Soumyakanti Das created HIVE-27349: -- Summary: Move HMS call to get stored procedure out of Udf Key: HIVE-27349 URL: https://issues.apache.org/jira/browse/HIVE-27349 Project: Hive Issue Type:

[jira] [Updated] (HIVE-26845) Update HtmlUnit in itests/hive-unit to 2.67.0

2022-12-13 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-26845: --- Description: Upgrade HtmlUnit from 2.45.0 to 2.67.0. Htmlunit-xpath ([https://github.com/Html

[jira] [Assigned] (HIVE-26845) Update HtmlUnit in itests/hive-unit to 2.67.0

2022-12-13 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26845: -- > Update HtmlUnit in itests/hive-unit to 2.67.0 >

[jira] [Commented] (HIVE-21599) Parquet predicate pushdown on partition columns may cause wrong result if files contain partition columns

2022-11-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17631897#comment-17631897 ] Soumyakanti Das commented on HIVE-21599: The new patch works by removing the part

[jira] [Assigned] (HIVE-21599) Remove predicate on partition columns from Table Scan operator

2022-11-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-21599: -- Assignee: Soumyakanti Das (was: Vineet Garg) > Remove predicate on partition columns

[jira] [Updated] (HIVE-21599) Parquet predicate pushdown on partition columns may cause wrong result if files contain partition columns

2022-11-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-21599: --- Summary: Parquet predicate pushdown on partition columns may cause wrong result if files cont

[jira] [Assigned] (HIVE-26534) GROUPING() function errors out due to case-sensitivity of function name

2022-09-12 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26534: -- Assignee: Soumyakanti Das > GROUPING() function errors out due to case-sensitivity of

[jira] [Assigned] (HIVE-26442) SemanticException for INSERT INTO statement when CBO is disabled

2022-08-01 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26442: -- > SemanticException for INSERT INTO statement when CBO is disabled > -

[jira] [Assigned] (HIVE-26373) ClassCastException while inserting Avro data into Hbase table for nested struct with Timestamp

2022-07-06 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26373: -- > ClassCastException while inserting Avro data into Hbase table for nested > struct with

[jira] [Assigned] (HIVE-26350) IndexOutOfBoundsException when generating splits for external JDBC table with partition columns

2022-06-22 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26350: -- Assignee: Soumyakanti Das > IndexOutOfBoundsException when generating splits for exter

[jira] [Updated] (HIVE-26191) Missing catalog name in GetTableRequest results in duplicate values in query level cache

2022-04-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-26191: --- Description: {{getTableInternal}} method in {{SessionHiveMetaStoreClient}} accepts a {{GetTa

[jira] [Updated] (HIVE-26191) Missing catalog name in GetTableRequest results in duplicate values in query level cache

2022-04-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-26191: --- Attachment: query_cache.png > Missing catalog name in GetTableRequest results in duplicate va

[jira] [Updated] (HIVE-26191) Missing catalog name in GetTableRequest results in duplicate values in query level cache

2022-04-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-26191: --- Description: {{getTableInternal}} method in {{SessionHiveMetaStoreClient}} accepts a {{GetTa

[jira] [Assigned] (HIVE-26191) Missing catalog name in GetTableRequest results in duplicate values in query level cache

2022-04-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26191: -- > Missing catalog name in GetTableRequest results in duplicate values in query > level ca

[jira] [Assigned] (HIVE-26188) Query level cache and HMS local cache doesn't work locally and with Explain statements.

2022-04-28 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26188: -- > Query level cache and HMS local cache doesn't work locally and with Explain > statement

[jira] [Updated] (HIVE-26163) Incorrect format in columnstats_columnname_parse.q's insert statement can cause exceptions

2022-04-21 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-26163: --- Description: Exception: {code:java} 2022-04-20T10:13:06,467 ERROR [016f5292-40a7-4fe6-be58-1c

[jira] [Assigned] (HIVE-26163) Incorrect format in columnstats_columnname_parse.q's insert statement can cause exceptions

2022-04-21 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26163: -- > Incorrect format in columnstats_columnname_parse.q's insert statement can > cause excep

[jira] [Updated] (HIVE-26119) Remove unnecessary Exceptions from DDLPlanUtils

2022-04-05 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-26119: --- Description: There are a few {{HiveExceptions}} which were added to a few methods like {{getC

[jira] [Assigned] (HIVE-26119) Remove unnecessary Exceptions from DDLPlanUtils

2022-04-05 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-26119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-26119: -- > Remove unnecessary Exceptions from DDLPlanUtils > --

[jira] [Assigned] (HIVE-25728) ParseException while gathering Column Stats

2022-04-01 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-25728: -- Assignee: Soumyakanti Das > ParseException while gathering Column Stats >

[jira] [Resolved] (HIVE-25893) NPE when reading Parquet data because ColumnVector isNull[] is not updated

2022-02-09 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das resolved HIVE-25893. Resolution: Fixed > NPE when reading Parquet data because ColumnVector isNull[] is not upda

[jira] [Assigned] (HIVE-25893) NPE when reading Parquet data because ColumnVector isNull[] is not updated

2022-01-24 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-25893: -- > NPE when reading Parquet data because ColumnVector isNull[] is not updated > ---

[jira] [Updated] (HIVE-25728) ParseException while gathering Column Stats

2021-11-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-25728: --- Description: The {{columnName}} is escaped twice in {{ColumnStatsSemanticAnalyzer}} at [line

[jira] [Updated] (HIVE-25728) ParseException while gathering Column Stats

2021-11-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-25728: --- Description: The {{columnName}} is escaped twice in {{ColumnStatsSemanticAnalyzer}} at [line

[jira] [Updated] (HIVE-25728) ParseException while gathering Column Stats

2021-11-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-25728: --- Description: The {{columnName}} is escaped twice in {{ColumnStatsSemanticAnalyzer}} at [line

[jira] [Updated] (HIVE-25728) ParseException while gathering Column Stats

2021-11-29 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-25728: --- Description: The {{columnName}} is escaped twice in {{ColumnStatsSemanticAnalyzer}} at [line

[jira] [Commented] (HIVE-25652) Add constraints in result of “SHOW CREATE TABLE ”

2021-11-10 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17442073#comment-17442073 ] Soumyakanti Das commented on HIVE-25652: [~harshit.gupta] , Thanks for the sugge

[jira] [Assigned] (HIVE-25652) Add constraints in result of “SHOW CREATE TABLE ”

2021-10-26 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-25652: -- > Add constraints in result of “SHOW CREATE TABLE ” >

[jira] [Commented] (HIVE-23479) Avoid regenerating JdbcSchema for every table in a query

2021-10-15 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17429485#comment-17429485 ] Soumyakanti Das commented on HIVE-23479: Fixed with HIVE-25530. Resolving issue.

[jira] [Resolved] (HIVE-23479) Avoid regenerating JdbcSchema for every table in a query

2021-10-15 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das resolved HIVE-23479. Resolution: Fixed > Avoid regenerating JdbcSchema for every table in a query >

[jira] [Commented] (HIVE-25566) Show column constraints for "DESC FORMATTED TABLE"

2021-09-28 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17421574#comment-17421574 ] Soumyakanti Das commented on HIVE-25566: Done!  > Show column constraints for "D

[jira] [Updated] (HIVE-25566) Show column constraints for "DESC FORMATTED TABLE"

2021-09-28 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-25566: --- Description: Currently, column constraints are not shown with the data type of columns. They

[jira] [Updated] (HIVE-25566) Show column constraints for "DESC FORMATTED TABLE"

2021-09-28 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-25566: --- Issue Type: New Feature (was: Improvement) > Show column constraints for "DESC FORMATTED TAB

[jira] [Updated] (HIVE-25566) Show column constraints for "DESC FORMATTED TABLE"

2021-09-27 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das updated HIVE-25566: --- Priority: Minor (was: Major) > Show column constraints for "DESC FORMATTED TABLE" >

[jira] [Assigned] (HIVE-25566) Show column constraints for "DESC FORMATTED TABLE"

2021-09-27 Thread Soumyakanti Das (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Soumyakanti Das reassigned HIVE-25566: -- > Show column constraints for "DESC FORMATTED TABLE" > ---

  1   2   >