[
https://issues.apache.org/jira/browse/HIVE-27555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng updated HIVE-27555:
-------------------------------
Description:
In HIVE-27457, we try to update the serde lib, (input/output)format of the kudu
table in back db. In the upgrade scripts, we join the "SDS"."SD_ID" with
"TABLE_PARAMS"."TBL_ID",
https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.mysql.sql#L37-L39
as "SD_ID" is the primary key of SDS, and "TBL_ID" is the primary key of TBLS,
we can't join the two tables using these two columns.
was:
In HIVE-27457, we try to update the serde lib, (input/output)format of the kudu
table in back db. In the upgrade scripts, we join the "SDS"."SD_ID" with
"TABLE_PARAMS"."TBL_ID",
[https://github.com/zchovan/hive/blob/454b3000b74f8df8114895d60f4befbbd64d62ec/standalone-metastore/metastore-server/src/main/sql/derby/upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.derby.sql#L36-L38]
as "SD_ID" is the primary key of SDS, and "TBL_ID" is the primary key of TBLS,
we can't join the two tables using these two columns.
> Kudu table storage handler doesn't update correctly in backend db
> -----------------------------------------------------------------
>
> Key: HIVE-27555
> URL: https://issues.apache.org/jira/browse/HIVE-27555
> Project: Hive
> Issue Type: Bug
> Reporter: Zhihua Deng
> Priority: Major
>
> In HIVE-27457, we try to update the serde lib, (input/output)format of the
> kudu table in back db. In the upgrade scripts, we join the "SDS"."SD_ID"
> with "TABLE_PARAMS"."TBL_ID",
> https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.mysql.sql#L37-L39
> as "SD_ID" is the primary key of SDS, and "TBL_ID" is the primary key of
> TBLS, we can't join the two tables using these two columns.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
