You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Yu-Wen Lai (Jira)" <ji...@apache.org> on 2021/12/04 05:57:00 UTC
[jira] [Created] (HIVE-25773) Column descriptors might not deleted via direct sql
Yu-Wen Lai created HIVE-25773:
---------------------------------
Summary: Column descriptors might not deleted via direct sql
Key: HIVE-25773
URL: https://issues.apache.org/jira/browse/HIVE-25773
Project: Hive
Issue Type: Bug
Components: Metastore
Reporter: Yu-Wen Lai
Assignee: Yu-Wen Lai
Steps to reproduce:
1. create a partitioned table
2. add a partition _p_
3. add column to the partition _p_ (a column descriptor will be created)
4. drop partition _p_
The new column descriptor still existed even though there's no relation left. We are currently using below SQL and extract the results that count = 0 as dangling column descriptors. However, it is impossible to get count = 0 from groupby query so they will never be deleted if it is not a table's default column descriptor.
{code:java}
SELECT SDS.CD_ID, count(1)
FROM SDS WHERE SDS.CD_ID in (cdIds)
GROUP BY SDS.CD_ID;{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)