Thanks, Steve ~ Calcite did support LIST type syntax, such as “INT ARRAY” or “INT MULTISET ARRAY”, but we do not support MAP syntax yet, because it is not a SQL standard, so the MAP type would always parsed to other type.
You can reference a ARRAY column item with syntax “column_name[_index]”, and MAP column value with syntax “column_name[‘key_name’]”, these syntax also works with “OTHER”/“ANY” data type. Best, Danny Chan 在 2019年11月25日 +0800 PM8:22，Steve Robert <[email protected]>，写道： > 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
