Display Supported CQL Version

Having its roots in the Cassandra Query Language (CQL), the Yugabyte Cloud Query Language (YCQL) is a semi-relational SQL API that is best fit for internet-scale OLTP and HTAP applications needing massive data ingestion and blazing-fast queries.

If you need to check which CQL version is supported by your current version of YugabyteDB, you can try any of the following options…

First, when you launch the ycqlsh client, the banner displays the CQL version:

				
					[root@localhost ~]# ycqlsh
Connected to local cluster at 127.0.0.1:9042.
[ycqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
Use HELP for help.
				
			

Second, the SHOW VERSION command will display the same banner as was displayed after launching ycslsh:

				
					ycqlsh> SHOW VERSION;
[ycqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
				
			

Third, you can query the SYSTEM.LOCAL table…

				
					yugabyte@ycqlsh> SELECT cql_version FROM system.local;

 cql_version
-------------
       3.4.2

(1 rows)
				
			

Have Fun!