Test Yugabyte Cloud QL (YCQL) API

    After creating a local cluster, follow the instructions below to test YugabyteDB’s Cassandra-compatible YCQL API.

    • Run cqlsh to connect to the service.
    2. [cqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
    3. Use HELP for help.
    4. cqlsh>
    • Run a cql command to verify it is working.
    1. cqlsh> describe keyspaces;
    1. system_schema  system_auth  system
    3. cqlsh>
    • Run cqlsh to connect to the service.
    1. $ ./bin/cqlsh localhost
    1. Connected to local cluster at 127.0.0.1:9042.
    2. [cqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
    3. Use HELP for help.
    • Run a cql command to verify it is working.
    1. cqlsh> describe keyspaces;
    1. system_schema  system_auth  system
    3. cqlsh>
    • Run cqlsh to connect to the service.
    1. Connected to local cluster at 127.0.0.1:9042.
    3. Use HELP for help.
    4. cqlsh>
    • Run a cql command to verify it is working.
    1. cqlsh> describe keyspaces;
    2. system_schema  system_auth  system
    4. cqlsh>
    • Run cqlsh to connect to the service.
    1. $ kubectl exec -it yb-tserver-0 /home/yugabyte/bin/cqlsh
    1. Connected to local cluster at 127.0.0.1:9042.
    2. [cqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
    3. Use HELP for help.
    4. cqlsh>
    • Run a cql command to verify it is working.
      1. system_schema  system_auth  system
      3. cqlsh>

      Create a keyspace called ‘myapp’.

      1. cqlsh> CREATE TABLE myapp.stock_market (
      3.   ts text,
      4.   current_price float,
      5.   PRIMARY KEY (stock_symbol, ts)
      6. );

      Let us insert some data for a few stock symbols into our newly created ‘stock_market’ table. You can copy-paste these values directly into your cqlsh shell.

      1. cqlsh> INSERT INTO myapp.stock_market (stock_symbol,ts,current_price) VALUES ('AAPL','2017-10-26 09:00:00',157.41);
      2. INSERT INTO myapp.stock_market (stock_symbol,ts,current_price) VALUES ('AAPL','2017-10-26 10:00:00',157);
      1. cqlsh> INSERT INTO myapp.stock_market (stock_symbol,ts,current_price) VALUES ('FB','2017-10-26 09:00:00',170.63);
      2. INSERT INTO myapp.stock_market (stock_symbol,ts,current_price) VALUES ('FB','2017-10-26 10:00:00',170.1);
      1. cqlsh> INSERT INTO myapp.stock_market (stock_symbol,ts,current_price) VALUES ('GOOG','2017-10-26 09:00:00',972.56);
      2. INSERT INTO myapp.stock_market (stock_symbol,ts,current_price) VALUES ('GOOG','2017-10-26 10:00:00',971.91);
      1. cqlsh> SELECT * FROM myapp.stock_market WHERE stock_symbol = 'AAPL';
      1.  stock_symbol | ts                  | current_price
      2. --------------+---------------------+---------------
      3.          AAPL | 2017-10-26 09:00:00 |        157.41
      4.          AAPL | 2017-10-26 10:00:00 |           157
      6. (2 rows)

      Query all the values for ‘FB’ and ‘GOOG’ as follows.