Cloudera Operational Database SQLLine access
SQLLine is a command-line utility included with Cloudera Operational Database (COD) that enables you to connect and execute SQL commands using Phoenix from an edge node.
-
Download phoenix-client.jar for your thick or thin clients using this URL
syntax.
You can get the [*Phoenix Maven URL*], [*Phoenix_(Thin)_Client_Version*], and the [*<Phoenix_(Thick)_Client_Version> *] information from the Database connectivity page. The URL is in the following format:
For the Phoenix thick client:
[***Phoenix MAVEN URL***]/org/apache/phoenix/phoenix-client/ [***Phoenix THICK CLIENT VERSION***]/phoenix-client-[***Phoenix THICK CLIENT VERSION***].jar
For the Phoenix thin client:
[***Phoenix MAVEN URL***]/org/apache/phoenix/phoenix-client/ [***Phoenix THIN CLIENT VERSION***]/phoenix-client-[***Phoenix THIN CLIENT VERSION***].jar
-
From the Databases page, download HBase client configuration Zip file using the
client configuration URL .
- From the Databases page, copy the JDBC connection URL for the Phoenix (Thick) or Phoenix (Thin) client to use in the next step.
-
Run this command from your CLI:
java $PHOENIX_OPTS -cp "[***HBase-CONFIGURATION***]:[***PHOENIX-CLIENT-JAR**]]" sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u [***JDBC-CONNECTION_URL***] -n none -p none --color=true --fastConnect=false --verbose=true --incremental=false --isolation=TRANSACTION_READ_COMMITTED