[ https://issues.apache.org/jira/browse/HIVE-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13755009#comment-13755009 ]
Sergey Shelukhin commented on HIVE-5158: ---------------------------------------- The existing logic to get all partitions doesn't actually appear to have any... it has max parameter but no offset. It does make sense to have it though. Let me take a look, probably in a separate jira. Might require API change > allow getting all partitions for table to also use direct SQL path > ------------------------------------------------------------------ > > Key: HIVE-5158 > URL: https://issues.apache.org/jira/browse/HIVE-5158 > Project: Hive > Issue Type: Improvement > Reporter: Sergey Shelukhin > Assignee: Sergey Shelukhin > Attachments: HIVE-5158.D12573.1.patch, HIVE-5158.D12573.2.patch, > HIVE-5158.D12573.3.patch, HIVE-5158.D12573.4.patch > > > While testing some queries I noticed that getPartitions can be very slow > (which happens e.g. in non-strict mode with no partition column filter); with > a table with many partitions it can take 10-12s easily. SQL perf path can > also be used for this path. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira