You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by Adeel Qureshi <ad...@gmail.com> on 2015/06/29 16:38:46 UTC

table not found with calcite

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

Re: table not found with calcite

Posted by Julian Hyde <jh...@apache.org>.

Thanks Dan. I did a quick search and applied the tag to a few existing questions. I also revised the description (still awaiting review).

http://stackoverflow.com/questions/tagged/calcite 

Julian

On Jul 17, 2015, at 10:55 PM, Dan <da...@dankeeley.co.uk> wrote:

> I have created the tag - Probably needs better description :) I Was going
> to steal some text from the website but left it at that.
> 
> On 6 July 2015 at 22:37, Julian Hyde <jh...@apache.org> wrote:
> 
>>> On a side note - shouldn't there be an apache calcite or optiq tag in
>>> stackoverflow.
>> 
>> +1
>> 
>> It should be called “calcite”. The description of the tag can make clear
>> that we are talking about Apache Calcite (incubating).
>> 
>>> I dont have enough reputation points to create one.
>> 
>> Me neither. Can anyone help?
>> 
>> Julian
>> 
>>

Re: table not found with calcite

Posted by Dan <da...@dankeeley.co.uk>.

I have created the tag - Probably needs better description :) I Was going
to steal some text from the website but left it at that.

On 6 July 2015 at 22:37, Julian Hyde <jh...@apache.org> wrote:

> > On a side note - shouldn't there be an apache calcite or optiq tag in
> > stackoverflow.
>
> +1
>
> It should be called “calcite”. The description of the tag can make clear
> that we are talking about Apache Calcite (incubating).
>
> > I dont have enough reputation points to create one.
>
> Me neither. Can anyone help?
>
> Julian
>
>

Re: table not found with calcite

Posted by Julian Hyde <jh...@apache.org>.

> On a side note - shouldn't there be an apache calcite or optiq tag in
> stackoverflow.

+1

It should be called “calcite”. The description of the tag can make clear that we are talking about Apache Calcite (incubating).

> I dont have enough reputation points to create one.

Me neither. Can anyone help?

Julian

Re: table not found with calcite

Posted by Adeel Qureshi <ad...@gmail.com>.

Thanks Milinda

On a side note - shouldn't there be an apache calcite or optiq tag in
stackoverflow. I dont have enough reputation points to create one.

On Mon, Jun 29, 2015 at 11:04 AM, Milinda Pathirage <mp...@umail.iu.edu>
wrote:

> 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 <ad...@gmail.com>
> 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
>

Re: table not found with calcite

Posted by Milinda Pathirage <mp...@umail.iu.edu>.

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 <ad...@gmail.com>
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