Static type in Cassandra

In this article, we will discuss a static column in which we will able to understand how the static column is useful and what is the actual role. Let’s have a look.

Static column:
In Cassandra Query Language (CQL) it is a special column that is shared by all the rows of a partition. the static column is very useful when we want to share a column with a single value.
In Cassandra query language static columns are only static within a given partition. The static column uses clustering columns and non-clustering column to declare the static column in table definition.

Let’s understand with an example.
Now, first, we are going to define the static column in a table.



create table bank_emp_record
(
Name text,
bank_name text static,
Id int,
primary key(Name, Id)
); 

Now, we are going to insert data into the bank_emp_record table.

Insert into bank_emp_record(Name, bank_name, Id) 
values('Ashish', 'Employee bank', 101);

Insert into bank_emp_record(Name, bank_name, Id) 
values('Ashish', 'Employee bank change', 102);

Insert into bank_emp_record(Name, bank_name, Id) 
values('Ashish', 'Employee bank change new', 103); 

Output:

Here, Employee bank change new will finally updted and shared column value to the same static column.

Now, let’s consider if I don’t insert any value for bank_name then by default it will share the same value. let’s have a look.

BEGIN BATCH
Insert into bank_emp_record(Name, Id) 
values('Ashish', 104);

Insert into bank_emp_record(Name, Id) 
values('Ashish', 105);
APPLY BATCH; 

In the above-given CQL query, we are using the BATCH statement to insert more rows in a table. Now, let see the final output of the table.

select * 
from bank_emp_record; 

Output:

To know about the restriction please follow the link given below to know what type of restriction when we create the static column and how we can use that properly Reference : DataStax




My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.