nrg4878 commented on PR #4831: URL: https://github.com/apache/hive/pull/4831#issuecomment-1875284098
@wecharyu you had a comment about an index restricting performance boost from this change on PR#4744. > BWY, we have applied [#4831](https://github.com/apache/hive/pull/4831) in our prod env, and add a new index UNIQUE_PART (TBL_ID, PART_NAME), the MySQL did not choose the best index either in this case, and then we dropped the redundant index PARTITIONS_N49 (TBL_ID), and the getPartitionsByFilter has gained huge improvement. Is there more to be done on this change? is there a need for further optimization on the SQL side? Can we move this PR forward? -- 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: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For additional commands, e-mail: gitbox-h...@hive.apache.org
