Hi Adeel, This has something to do with case sensitivity. But I don't know how to change these settings for JDBC style invocation of Calcite. I tried your test after renaming a.json to A.json. Then your test worked (even though gradle still reported test as failed). According to [1] we can prevent upper casing table identifiers in query by quoting them in the query.
Thanks Milinda [1] https://issues.apache.org/jira/browse/CALCITE-34 On Mon, Jun 29, 2015 at 10:38 AM, Adeel Qureshi <[email protected]> wrote: > I am trying to setup a simple project to understand calcite framework. The > goal is to create tables from JSON files in a directory and read the data > using SQL. I posted a question on StackOverflow for a problem I am running > into but apparently there are no calcite or optiq tags available so I doubt > that I will get my question answered there. > > Here is the link to my StackOverflow question. I would appreciate any help. > > http://stackoverflow.com/questions/31118348/table-not-found-with-apache-calcite > > Thanks > -- Milinda Pathirage PhD Student | Research Assistant School of Informatics and Computing | Data to Insight Center Indiana University twitter: milindalakmal skype: milinda.pathirage blog: http://milinda.pathirage.org
