Evidence struggles to run queries in Trino due to casting issues on request_month, received_date in the HPD and 311 filesets.
[Processing] nycdata
aggregated__agencies ℹ Skipped
aggregated__monthly_requests_type ◢ Processing...SyntaxError: Cannot convert 2025-02-01 to a BigInt
at BigInt (<anonymous>)
at TimestampMillisecondBuilder.setTimestampMillisecond [as _setValue] (file:///Users/risa/Documents/repos/database
-tycoon/Renegade/evidence/node_modules/@evidence-dev/universal-sql/node_modules/apache-arrow/visitor/set.mjs:86:88)
The aggregated__monthly_requests_type issue is from a dbt model where no malformed values appear to be present when querying in Starburst. Same issue occurs on dbt model for hpd_complaints.
Evidence struggles to run queries in Trino due to casting issues on
request_month,received_datein the HPD and 311 filesets.The
aggregated__monthly_requests_typeissue is from a dbt model where no malformed values appear to be present when querying in Starburst. Same issue occurs on dbt model forhpd_complaints.