Re: CsvAdapter (Json content) from String / InputStream

2019-12-05 Thread Andrei Sereda
Pls see CALCITE-3560 [1] which was merged recently. You can now instantiate Source from a generic CharSource [2]: Source source = Sources.fromCharSource(CharSource.wrap("hello")); This should be released with 1.22 [1] https://issues.apache.org/jira/browse/CALCITE-3560

Re: CsvAdapter (Json content) from String / InputStream

2019-11-19 Thread Yanna elina
Hi guys , i have another question about this adapter. I have a json sample like this : [ { "field": "test", "properties": [ "a", "b", "c" ] } ] JsonTable look like to convert Array to OTHER ColumType . the column "properties" is converted on ' when i check

Re: CsvAdapter (Json content) from String / InputStream

2019-11-18 Thread Yanna elina
Big Thank Guys !!! Even if this CSVAdapter is an "example" its still really usefull :) and with this update it will be a good "out of box" tools usable in many scenario/workflow Yanna Le jeu. 14 nov. 2019 à 21:20, Andrei Sereda a écrit : > > I see that this feature request relates to

Re: CsvAdapter (Json content) from String / InputStream

2019-11-14 Thread Andrei Sereda
> I see that this feature request relates to Source.java and Sources.java, which are in org.apache.calcite.util in core. I'm not planning to change Source.java it already exposes Reader / InputStream > If you add some capability, it is fine to add It to the CSV adapter example, but it is much

Re: CsvAdapter (Json content) from String / InputStream

2019-11-14 Thread Julian Hyde
I see that this feature request relates to Source.java and Sources.java, which are in org.apache.calcite.util in core. If you add some capability, it is fine to add It to the CSV adapter example, but it is much more important that that capability exists in the file adapter. Julian > On Nov

Re: CsvAdapter (Json content) from String / InputStream

2019-11-14 Thread Andrei Sereda
I think the change is straightforward (will not add complexity). 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 CSV files. > > Julian > > > > > On Nov 14, 2019, at 9:40 AM, Andrei

Re: CsvAdapter (Json content) from String / InputStream

2019-11-14 Thread Julian Hyde
Remember that CsvAdapter is in the “example” module. Keep it simple. The file adapter can also parse CSV files. Julian > On Nov 14, 2019, at 9:40 AM, Andrei Sereda wrote: > > Hello, > > Source object already exposes Reader / InputStream API. Probably > JsonEnumerator can be changed to use

Re: CsvAdapter (Json content) from String / InputStream

2019-11-14 Thread Andrei Sereda
Hello, Source object already exposes Reader / InputStream API. Probably JsonEnumerator can be changed to use those methods. Do you mind creating a JIRA ticket ? I'll take a look. Thanks, Andrei. On Thu, Nov 14, 2019 at 7:45 AM Yanna elina wrote: > Hi guys , > I saw in the code that this nice

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