Back to all discussions

  •   about 11 years ago

Querying cloudant database

Hi All,

I am have a dashdb schema called DASH102165 with a single table called toronto_water_properties.
I am trying to query the table with the query:

SELECT * FROM DASH102165.toronto_water_properties;

I am getting the error:

SELECT * FROM DASH102165.toronto_water_properties
"DASH102165.TORONTO_WATER_PROPERTIES" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.66.46

I am really not sure how to fix this error? Can anyone help please.

  • 1 comment

  • Manager   •   about 11 years ago

    Hello,

    Really happy to see the first post about this mini-hack!

    Where are you running this query from? Inside dashDB, or is it through a program you've created? Can you send a screenshot? By the way, the title of your post is a bit misleading. You are querying the dashDB database which is a relational database. The Cloudant database is not a relational database but a nosql db. The data from Cloudant is automatically synchronize to the dashDB database.

    Cheers, Raul

Comments are closed.