Thanks Julian for correcting which package should be used. This is not a circular dependency. There should be no problem with a dependency both being required directly by your project and transitively via another dependency. A circular dependency would be if the file adapter required the core code *and* the core code required the file adapter.
-- Michael Mior mm...@apache.org On Mon, Sep 26, 2022 at 12:03 PM Kartik Kudada <kartik.kud...@exate.com.invalid> wrote: > 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 > > >> > > >