Skip to content

Snowflake type behavior is strange #2633

@felixwang9817

Description

@felixwang9817

Expected Behavior

Current Behavior

In test_universal_online::test_online_retrieval, orders_df has the following dtypes:

order_id             int64
driver_id            int64
customer_id          int64
origin_id            int64
destination_id       int64
order_is_success     int32
event_timestamp     object
dtype: object

When type inference occurs, get_table_column_names_and_types returns [('order_id', 'int8'), ('driver_id', 'int16'), ('customer_id', 'int16'), ('origin_id', 'int8'), ('destination_id', 'int8'), ('order_is_success', 'int8'), ('event_timestamp', 'datetime64[ns]')].

Steps to reproduce

Specifications

  • Version:
  • Platform:
  • Subsystem:

Possible Solution

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions