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

Query Tuning in Dashdb

id timestamp status 167 6/28/2016 8:05:58 PM 0 167 6/28/2016 8:06:02 PM 0 167 6/28/2016 8:06:05 PM 0 167 6/28/2016 8:08:06 PM 0 167 6/28/2016 8:08:10 PM 0 167 6/28/2016 8:08:13 PM 3 167 6/28/2016 8:08:17 PM 3 167…
Lohith Kumar
  • 1
0
votes
1 answer

Bluemix Cloudant Incremental Data Push

I am using Bluemix data services for some of our large data processing tasks. The raw data comes into Cloudant and we are pushing this to DashDB using the warehouse service with in cloudant and it pushes data to dashDB. When the warehouse runs it…
user3912976
  • 33
  • 1
  • 8
0
votes
2 answers

Does DashDB row organized tables support CLOBS?

We are trying to store large CLOBS into a DashDB for analytics. Yes, the table that has been created is row organized. CREATE TABLE test( KEY VARCHAR(1000) NOT NULL, MP3_FILE CLOB(250M) NOT NULL, PRIMARY KEY(KEY) ) ORGANIZE BY ROW; Even…
Aaron B
  • 173
  • 7
0
votes
1 answer

dashDB API call fails

I have created and interacted with a dashDB instance in IBM Bluemix through the web application but when I try the following curl command, from the dashDB API documentation : curl --user "[userid]:[password]" -X GET…
and_apo
  • 1,217
  • 3
  • 17
  • 41
0
votes
2 answers

DSX PySpark writing data to dashDB with Custom JDBC dialect

In IBM Bluemix I have created a DSX PySpark notebook, with Python 2.6 and Spark 2.0. I am using IBM dashDB as my data storage. I can authenticate and read tables successfully but when I try to write back to a new table I was getting this exact same…
and_apo
  • 1,217
  • 3
  • 17
  • 41
0
votes
3 answers

Connecting RStudio to DashDB in the IBM Watson Studio

How do I connect R Studio to DashDb inside IBM Watson Studio?
Shad Griffin
  • 11
  • 1
0
votes
1 answer

Can not run sample R/dashDB script "Server Memory Usage"

Tried to run the server memory usage sample script as advised in the Youtube video: https://www.youtube.com/watch?v=PtEfRv_xuOA. Clicked on "Analytics" Clicked on "R Scripts" Clicked on "Server Memory Usage" I don't get any plot, only console…
jpsstack
  • 1,221
  • 4
  • 18
  • 29
0
votes
1 answer

DB2 CTAS Token Error

I am trying to use a CTAS statement in DB2 version 11.1.0 which creates a new table and inserts it. The query is the following: CREATE TABLE MY_SCRATCH.LC$U7OB81478732948714_zero_to_3 AS ( WITH two AS (SELECT id AS the_num FROM users…
theGreenCabbage
  • 5,197
  • 19
  • 79
  • 169
0
votes
2 answers

Duplicating a table in dashDB

I want to create a duplicate table in dashDB (with or without the original data, it does not really matter, the table structure is what is important). I tried: SELECT * INTO new_table FROM old_table; but I get this error: "new_table" is not…
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
1 answer

IBM dashDB sql statement for "insert row if not already existing"

I am currently working with the IBM dashDB and I need to know the sql statement for inserting a new row if this row does not already exist based to certain criteria. So, something like this: INSERT INTO tablexyz (Col1, Col2, Col3) VALUES (val1,…
Fabian Gautschi
  • 1
0
votes
1 answer

Selecting Grouped Records based on max value in a column

I cannot get my head around this one, I have a "funcky" subquery: SELECT "Requisition_ID", "Candidate_ID", "Application_Date", CA."Process_of_Activity", CA."Activity", "Completed_on", add_minutes(cast("Completed_on" as…
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
3 answers

adding a VARCHAR to DATE as MINUTES

I'm pretty sure this is an easy one for you guys but it's driving me crazy. I have a column with dates in a "YYYY-MM-DD" format and a column with small intergers values between 0 and 29. So I want to add the 2 columns together and get something like…
Mike Pala
  • 766
  • 1
  • 11
  • 39
0
votes
1 answer

Rake / adapter error during Rails 5 app deploy on Bluemix

I'm trying to deploy Rails 5 app with DashDB service on IBM Bluemix platform. According to the logs everything seems to be working fine during the deployment stage until rake command is being triggered: ... OUT Starting app instance (index 0)…
Kociamber
  • 1,048
  • 8
  • 16
0
votes
2 answers

cloudant dashdb sync issue

We have created a warehouse with source database in cloudant, We had ran schema discovery process on near about 40,000 records initially.Our cloudant database consist of around 2 millions records. Now the issue we are facing is that we have got many…
Anupam Gupta
  • 1
  • 1
0
votes
1 answer

what is use of warehouse db like dashDb?

If we choose nosql database as a cloudant db then why need of warehouse dashdb? Is this useful to handle large non-sql data and service will connect to ware house instead of cloudant.
Vimal Dhaduk
  • 994
  • 2
  • 18
  • 43
1 2 3
…
15 16