When you use authentication cascading, you can change the usage of the following example driver function from:
SELECT * FROM kmeans (
ON (SELECT 1)
PARTITION BY 1
Database ('databasename')
UserID ('userid')
Password ('password')
InputTable ('kmeanssample')
OutputTable (kmeanssample_centroid')
NumberK (3)
Threshold ('0.01')
MaxIterNum ('10')
);
to:
SELECT * FROM kmeans ( ON (SELECT 1) PARTITION BY 1 InputTable ('kmeanssample') OutputTable (kmeanssample_centroid') NumberK (3) Threshold ('0.01') MaxIterNum ('10') );
The following example connects to the database over SSL using authentication cascading:
SELECT * FROM kmeans ( ON (SELECT 1) PARTITION BY 1 SSLSettings ('ENABLESSL=true&SSLTRUSTSTORE= /home/beehive/truststore/truststore.jks') SSLTrustStorePassword ('******') InputTable ('kmeanssample') OutputTable (kmeanssample_centroid') NumberK (3) Threshold ('0.01') MaxIterNum ('10') );