Job aborted due to stage failure: Input buffer size 0 for bloom filter is not power of 2

robert37201
New Contributor II

‎03-20-2023 01:51 PM

Query works great in a notebook, fails in Classic SQL Warehouse (photon enabled) with that error. Tables are relatively small. Just don't know where to begin understanding that error, google wasn't much help and Query History doesn't give me anything but that error text.

robert37201
New Contributor II

‎03-20-2023 02:43 PM

I found a union deep in the query that was returning no rows and I think must be triggering some confusion in Photon.

Lakshay
Databricks Employee
Databricks Employee

‎03-21-2023 06:07 AM

Hi @Robert McCartney​ , This issue has been reported in the past. We are working on a fix for this issue. Meanwhile, you can run this query without photon enabled. This should probably resolve the issue.

Anonymous
Not applicable

‎03-21-2023 08:09 PM

Hi @Robert McCartney​ 

We haven't heard from you since the last response from @Lakshay Goel​ ​, and I was checking back to see if his suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others. 

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.