You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Hemant Saxena <h2...@uwaterloo.ca> on 2016/05/08 15:30:02 UTC
MongoDB adapter: Table 'mongo_raw.zips' not found
Hello,
I am trying out the MongoDB adapter tutorial mentioned here
https://calcite.apache.org/docs/howto.html#mongodb-adapter
Data is successfully loaded to MongoDB, db.zips.find().limit(3) return
three entries.
However, when I connect to MongoDB zips schema as shown in the tutorial and
run '!tables' command I see the following output:
+-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_CAT |
TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
+-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
| | metadata | COLUMNS | SYSTEM_TABLE | |
| | | | |
2016-05-08 11:13:41,627 [main] ERROR -
org.apache.calcite.sql.validate.SqlValidatorException: Table
'mongo_raw.zips' not found
2016-05-08 11:13:41,629 [main] ERROR -
org.apache.calcite.runtime.CalciteContextException: From line 2, column 213
to line 2, column 230: Table 'mongo_raw.zips' not found
org.apache.calcite.runtime.CalciteContextException: From line 2, column 213
to line 2, column 230: Table 'mongo_raw.zips' not found
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
. . .
. . .
Any help on this will be appreciated.
Thanks,
Hemant
Re: MongoDB adapter: Table 'mongo_raw.zips' not found
Posted by Hemant Saxena <h2...@uwaterloo.ca>.
Sure. Thanks, Michael.
On Sun, May 8, 2016 at 8:59 PM, Michael Mior <mm...@uwaterloo.ca> wrote:
> Hemant,
>
> I've been doing a fair bit of Calcite development lately. If you'd like,
> come by my office sometime tomorrow and I can help you get set up :) I have
> a class from 12:30-1:30 but I should be around the rest of the day.
>
> Cheers,
> --
> Michael Mior
> mmior@uwaterloo.ca
>
> 2016-05-08 20:44 GMT-04:00 Hemant Saxena <h2...@uwaterloo.ca>:
>
> > Calcite version 1.7.0
> > MongoDB version 3.2.6
> >
> > Thanks,
> > Hemant
> >
> > On Sun, May 8, 2016 at 8:17 PM, Josh Elser <jo...@gmail.com> wrote:
> >
> > > Hi Hemant,
> > >
> > > What version of Calcite are you using? That would be helpful for
> someone
> > > to try looking into this further.
> > >
> > > - Josh
> > >
> > >
> > > Hemant Saxena wrote:
> > >
> > >> Hello,
> > >>
> > >> I am trying out the MongoDB adapter tutorial mentioned here
> > >> https://calcite.apache.org/docs/howto.html#mongodb-adapter
> > >> Data is successfully loaded to MongoDB, db.zips.find().limit(3) return
> > >> three entries.
> > >> However, when I connect to MongoDB zips schema as shown in the
> tutorial
> > >> and
> > >> run '!tables' command I see the following output:
> > >>
> > >>
> > >>
> >
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
> > >> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS |
> > TYPE_CAT |
> > >> TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
> > >>
> > >>
> >
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
> > >> | | metadata | COLUMNS | SYSTEM_TABLE | |
> > >> | | | |
> > |
> > >> 2016-05-08 11:13:41,627 [main] ERROR -
> > >> org.apache.calcite.sql.validate.SqlValidatorException: Table
> > >> 'mongo_raw.zips' not found
> > >> 2016-05-08 11:13:41,629 [main] ERROR -
> > >> org.apache.calcite.runtime.CalciteContextException: From line 2,
> column
> > >> 213
> > >> to line 2, column 230: Table 'mongo_raw.zips' not found
> > >> org.apache.calcite.runtime.CalciteContextException: From line 2,
> column
> > >> 213
> > >> to line 2, column 230: Table 'mongo_raw.zips' not found
> > >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> > >> at
> > >>
> > >>
> >
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> > >> . . .
> > >> . . .
> > >>
> > >> Any help on this will be appreciated.
> > >>
> > >> Thanks,
> > >> Hemant
> > >>
> > >>
> >
>
Re: MongoDB adapter: Table 'mongo_raw.zips' not found
Posted by Michael Mior <mm...@uwaterloo.ca>.
Hemant,
I've been doing a fair bit of Calcite development lately. If you'd like,
come by my office sometime tomorrow and I can help you get set up :) I have
a class from 12:30-1:30 but I should be around the rest of the day.
Cheers,
--
Michael Mior
mmior@uwaterloo.ca
2016-05-08 20:44 GMT-04:00 Hemant Saxena <h2...@uwaterloo.ca>:
> Calcite version 1.7.0
> MongoDB version 3.2.6
>
> Thanks,
> Hemant
>
> On Sun, May 8, 2016 at 8:17 PM, Josh Elser <jo...@gmail.com> wrote:
>
> > Hi Hemant,
> >
> > What version of Calcite are you using? That would be helpful for someone
> > to try looking into this further.
> >
> > - Josh
> >
> >
> > Hemant Saxena wrote:
> >
> >> Hello,
> >>
> >> I am trying out the MongoDB adapter tutorial mentioned here
> >> https://calcite.apache.org/docs/howto.html#mongodb-adapter
> >> Data is successfully loaded to MongoDB, db.zips.find().limit(3) return
> >> three entries.
> >> However, when I connect to MongoDB zips schema as shown in the tutorial
> >> and
> >> run '!tables' command I see the following output:
> >>
> >>
> >>
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
> >> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS |
> TYPE_CAT |
> >> TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
> >>
> >>
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
> >> | | metadata | COLUMNS | SYSTEM_TABLE | |
> >> | | | |
> |
> >> 2016-05-08 11:13:41,627 [main] ERROR -
> >> org.apache.calcite.sql.validate.SqlValidatorException: Table
> >> 'mongo_raw.zips' not found
> >> 2016-05-08 11:13:41,629 [main] ERROR -
> >> org.apache.calcite.runtime.CalciteContextException: From line 2, column
> >> 213
> >> to line 2, column 230: Table 'mongo_raw.zips' not found
> >> org.apache.calcite.runtime.CalciteContextException: From line 2, column
> >> 213
> >> to line 2, column 230: Table 'mongo_raw.zips' not found
> >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> >> at
> >>
> >>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> >> . . .
> >> . . .
> >>
> >> Any help on this will be appreciated.
> >>
> >> Thanks,
> >> Hemant
> >>
> >>
>
Re: MongoDB adapter: Table 'mongo_raw.zips' not found
Posted by Hemant Saxena <h2...@uwaterloo.ca>.
Calcite version 1.7.0
MongoDB version 3.2.6
Thanks,
Hemant
On Sun, May 8, 2016 at 8:17 PM, Josh Elser <jo...@gmail.com> wrote:
> Hi Hemant,
>
> What version of Calcite are you using? That would be helpful for someone
> to try looking into this further.
>
> - Josh
>
>
> Hemant Saxena wrote:
>
>> Hello,
>>
>> I am trying out the MongoDB adapter tutorial mentioned here
>> https://calcite.apache.org/docs/howto.html#mongodb-adapter
>> Data is successfully loaded to MongoDB, db.zips.find().limit(3) return
>> three entries.
>> However, when I connect to MongoDB zips schema as shown in the tutorial
>> and
>> run '!tables' command I see the following output:
>>
>>
>> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
>> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_CAT |
>> TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
>>
>> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
>> | | metadata | COLUMNS | SYSTEM_TABLE | |
>> | | | | |
>> 2016-05-08 11:13:41,627 [main] ERROR -
>> org.apache.calcite.sql.validate.SqlValidatorException: Table
>> 'mongo_raw.zips' not found
>> 2016-05-08 11:13:41,629 [main] ERROR -
>> org.apache.calcite.runtime.CalciteContextException: From line 2, column
>> 213
>> to line 2, column 230: Table 'mongo_raw.zips' not found
>> org.apache.calcite.runtime.CalciteContextException: From line 2, column
>> 213
>> to line 2, column 230: Table 'mongo_raw.zips' not found
>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>> at
>>
>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>> . . .
>> . . .
>>
>> Any help on this will be appreciated.
>>
>> Thanks,
>> Hemant
>>
>>
Re: MongoDB adapter: Table 'mongo_raw.zips' not found
Posted by Josh Elser <jo...@gmail.com>.
Hi Hemant,
What version of Calcite are you using? That would be helpful for someone
to try looking into this further.
- Josh
Hemant Saxena wrote:
> Hello,
>
> I am trying out the MongoDB adapter tutorial mentioned here
> https://calcite.apache.org/docs/howto.html#mongodb-adapter
> Data is successfully loaded to MongoDB, db.zips.find().limit(3) return
> three entries.
> However, when I connect to MongoDB zips schema as shown in the tutorial and
> run '!tables' command I see the following output:
>
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_CAT |
> TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION |
> +-----------+-------------+------------+------------+---------+----------+------------+-----------+---------------------------+----------------+
> | | metadata | COLUMNS | SYSTEM_TABLE | |
> | | | | |
> 2016-05-08 11:13:41,627 [main] ERROR -
> org.apache.calcite.sql.validate.SqlValidatorException: Table
> 'mongo_raw.zips' not found
> 2016-05-08 11:13:41,629 [main] ERROR -
> org.apache.calcite.runtime.CalciteContextException: From line 2, column 213
> to line 2, column 230: Table 'mongo_raw.zips' not found
> org.apache.calcite.runtime.CalciteContextException: From line 2, column 213
> to line 2, column 230: Table 'mongo_raw.zips' not found
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> . . .
> . . .
>
> Any help on this will be appreciated.
>
> Thanks,
> Hemant
>