{"id":16465,"date":"2018-06-04T06:16:44","date_gmt":"2018-06-04T06:16:44","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=16465"},"modified":"2021-04-05T13:45:19","modified_gmt":"2021-04-05T08:15:19","slug":"cassandra-data-types","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/","title":{"rendered":"Cassandra Data Types | Built-in, Collection, User-defined"},"content":{"rendered":"

1. Objective<\/h2>\n

In our previous Cassandra<\/strong> <\/a>article, we went through the CURD<\/strong>\u00a0operations in Cassandra<\/strong><\/a>. In this article, we will study the Cassandra Data Types. Moreover, in CQL data types we will see 3 different types of data types Built-in, collection, and user-defined data types.\u00a0\u00a0<\/span><\/p>\n

So, let’s begin Cassandra Data Types.<\/p>\n

\"Cassandra<\/a>

Cassandra Data Types | Built-in, Collection, User-defined<\/p><\/div>\n

2. What are the Cassandra Data Types?<\/h2>\n

Data Types usually signify the type of variables assigned in a program. We have studied many data types in other programming languages. For example int, char, float etc. In Cassandra query language, there are many data types. <\/span><\/p>\n

These Cassandra Data Types include built-in, collection and user-defined data types. The user can choose any of them as according the requirement of the program.<\/span>
\nLearn Cassandra Data Model | How Cassandra Stores Data<\/strong><\/a><\/p>\n

3. Types of Cassandra Data Types<\/h2>\n

Following are the 3 Cassandra Data Types, let’s discuss them one by one:<\/p>\n

a. Built-In Data Type<\/h3>\n

These Cassandra data types are basically pre-defined in Cassandra. The user can refer the variables to any of them. There are many built-in data types in Cassandra data types. Some of them are:<\/span><\/p>\n

\"Cassandra<\/a>

Cassandra Data Types- Built-in Data Types<\/p><\/div>\n

Prepare yourself for Cassandra\u00a0Interview<\/a><\/strong><\/p>\n

i. boolean<\/strong>
\nThis Cassandra data type is used booleans. They represent two values, true or false. We use this for applications or variables involving just two values. <\/span>
\n<\/span>
\nii. blob<\/strong>
\nThis Cassandra data type represents the arbitrary bytes. These arbitrary bytes include any kind of variable used to represent an arbitrary variable.<\/span>
\nLet’s discuss\u00a0Cassandra Architecture a Complete Guide<\/strong><\/a><\/p>\n

iii. ascii<\/strong>
\nThis Cassandra data type is used for strings i.e. words and sentences. This represents the ASCII character string. The ASCII is basically an identifier for different characters. We store the value of the variable as ASCII code of the value.<\/span><\/p>\n

iv. bigint<\/strong>
\nThis Cassandra data type is used for 64 bit signed long integer. This data type stores a higher range of integers as compared to int. In this data type 64 bit signed represents a value from -(2^32) to +2^32 roughly. <\/span><\/p>\n

v. Counter<\/strong>
\nThis Cassandra data type is used for integers. It represents a counter column. These columns are a part of the rows, which in turn are part of the column family. These contain numeric values, containing the number of columns.<\/span><\/p>\n

vi. decimal<\/strong>
\nThis data type is used for Example-integers. This is a basic data type used in approximately every language. <\/span><\/p>\n

vii. double<\/strong>
\nIt is used for integers. It represents a 64-bit floating point. These include a number with decimal points as well. Example 5.883, 94.2 etc.<\/span>
\nExplore\u00a0Cassandra Applications<\/a><\/strong><\/p>\n

viii. float<\/strong>
\nIt is used for numbers. It represents a 32-bit floating point. This contains numbers in a lesser range than double. It represents values with a decimal point. Example 4.333, 45.23523 etc..<\/span><\/p>\n

ix. inet<\/strong>
\nThis is used to represent an IP address. The IP address of any system includes both numeric and characters. These numbers won’t require\u00a0in any arithmetic operation. Therefore, we treat them as a character. In other words, this data type is used for strings or characters.<\/span><\/p>\n

x. int<\/strong>
\nThey represent 32-bit signed integers. This is a low range version of big int. The signed integer represents numbers both negative and positive. The range of the number that int supports lie from -2^16 to 2^16 roughly.<\/span><\/p>\n

xi. text<\/strong>
\nIt is used for strings. It represents UTF8 encoded string. UTF 8 is a variable with character encoding. This basically encodes all the valid points in Uni-code using one to four 8-bit types.<\/span>
\nLet’s revise\u00a09 Cassandra Shell Commands \u2013 You Must Know<\/a><\/strong><\/p>\n

xii. varchar<\/strong>
\nIt is used for strings. It represents UTF8 encoded string. \u00a0This basically describes a variable or arbitrary character. It is used to satisfy the UTF 8 as discussed in the above data type<\/span><\/p>\n

xiii. timestamp<\/strong>
\nIt represents a timestamp. It consists of Cassandra collections of integers and strings both. This timestamp basically represents the time of creation. We can use a lot of formats for the timestamp. This format includes the date, year, month, time, and also the meridian position for some time.<\/span>
\n<\/span>The formats are:<\/span>
\nyyyy-mm-dd HH:mm
\nyyyy-mm-dd HH:mm:ss<\/strong>
\nExample: If the user wants time say, 15 February 1995, 02:15 AM at GMT. The timestamp would be: 1995-02-15 \u00a002:15+0000.<\/span>
\n<\/span>All the meridian are represented as 4 digit number. For India, the number is +0530.<\/span><\/p>\n

xiv. variant<\/strong>
\nIt is used for integers. \u00a0It represents an arbitrary-precision integer.<\/span>
\nExample-<\/strong>
\nAfter going through all the data types, we will go through an example covering all the data type. Let us make a table and illustrate the data types using this table.<\/span>
\n<\/span><\/p>\n

Have a look at mostly used Cassandra Terminologies<\/a><\/strong><\/p>\n

cqlsh:keyspace1>CREATE TABLE datatypes(\r\ntype1 boolean,\r\ntype2 blob,\r\ntype3 ascii,\r\ntype4 bigint,\r\ntype5 counter,\r\ntype6 decimal,\r\ntype7 double,\r\ntype8 float,\r\ntype9 inet,\r\ntype10 int,\r\ntype11 <text, varchar>,\r\ntype12 timestamp,\r\ntype13 variant,\r\n);<\/pre>\n
Now, go through the table below to know about the data storage in the data types.<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/i><\/b><\/td>\nData type<\/i><\/b><\/td>\nData stored<\/i><\/b><\/td>\n<\/tr>\n
Type1<\/span><\/td>\nBoolean<\/span><\/td>\nTrue,false<\/span><\/td>\n<\/tr>\n
Type2<\/span><\/td>\nBlob<\/span><\/td>\n\/\/binary large objects <\/span><\/td>\n<\/tr>\n
Type3<\/span><\/td>\nASCII<\/span><\/td>\n65(A), 97(a) etc<\/span><\/td>\n<\/tr>\n
Type4<\/span><\/td>\nBigint<\/span><\/td>\n-2^32 to +2^32 (only integers)<\/span><\/td>\n<\/tr>\n
Type5<\/span><\/td>\nCounter<\/span><\/td>\n1,2,3…<\/span><\/td>\n<\/tr>\n
Type6<\/span><\/td>\nDecimal<\/span><\/td>\n1,2,-2…<\/span><\/td>\n<\/tr>\n
Type7<\/span><\/td>\nDouble<\/span><\/td>\n-2^32 to +2^32 (all real numbers)<\/span><\/td>\n<\/tr>\n
Type8<\/span><\/td>\nFloat<\/span><\/td>\n-2^16 to +2^16 (all real numbers)<\/span><\/td>\n<\/tr>\n
Type9<\/span><\/td>\nInet<\/span><\/td>\nAXHFD327864SAF etc<\/span><\/td>\n<\/tr>\n
Type10<\/span><\/td>\nInt<\/span><\/td>\n-2^16 to +2^16 (only integers)<\/span><\/td>\n<\/tr>\n
Type11<\/span><\/td>\nText, varchar<\/span><\/td>\n79-*($wkjh#$ etc<\/span><\/td>\n<\/tr>\n
Type12<\/span><\/td>\nTimestamp<\/span><\/td>\n2018-05-18 03:21+0530 etc<\/span><\/td>\n<\/tr>\n
Type13<\/span><\/td>\nVariant<\/span><\/td>\n123,34,2213 etc<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Let’s discuss Cassandra User Defined Types<\/a><\/strong><\/p>\n
b. Collection Data Type<\/h3>\n
This data type use for collective data used in a single variable. Cassandra Query Language provides three type of collection data type.<\/span><\/p>\n
\"Cassandra<\/a>
Cassandra Data Types- Collection Data Type<\/p><\/div>\n
i. List<\/strong>
\nThis Cassandra data type represents a collection of one or more elements in a table.<\/span><\/p>\n
ii. Map<\/strong>
\nThis data type represents a collection of key-value pairs.<\/span><\/p>\n
iii. Set<\/strong>
\nThis Cassandra data type represents a collection of one or more sorted elements in a table.<\/span>
\nLet’s revise\u00a05 Important Cassandra Features<\/a><\/strong><\/p>\n
c. User-Defined Data Type<\/h3>\n
CQL enables the user to create their own data type as per their requirement. After creating data type and fields in it the user can alter, verify and even drop a field or the whole data type.<\/span><\/p>\n
So, this was all about Cassandra Data Types. Hope you like our explanation of data types in Cassandra CQL.<\/p>\n
4. Conclusion<\/h2>\n
Hence, in this Cassandra Data Types tutorial, we studied 3 major data types: Built-in, Collection, and User-Defined Cassandra Data Types. Moreover, we saw many data types in Built-in Data Type. <\/span><\/p>\n
At last, we discussed Cassandra set data type, Cassandra map data type. In the next article, we will go through Collection Data Type in a detailed manner. <\/span><\/p>\n
Furthermore, for any query, feel free to ask through the comment section.<\/span>
\nSee also –\u00a0HBase vs Cassandra \u2013 Major Difference & Similarities in 2018<\/a><\/strong>
\nFor reference<\/strong><\/a>
1. Objective In our previous Cassandra article, we went through the CURD\u00a0operations in Cassandra. In this article, we will study the Cassandra Data Types. Moreover, in CQL data types we will see 3 different...<\/p>\n","protected":false},"author":7,"featured_media":16481,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[2220,2344,2345,2348,2386,2630,3014,3026,3220,3484,15332,15348],"class_list":["post-16465","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cassandra","tag-built-in-data-type","tag-cassandra-data-type-list","tag-cassandra-data-types","tag-cassandra-decimal-precision","tag-cassandra-set-data-type","tag-collection-data-type","tag-counter","tag-cql-data-types","tag-custom-cassandra-data-type","tag-data-types-in-cassandra","tag-varchar","tag-variant"],"yoast_head":"\nCassandra Data Types | Built-in, Collection, User-defined - DataFlair<\/title>\n<meta name=\"description\" content=\"Cassandra Data Types,Types of data types in Cassandra CQL,built-in data type:ascii,boolean,bigint,counter,decimal,collection data type,user defined datatype\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cassandra Data Types | Built-in, Collection, User-defined - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Cassandra Data Types,Types of data types in Cassandra CQL,built-in data type:ascii,boolean,bigint,counter,decimal,collection data type,user defined datatype\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-04T06:16:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-05T08:15:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Data-Types-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cassandra Data Types | Built-in, Collection, User-defined - DataFlair","description":"Cassandra Data Types,Types of data types in Cassandra CQL,built-in data type:ascii,boolean,bigint,counter,decimal,collection data type,user defined datatype","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/","og_locale":"en_US","og_type":"article","og_title":"Cassandra Data Types | Built-in, Collection, User-defined - DataFlair","og_description":"Cassandra Data Types,Types of data types in Cassandra CQL,built-in data type:ascii,boolean,bigint,counter,decimal,collection data type,user defined datatype","og_url":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-06-04T06:16:44+00:00","article_modified_time":"2021-04-05T08:15:19+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Data-Types-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"Cassandra Data Types | Built-in, Collection, User-defined","datePublished":"2018-06-04T06:16:44+00:00","dateModified":"2021-04-05T08:15:19+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/"},"wordCount":1109,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Data-Types-01.jpg","keywords":["Built-in data type","Cassandra data type list","Cassandra Data Types","cassandra decimal precision","cassandra set data type","collection data type","counter","CQL Data Types","custom Cassandra data type","Data Types in Cassandra","varchar","variant"],"articleSection":["Cassandra Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/","url":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/","name":"Cassandra Data Types | Built-in, Collection, User-defined - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Data-Types-01.jpg","datePublished":"2018-06-04T06:16:44+00:00","dateModified":"2021-04-05T08:15:19+00:00","description":"Cassandra Data Types,Types of data types in Cassandra CQL,built-in data type:ascii,boolean,bigint,counter,decimal,collection data type,user defined datatype","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/cassandra-data-types\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Data-Types-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Data-Types-01.jpg","width":1200,"height":628,"caption":"Cassandra Data Types"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Cassandra Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/cassandra\/"},{"@type":"ListItem","position":3,"name":"Cassandra Data Types | Built-in, Collection, User-defined"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team specializes in creating clear, actionable content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Backed by industry expertise, we make learning easy and career-oriented for beginners and pros alike.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam3\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=16465"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16465\/revisions"}],"predecessor-version":[{"id":90503,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16465\/revisions\/90503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/16481"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=16465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=16465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=16465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}