In our setup, below connection to database says Cassandra-3.9
[root@8d520 yugabyte]# ycqlsh 10.xx.xx.2 -u user -p passwd --ssl
Connected to local cluster at 10.xx.xx.x:9042.
[ycqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
Use HELP for help.
user@ycqlsh> DESCRIBE KEYSPACES;
system_schema system_auth system
I have been told that the database is yugabyteDB.
Yugaware GUI interface shows table as YCQL type
Why database type shown as Cassandra-3.9, in the above command? How to verify, if database is yugabyteDB or CassandraDB?
What is the difference between YSQL type table and YCQL type table?
The database is YugabyteDB. It supports two APIs - YCQL (apache Cassandra compatible) and YSQL (PostgreSQL compatible). The above means that you created a cluster, and in it created 3 YCQL tables (apache Cassandra compatible).
This FAQ on API compatibility may be useful for you.
The client isn’t yet smart enough like in YCQL to directly route queries to the correct server: Cluster aware driver for YSQL · Issue #7880 · yugabyte/yugabyte-db · GitHub
Does load balancer route queries to correct server(shard owner)?
If no, how queries are routed to correct shard owner?
What do you mean by “load balancer”?
If an external one, then any yb-tserver will execute any query and do routing internally.