YF Bigquery data source boolean field filtering does not work

Vefa Gulecyuz shared this problem 3 months ago
Defect Logged

Hi guys, we have a BigQuery data source and we have boolean fields in that data source.


When I try to filter on boolean fields in the view, YF gives me Yes or No options, but in the query these options are configured as 0 (zero) and 1 (one). This query returns error from BigQuery because they are integer fields, BigQuery expects true or false. Please see attached screen shots. It is same if I try to filter in the report as well.

I use BigQuery connector 4.1

Application Version:9.4.2

java.version:1.8.0_282

os.name:Linux

os.arch:amd64

os.version:4.19.112+

Comments (1)

photo
1

Hi Vefa,

Thanks for contacting Yellowfin!

We are aware of an bug with filters and BigQuery boolean data. I'll append this ticket to the master so you should get an update when it's been fixed. Unfortunately at the moment we don't have a workaround available.

If you're happy with that, I'll mark this as Defect Logged.

Kind regards,

Chris

photo
1

Thanks for the reply Chris. Is there a time estimation when it will be fiexed?

I understand that it is a bug from Yellowfin side, can I continue using JDBC driver 4.1 version after it is fixed? (Ideally we would like to be able to use 4.2 but there is already a private ticket created for this.)

photo
1

Hi Vefa,

I don't have a time estimation for you at the moment, but it is marked as a high priority. We generally bring out new feature and bug fix releases quarterly.

The same driver should work, yes, as it does seem to be a Yellowfin bug.

Kind regards,

Chris

photo