Stack Overflow
Stack Overflow

Questions tagged [dashdb]

IBM Db2 Warehouse on Cloud (formally known as IBM dashDB) is a fully managed data warehousing service in the cloud.

For more information on IBM Db2 Warehouse on Cloud (formally known as IBM dashDB), visit here.

For more information on IBM Db2 Warehouse (formally known as IBM dashDB local), visit here.

226 questions
0
votes
2 answers

dashDB for Bluemix --#SET TERMINATOR @ is not working

By default the statement terminator is ; in dashDB. I want to execute a statement with terminator as @ --#SET TERMINATOR @; CREATE TABLE employee (id INT, name VARCHAR(10), salary DECIMAL(9,2))@ It…
raag
  • 77
  • 8
0
votes
0 answers

Invoking dashdb R Script and getting results externally

I am using the R Script feature on the Bluemix DashDB service. I am able to generate plots and visualize the data on the dashdb console (launched from the Bluemix dashboard). I am wondering how can I make an external piece of code to invoke this R…
mnery
  • 1
  • 2
0
votes
1 answer

XXXX does not exist in the discovered schema. Document has not been imported

When using the SDP to extract data from Cloudant and populate dashDB, I occasionally see error messages in the dashdb "XXXX_OVERFLOW" table that look like this: [XXXX does not exist in the discovered schema. Document has not been…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
2 answers

Error: 'You are not authorized to perform the requested action' when trying to create a warehouse

I'm trying to create a dashDB warehouse from Cloudant. I have provided my IBM ID for Bluemix and Cloudant appears to have logged me on ok, however when I try to create the warehouse I get the following error: Error: provision_dynamite_warehouse: …
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

The value type for json field XXXX was presented as YYYY but the discovered data type of the table's column was ZZZZ

When using the SDP to extract data from Cloudant and populate dashDB, I occasionally see error messages in the dashdb "XXXX_OVERFLOW" table that look like this: EXCEPTION The value type for json field XXXX was presented as java.lang.String but the…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

No matched schema for {"_id":"...","doc":{...}

When using the SDP to extract data from Cloudant and populate dashDB, I occasionally see error messages in the dashdb "XXXX_OVERFLOW" table that look like this: No matched schema for {"_id":"...","doc":{...} Questions What does this error…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

SQL0670N The statement failed because the row size of the resulting table would have exceeded the row size limit

When working with the Cloudant SDP, I have encountered the following error: SQL0670N The statement failed because the row size of the resulting table would have exceeded the row size limit. What does the error mean, and how can I fix it?
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
3 answers

error opening dashDB

After I have added a service dashDB to my Bluemix application and I click on it, I got in IE11 this message: The website declined to show this webpage HTTP 403 When I did the same in the Google crome I got a square head which looked sad. Does…
Karin
  • 1
0
votes
1 answer

how to connect java program into dashdb?

I have created JDBC connection to my schema "DASH104582" and i am using java 7th version and i have download jar file in google and pasted under external_lib folder. This is my connection code…
abarna aruna
  • 11
  • 2
0
votes
1 answer

Which IBM Bluemix service allows you to convert data into an SQL database?

Which IBM Bluemix service allows you to convert data into an SQL database? IBM DB2, object storage, MongoDB by compos, or Apache Spark Boiler Plate?
tejas3006
  • 41
  • 4
0
votes
1 answer

How do you insert non-Cloudant JSON data to dashDB?

How do you insert large quantities of JSON data from a REST API that is not Cloudant into dashDB? bjoern
Bjoern
  • 1
0
votes
1 answer

R Studio 'rworldmap' package installation errors for dashDB

Background: I am creating an app on IBM Bluemix which involves using DashDB. From there I opened R Studio. I am new to R, and I am trying to install rworldmap on R Studio. While installing the same i checked the Install Dependencies button. The…
farhankhwaja
  • 159
  • 7
0
votes
1 answer

Can't launch dashDB from Cloudant - blank screen

Sometimes when I click on the visit warehouse link in Cloudant, I am presented with a blank screen. How can I fix it?
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

how to 'flatten' the table in dashDB created by the schema discovery process (SDP)?

I've used the Cloudant schema discovery process (SDP) to create and populate a table in dashDB. The data in Cloudant is time series in nature: ... { "date": "20150101T00:00:00", "type": "temperature", "reading": "21" } { "date":…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
0
votes
1 answer

How can I debug problems with warehouse creation?

When trying to create a warehouse from the Cloudant dashboard, sometimes the process fails with an error dialog. Other times, the warehouse extraction stays in a state of triggered even after hours. How can I debug this? For example is there an…
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
1 2 3
…
15 16