BigInt Data Type in Cassandra Query Language ( CQL) - Cassandra / CQL Tutorial

BigInt Data Type in Cassandra Query Language ( CQL)

BigInt in Cassandra Query Language ( CQL) takes 8 bytes storage to save the value. The range for BigInt is -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
Let's create a table with BigInt data type by using Cassandra Query Language ( CQL). 
CQLSH:techbrotherstutorials>CREATE TABLE tbs 
     id          INT PRIMARY KEY, 
     bigintvalue BIGINT 
  ) ;
Let's insert some big values and test, I am going to insert couple of values in the range and couple of values out of range and see what message we get from Cassandra when run our statement.
CQLSH:techbrotherstutorials> INSERT INTO tbs 
VALUES      (1, 

VALUES      (2, 

VALUES      (3, 

VALUES      (4, 

Noticed that first two values  -10000000 and 200000 are in range. Last two values -9223372036854775999 and 9223372036854775999 are out of range. When I tried to insert, I got below error.
InvalidRequest: Error from server: code=2200 [Invalid query] message="Unable to make long from '-9223372036854775999'"
Let's run Select query on table to check the data. 
CQLSH:techbrotherstutorials>SELECT * 
FROM   tbs;

No comments:

Post a Comment