Thanks for the quick response.
org.apache.calcite.adapter.csv is in the file module.
I tried to add example and file module in core's build.gradle.kts but that
results in circular dependency as file's build.gradle.kts also has core
dependency.
Core's build.gradle.kts
api(project(":example"))
api(project(":file"))
Regards,
Kartik
On Mon, Sep 26, 2022 at 9:18 PM Julian Hyde <jhyde.apa...@gmail.com> wrote:
> Or, better, the file adapter. It also handles CSV files and is not “toy”
> code.
>
> Julian
>
> > On Sep 26, 2022, at 08:20, Michael Mior <mm...@apache.org> wrote:
> >
> > Do you have the calcite-csv package as a dependency of your project?
> This
> > must be added in addition to calcite-core.
> > --
> > Michael Mior
> > mm...@apache.org
> >
> >
> >> On Mon, Sep 26, 2022 at 10:37 AM Kartik Kudada
> >> <kartik.kud...@exate.com.invalid> wrote:
> >>
> >> Hi Calcite Developers,
> >>
> >> I am working on a requirement where user queries to RDMS database and
> >> under the hood, Calcite will send back the data from JSON, not from
> RDMS.
> >>
> >> For this, I have added below code snippet in CalciteStatement execute
> >> method to add CSV schema runtime.
> >>
> >> sample code :
> >>
> >> final Schema schema =
> >> CsvSchemaFactory.INSTANCE
> >> .create(connection.getRootSchema(), null,
> >> ImmutableMap.of("directory",
> >> "EMPS.json", "flavor", "scannable"));
> >>
> >> connection.getRootSchema().add("mycsv", schema);
> >>
> >> So, when the user query "SELECT * FROM <RDMS>.EMPS" converts to
> >> "SELECT * FROM \"mycsv\".EMPS"
> >>
> >> The above code says *package org.apache.calcite.adapter.csv does not
> >> exist,*
> >>
> >> I am trying to fix it for 5 hours.
> >> How to do this?
> >>
> >> Regards,
> >> Kartik
> >>
>
