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 Databases page.
For the Phoenix thin client:
```
<Phoenix Maven URL>/org/apache/phoenix/phoenix-queryserver-client/
<Phoenix_(Thin)_Client_Version>/phoenix-queryserver-client-<Phoenix_(Thin)_Client_Version>.jar 
```
For the Phoenix thin client:
```
<Phoenix Maven URL>/org/apache/phoenix/phoenix-client/
<Phoenix_(Thick)_Client_Version>/phoenix-client-<Phoenix_(Thick)_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