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 (Json content) from String / InputStream

2019-11-19 Thread Yanna elina
). >> > > >> > > On Thu, Nov 14, 2019 at 1:24 PM Julian Hyde wrote: >> > > >> > >> Remember that CsvAdapter is in the “example” module. Keep it simple. >> > >> >> > >> The file adapter can also parse

Re: CsvAdapter (Json content) from String / InputStream

2019-11-18 Thread Yanna elina
gt; >> > > >> Julian > > >> > > >> > > >> > > >>> On Nov 14, 2019, at 9:40 AM, Andrei Sereda wrote: > > >>> > > >>> Hello, > > >>> > > >>> Source object already expos

CsvAdapter (Json content) from String / InputStream

2019-11-14 Thread Yanna elina
Hi guys , I saw in the code that this nice adapter makes it possible to make SQL queries on the data JSON https://github.com/apache/calcite/tree/ab71c4cae5a5c3c7d979337a2d38ddaf271aa206/example/csv/src/main/java/org/apache/calcite/adapter/csv But it's limited on File / URL. JsonTable constructor

Re: CassandraAdapter (Add Type) and WHERE statement.

2019-10-18 Thread Yanna elina
Calcite anyway. > -- > Michael Mior > mm...@apache.org > > Le jeu. 17 oct. 2019 à 09:13, Yanna elina a > écrit : > > > > Thank for reply Michael. > > > > yes i understood this on the documentation for example with "WHERE" > > statement calcite i

Re: CassandraAdapter (Add Type) and WHERE statement.

2019-10-17 Thread Yanna elina
can make it easier to execute queries > that CQL does not directly support. Ultimately data is still stored > based on the partition key, so if your query does not specify a > partition key, Calcite will still need to issue an expensive > cross-partition query to Cassandra. > -- > Micha

CassandraAdapter (Add Type) and WHERE statement.

2019-10-16 Thread Yanna elina
Hi guys , I study Calcite the benefits that a Cassandra-Calcite Adapter can bring , as for example brings the possibility of join. the problem type defined into CassandraSchema.getRelDataType(..) is very limited some important type are missing boolean / array ect... I thought inherited from