search

cloudant-labs / data-flow-examples

Examples extracting data from Cloudant and writing it elsewhere
4 stars 4 forks source link

How to make custom table in Cloudant to Db2 in Spark using Watson Studio ? #20

Closed ZaheerUdDeen closed 6 years ago

ZaheerUdDeen commented 6 years ago

I want to make a table in Db2 warehouse for the give (document screenShot) in Spark using Watson studio. image The table cloumn name should be the content(invNumber,salePrice..) json object in 'totalInvoice' JsonArray.

Secondly: If I want to do the same job with node-red how can I do that?

ricellis commented 6 years ago

i) Spark Unpacking arrays and objects with Spark is documented in this example. Further the SaveMode options available for Spark to CREATE TABLE are also documented.

ii) Node-RED It is stated in this repository's documentation that Node-RED has only an INSERT statement for the Db2 sink. If you want to do more complicated actions, like CREATE TABLE you'll want to find and install or create some other Node-RED nodes. That is outside of the scope of what we've done here and we can't provide help with that.

Please only raise issues here if you find a bug when working through the tutorials. Cloudant are unable to provide support for all the IBM Cloud services used in these tutorials.