wecharyu commented on PR #4744: URL: https://github.com/apache/hive/pull/4744#issuecomment-1902571091
> From what I see in benchmarkGetPartitionsStat, looks there is only one table, thousands of partitions and col stats, am I missing something? 2 millions partition column stats are added in the mysql before benchmark test. benchmarkGetPartitionsStat will still only query the count as input by -N options. > I guess the performance regression is caused by multiple join after removing the columns, how many databases, tables, partitions in the bench test? The 2 millions partition column rows are: 10 dbs * 10 tbls per db * 200 partitions per tbl * 100 column stats per partition -- 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]
