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.

  1. 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
  2. From the Databases page, download HBase client configuration Zip file using the client configuration URL .
  3. From the Databases page, copy the JDBC connection URL for the Phoenix (Thick) or Phoenix (Thin) client to use in the next step.
  4. 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