Re: CSVAdapter OTHER TYPE

2019-11-27 Thread Stamatis Zampetakis
Hi Yanna, I order to create a Map or Array type you have to pass from RelDataTypeFactory#createMapType [1] or RelDataTypeFactory#createArrayType [2] respectively. From the error you get it seems that you are using RelDataTypeFactory#createJavaType [3]. Best, Stamatis [1]

Re: CSVAdapter OTHER TYPE

2019-11-26 Thread Yanna elina
*Hi Danny , * *From my side with your suggestion i have this error message : for MAP type : * *SELECT properties['fullyQualifiedDomainName'] FROM TABLE_TEST : * Cannot apply 'ITEM' to arguments of type 'ITEM(, )'. Supported form(s): [] [] at

Re: CSVAdapter OTHER TYPE

2019-11-26 Thread Steve Robert
Ok i got it , thank a lot Danny Le mar. 26 nov. 2019 à 01:53, Danny Chan a écrit : > 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

Re: CSVAdapter OTHER TYPE

2019-11-25 Thread Danny Chan
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]”,

CSVAdapter OTHER TYPE

2019-11-25 Thread Steve Robert
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