GeezerVison is showing github.com — error: "Snowflake Data Type is not supported" on "NUMBER" with non-zero scale · Issue #3146 · feast-dev/feast
error: "Snowflake Data Type is not supported" on "NUMBER" with non-zero scale #3146
Description
Expected Behavior
feast plan/apply completed without error in version 0.23.0 and I was able to query with get_historical_features.
Current Behavior
With the snowflake datatype NUMBER(38,6) I get:
NotImplementedError: The following Snowflake Data Type is not supported: DECIMAL -- Convert to DOUBLE
Steps to reproduce
$ feast init -t snowflake- Alter the table like so:
alter table SNOWY_FEAST.PUBLIC."amazed_dane_feast_driver_hourly_stats" add column temp_conv_rate NUMBER(38,6);
update SNOWY_FEAST.PUBLIC."amazed_dane_feast_driver_hourly_stats" set temp_conv_rate = "conv_rate";
alter table SNOWY_FEAST.PUBLIC."amazed_dane_feast_driver_hourly_stats" drop column "conv_rate";
alter table SNOWY_FEAST.PUBLIC."amazed_dane_feast_driver_hourly_stats" rename column temp_conv_rate to "conv_rate";
Traceback (most recent call last):
...
raise NotImplementedError(
NotImplementedError: The following Snowflake Data Type is not supported: DECIMAL -- Convert to DOUBLE
Specifications
- Version:
Feast SDK Version: "feast 0.24.0"
- Platform: x86_64 on Python 3.10.5
- Subsystem: Linux 5.4.203-
Possible Solution
Activity
achals commented on Aug 26, 2022
sfc-gh-madkins commented on Aug 27, 2022
@cburroughs my advice for right now would be to cast this to type double/float, as the error recommends. Let me see if I can get NUMBER with scale to work.
The issue stems from afew things. One protobuf doesnt support fixed point numbers, with scale. Two, how NUMBER is passed to pandas types.
cburroughs commented on Aug 30, 2022
ContributorAuthor
More actions
I installed from master to test it out. Looks good; thank you!
Metadata
Metadata
Development
No branches or pull requestsIssue actions