Hi , I saw an interesting exchange about the CSVAdapter
I am also in a similar case where I want to be able to perform predicate filters from table after conversion from JSON to JsonScannableTable . the first dimension are correctly converted into the right type VARCHAR ect but other dimension like LIST or MAP are converted to "OTHER"-type it is therefore impossible to execute CONTAINS / IN OR ANY on column transformed to OTHER-TYPE I would like to know where it is the code best place to convert LIST MAP to a SQL type ARRAY_LIST and no OTHER I am new in calcite I have a little trouble understanding the type definition workflow. I looked at the side of JSONEnumerator but it seems opaque. thank you in advance Steve
