topic Re: Job aborted due to stage failure: Input buffer size 0 for bloom filter is not power of 2 in Data Engineering

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

robert37201 — Mon, 20 Mar 2023 20:51:53 GMT

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.

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

robert37201 — Mon, 20 Mar 2023 21:43:22 GMT

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

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

Lakshay — Tue, 21 Mar 2023 13:07:45 GMT

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.

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

Anonymous — Wed, 22 Mar 2023 03:09:28 GMT

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.