Query defined with LEFT JOINS but View returned with INNER JOINS

Feature Store
#1

Hi team,

Testing LEFT JOINS on feature views I realized that for some reason the View’s query state always shown INNER JOINS. I tested all join options (left, right and outer, excluding INNER) and in all cases the query state always ended as INNER join.

Screen Shot 2023-06-16 at 12.53.01
Screen Shot 2023-06-16 at 12.53.011313×362 67 KB

Screen Shot 2023-06-16 at 13.01.09
Screen Shot 2023-06-16 at 13.01.091295×230 11.3 KB

I’m using Hopsworks Serverless with Hopsworks API version 3.0.5. Can you please check the cause of this behavior on feature views?

Regards,
Didiosky

#2

Hi @didiosky-zigatta ,

Thanks for reporting this. Indeed looks like it’s a bug in the library. We are working on a fix, I’ll let you know when it’s going to be available.

Thanks
Fabio

#3

Hi @didiosky-zigatta ,

We released HSFS 3.0.9 (hsfs · PyPI) which fixes the issue above. You can also re-install the Hopsworks Python library and it should updated the HSFS library.

Thanks,
Fabio

#4

Hi @Fabio ,

Thank you for your outstanding support. I’ll upgrade HSFS.

Regards,
Didiosky

1 Like