cxzl25 commented on PR #4474:
URL: https://github.com/apache/hive/pull/4474#issuecomment-1697396769
> i was just wondering why we need `PART_ID` if it's already part of PK.
I checked that the index for `PART_ID` exists from very early versions, it
is really not necessary.
```sql
PRIMARY KEY (`PART_ID`,`INTEGER_IDX`),
KEY `PARTITION_KEY_VALS_N49` (`PART_ID`),
```
> do we know what is the impact on write operations
If the discussion is about the impact of newly added indexes on writing, it
can almost be ignored.
This index has been added in production for several years and it works fine.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
