Yes, this is possible. Your implementation of Schema.getTable(String name) should always return the same Table object. When that Table object is used (e.g. when it is wrapped in a RelOptTableImpl), Calcite will supply the path.
Julian > On Aug 13, 2016, at 1:00 AM, Ravikumar CS <[email protected]> wrote: > > Hi, > > Is it possible to query dynamic tables within a table schema in Calcite ? > That is the table name is coming as part of the SQL(and is changing) > however they all map to the same calcite table implementation(say > JSONTable) ? > > Any pointers on how this could be achieved. > > *Example:* > > *1.* select * from foo_schema."/data/foo.json" > > *2. *select * from foo_schema."/data/bar.json" > > *3.* select * from foo_schema."/data/baz.json"
