Value-based Query API for the Online Store

[swapkh91]

Is there a way to fetch features from Online Store with SQL like query for example using where clause?

I have multiple columns where I need to filter the rows (which I currently do through a SQL table using where clause). I'm thinking of moving this table to Feast, so I can have history separately in offline store. One way is to combine all columns and form a new column and do fetch but that would greatly increase the number of rows.

Any idea on how to achieve this?

[achals]

Hi @swapkh91 , not sure I understand the ask here. Do you want to be able to surface only features for certain entities from the online store, on criteria other than the entitiy id / join key (like the value of the feature)?

[swapkh91]

@achals yes. So instead of getting features for entity_rows only, I would like to fetch the entities matching feature values. Like in a SQL query select entity_column from table where feature_column=value. The use case is that I only know the feature values and need to find the entities matching those.

Not sure if this is the use case for Feast.

[achals]

Thanks @swapkh91 - this is not something that is supported in Feast right now, but I can imagine this being useful for specific use cases like recommendations systems for candidate generation.

The feast time is planning on prioritizing work on transformations and data quality for the coming few months so we are unlikely to get to it, but we'd be happy to review community contributions for it. A good start would be a mini-RFC to describe what the API would like look.

I'll update the title of the issue with my understanding, but please correct me if I'm wrong.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.