Cassandra
Provides access to Apache Cassandra database using SQL queries via JDBC driver.
Connection parameters
{
"server": "",
"port": "",
"db": "",
"connString": ""
}
Supported Parameters (1)
Type | Value | Description or Example |
---|---|---|
num , int , double | = | =100 |
> | >1.02 | |
>= | >=4.1 | |
<= | <=100 | |
!= | !=5 | |
in | in (1, 3, 10.2) | |
min-max | 1.5-10.0 | |
string | contains | contains ea |
starts with | starts with R | |
ends with | ends with w | |
in | in (ab, "c d", "e\"f\"") | |
datetime | before | before 1/1/2022 |
after | after 1/1/2022 | |
today | ||
this week | ||
this month | ||
this year | ||
last year | ||
min-max | ||
April 2021 |
- (1) If you want to use parameterized queries, you need to add
ALLOW FILTERING
which can lead to sirius performance penalties. Moreover, to be able to use string patterns you need to create secondary indexes for columns in where clause. See documentation.
Supported output types
Type | Supported |
---|---|
text | ✅ |
tinyint, smallint, int, bigint, varint | ✅ |
decimal, float, double | ✅ |
boolean | ✅ |
date, timestamp, time | ✅ |
uuid | ✅ |
duration | ✅ (1) |
map, list, set, udt | ✅ (1) |
blob | limited support (2) |
- (1) supported as a string
- (2) you get unreadable representation, but in query you can cast such a types to varchar, hex
Supported features
- Schema browsing
- Connection test
See also: