Re: Requesting information regarding sub-schemas
Hi Alessandro, Thank you. I will reproduce the error and get back to this thread. Regards, Pranav On Wed, Sep 21, 2022 at 1:14 PM Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hi Pranav, > it's helpful to complement what you provided with actual error > messages/stack traces (if any) or at least a detailed description of > expected vs actual behaviour if there is no "apparent" error. > > If you also have a minimal repro, that would definitely be helpful. > > Best regards, > Alessandro > > On Wed, 21 Sept 2022 at 18:52, Pranav Deshpande < > deshpande.v.pra...@gmail.com> wrote: > > > Dear Apache Calcite Dev Team, > > I recently created an in memory schema and table and tried to run queries > > on it using the enumerable and bindable conventions. > > > > By nested schemas I mean this: > > RootSchema has 3 schemas (or sub schemas), schema1, schema2 and schema3. > > Each of these 3 have multiple (but different) tables. > > > > I access them using the "." notation in the sql query. Example select > colA > > from schema1.table1. > > > > The Bindable convention executes them properly but the enumerable > > convention does not. > > > > Could you please give me some pointers on resolving this issue? > > > > Thanks & Regards, > > Pranav > > >
Re: Requesting information regarding sub-schemas
Hi Pranav, it's helpful to complement what you provided with actual error messages/stack traces (if any) or at least a detailed description of expected vs actual behaviour if there is no "apparent" error. If you also have a minimal repro, that would definitely be helpful. Best regards, Alessandro On Wed, 21 Sept 2022 at 18:52, Pranav Deshpande < deshpande.v.pra...@gmail.com> wrote: > Dear Apache Calcite Dev Team, > I recently created an in memory schema and table and tried to run queries > on it using the enumerable and bindable conventions. > > By nested schemas I mean this: > RootSchema has 3 schemas (or sub schemas), schema1, schema2 and schema3. > Each of these 3 have multiple (but different) tables. > > I access them using the "." notation in the sql query. Example select colA > from schema1.table1. > > The Bindable convention executes them properly but the enumerable > convention does not. > > Could you please give me some pointers on resolving this issue? > > Thanks & Regards, > Pranav >
Requesting information regarding sub-schemas
Dear Apache Calcite Dev Team, I recently created an in memory schema and table and tried to run queries on it using the enumerable and bindable conventions. By nested schemas I mean this: RootSchema has 3 schemas (or sub schemas), schema1, schema2 and schema3. Each of these 3 have multiple (but different) tables. I access them using the "." notation in the sql query. Example select colA from schema1.table1. The Bindable convention executes them properly but the enumerable convention does not. Could you please give me some pointers on resolving this issue? Thanks & Regards, Pranav