search

kamu-data / kamu-cli

Next-generation decentralized data lakehouse and a multi-party stream processing network
https://kamu.dev
Other
300 stars 13 forks source link

Errors in the Housing Prices example #803

Closed forrestdip closed 3 weeks ago

forrestdip commented 1 month ago

Describe the bug

I believe I found an error in the yaml file of taxes in housing prices and with the heat map jupyter notebook. When pulling the taxes yaml got the error:

Failed to pull ca.vancouver.opendata.property.tax-reports: 0: Engine error 1: Invalid query: Schema error: No field named pid. Valid fields are input."PID", input."LEGAL_TYPE", input."FOLIO", input."LAND_COORDINATE", input."ZONING_DISTRICT",…

I believe this error was due to a lack of uppercase letters in the sql query and when I capitalized them, I was able to pull the data.

The second issue which is for the heatmap jupyter notebook in the same example had a string error for it when I changed 'current_land_value + current_improvement_value as current_total_value'

Steps To Reproduce

Run the Housing Prices example. The first error occures when pulling ca.vancouver.opendata.property.tax-reports.yaml and the second error ocures when running the heatmap.ipynb.

Current Behavior

see errors in Describe the bug

Expected Behavior

Housing Prices example runs without error.

kamu system info

kamu system info
appVersion: 0.198.1
  buildTimestamp: 2024-08-28T10:59:56.493855494Z

Logs

No response

Anything else?

No response