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
1 answer

Error when trying to load tables from desktop with dashDB

I'm trying to load a csv file into a table and receiving the following error: The steps that I am doing are launching the dashDB instance that I have, Load, Load from Desktop, Browse for the csv... I have tried to create a new table from the csv…
Mitts
  • 1
  • 1
0
votes
1 answer

Hibernate - Edit code generated by hbm2ddl.auto property

Is there any way to edit the code generated by the tool hbm2ddl.auto from Hibernate? I ask this because I would like to insert the words ORGANIZE BY ROW in the CREATE TABLE statements generated by hibernate tool.
Islon
  • 5
  • 4
0
votes
1 answer

DashDB - Problems to generate foreign key with Hibernate

I am using the dashDB database service of IBM Bluemix to create a cloud application. Well, when I run my app, as hibernate hbm2ddl.auto property is set to update, it will update my dashDB base. However, the following error appears on the…
Islon
  • 5
  • 4
0
votes
0 answers

How to send email with query results from Node-Red using Yahoo smtp?

I populated dashDB table with data from TI SensorTag and now I want to send myself an email with daily summary. I am trying to create a function on Node-Red to query the table and email the results but I can't figure out how to configure SMTP email…
MichaelV
  • 1
0
votes
1 answer

create schema with dashdb on bluemix

I have the 'small package' of the dashdb service in bluemix. I can't create a new schema. It fails with no authority. I've read on another post that it's a limitation of the 'small package'. My question is: Is this limitation removed on other…
D Krissell
  • 53
  • 3
0
votes
2 answers

execute dashDB jobs from Workload Scheduler

I have created some stored procedures on my dashDB instance on Bluemix, to manipulate data in tables in the same instance. I can run these from Data Studio and they work as intended. Next, I created a process in Workflow Scheduler, which I…
Vivek_Pandey
  • 11
  • 1
0
votes
2 answers

Creation of Flyway "schema_version" fails for dashDB

I'm using Flyway to manage db migration on IBM dashDB. This database organizes by default table content 'by column', which in particular makes the creation of the "schema_version" table fail. To get it to work, the table creation SQL statement…
Nicolas
  • 1
  • 2
0
votes
1 answer

Getting error in bluemix ERS ERRORCODE -4461 SQLSTATE D42815 though the DW is available in Dash DB.

I am getting an error ERRORCODE -4461 SQLSTATE D42815 while trying to create a report specification on bluemix ERS. I used Cloudant NOSQLDb and Dash db. Also Node.js as run time. I followed the https://www.youtube.com/watch?v=i5CmLLEORkM…
Rawikirran Manchi Sarraf
  • 1
0
votes
1 answer

How to view/access database data in dashDB?

How do you view and access database data in dashDB to show it in a different web page? I'm using Insights for Twitter to analyze the data on a Web-based app.
Haifaabdul
  • 1
0
votes
1 answer

How can I send R code containing the % symbol to IBM dashDB?

I'm trying to send and execute an R script to the IBM dashDB REST endpoint based on the tutorial. Everything works quite nice but when I use the following code timestamp=as.numeric(strptime(df$TIMESTAMP, \"%Y-%m-%d %H:%M:%S.000000\")); The dashDB…
Romeo Kienzler
  • 3,373
  • 3
  • 36
  • 58
0
votes
1 answer

Cognos Analytics support for column organized table

Are there any compatibility issues with Congos Analytics and column-organized tables? I am getting the following error message from the Framework manager when I try to view data in a DashDB instance..... Data source adapter error:…
Steve L
  • 1
0
votes
1 answer

dashDB service not repsonding?

Last night, I was receiving memory issues for some of my queries (inner joins on multiple tables) against my dashDB service on Bluemix. Today, I cannot even access the dashDB service. When I access my project instance on Bluemix, using my web…
Dan
  • 1
0
votes
2 answers

How to connect to Bluemix dashDB outside the Bluemix environment

I have several tables in dashDB and I want to access them from another server in order to filter out the data and insert it to a database on my own server. In dashDB, there is a Service Credentials section and I clicked "Add Credentials" and it…
Rain Man
  • 1,163
  • 2
  • 16
  • 49
0
votes
0 answers

Cannot load ggmap package successfully in case of dashDB / R

I tried to develop hands-on materials for R with dashDB. I want to use ggmap package to work with geospatial data, so I typed "install.packages("ggmap")" on RStudio provided by Bluemix. I got the following result. I found the pre-installed package…
S.Imaz
  • 25
  • 4
0
votes
2 answers

How to executing arbitrary sql from pyspark notebook using SQLContext?

I'm trying a basic test case of reading data from dashDB into spark and then writing it back to dashDB again. Step 1. First within the notebook, I read the data: sqlContext = SQLContext(sc) dashdata = sqlContext.read.jdbc( …
Chris Snow
  • 23,813
  • 35
  • 144
  • 309
1 2 3
…
15 16