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 .

note
You cannot download the client configuration file using a web browser. You must copy and paste the HBase client configuration URL to your CLI to download this file. For example, curl -O -u "csso_username" "https://download 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