Analytics not reading correct columns, case sensitivity?
d
drewbo19@gmail.com
First off, great tool and thanks for creating. I tried using analytics to visualize a column and received this error:
Error generating chart: DataFusion error: Schema error: No field named temperature_quality_code. Did you mean 'parquet_table.temperature_Quality_Code'?.
It looks like the field is being forced to lowercase at some point (the uppercase version is correct according to the Schema page and Column listing)
J
John Larkin
Yeah great callout. I remember seeing this as well.... I will try and fix it, I believe it's because I'm using DataFusion and I probably was a bit sloppy on the sql generation / making sure we were escaping everything cleanly.