Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Presto query failing with error : Partition not found.

Highlighted

Presto query failing with error : Partition not found.

New Contributor

Hello,

I've are facing a scenario where I'm querying a particular table from Presto and at the sametime there is a spark SCD job running on the same table.
So when my query hits a particular partition and if that very partition at the same time is been replaced according to my SCD logic.
The PRESTO metastore isn't aware of this case and throws Partition not found ERROR.

What is the best way to overcome this scenario ?