CODEWITHSUNDEEP
hivepresto
user2980461
user2980461

Reputation: 99

Is Presto Hive partition aware?

How does Presto deal with Hive partitions? can it recognize the partitions during the query execution? We are running into a performance issue while dealing with hive tables using partitions.

Upvotes: 4

Views: 4462

Answers (1)

David Phillips
David Phillips

Reputation: 10218

Presto fully supports and optimizes queries to take advantage of Hive partitions. (It also optimizes queries over bucketed tables.) We use Hive partitioning extensively at Facebook (almost every table is at least partitioned by date), so support for Hive partitions was one of the first features we added.

If you are having a problem and need help troubleshooting, please ask on the mailing list as StackOverflow does not work well for back-and-forth discourse: https://groups.google.com/group/presto-users

Upvotes: 6

Related Questions