Make sure to provide the "workload" password for above curl call.
Explore the downloaded zip file to obtain the hbase-site.xml file.
Note down the Phoenix JDBC url from the Phoenix (Thick) tab.
Create table in COD
We would need to create table in COD using Phoenix for this demo. In order to do the same, please login into the gateway node of the COD cluster and run phoenix-sqlline command to create table as follows.
CREATE TABLE OUTPUT_TEST_TABLE (id BIGINT NOT NULL PRIMARY KEY, col1 VARCHAR, col2 INTEGER);
The node details can be obtained from the datahub hardware tab from control plane UI. Following is the screenshot for the same.
Build phoenix-spark project
Build the following Spark phoenix demo maven project.
Upload the demo app jar that was built earlier. cde resource upload --name odx-spark-resource --local-path ./spark-hbase/target/spark-hbase-1.0-SNAPSHOT.jar --resource-path spark-hbase-1.0-SNAPSHOT.jar
Create the CDE job using the following json and import command.