Connecting to AlwaysOn SQL server using Beeline

Use Spark Beeline to test AlwaysOn SQL.

You can use Shark Beeline to test AlwaysOn SQL.

Procedure

  1. Start AlwaysOn SQL.
  2. Start the Beeline shell.
    dse beeline
  3. Connect to the server using the JDBC URI for your server.
    beeline> !connect jdbc:hive2://localhost:10000
  4. Connect to a keyspace and run a query from the Beehive shell.
    0: jdbc:hive2://localhost:10000> use test;
    0: jdbc:hive2://localhost:10000> select * from test;