{"id":16188,"date":"2018-05-20T07:00:45","date_gmt":"2018-05-20T07:00:45","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=16188"},"modified":"2021-04-05T13:45:35","modified_gmt":"2021-04-05T08:15:35","slug":"cassandra-documented-shell-commands","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/","title":{"rendered":"10 Cassandra Documented Shell Commands | CQL Shell Commands"},"content":{"rendered":"

1. Objective<\/h2>\n

In the last Cassandra tutorial<\/a><\/strong>, we studied Cassandra Data Models<\/a><\/strong>, now we are going to learn about top 10 Cassandra Documented\u00a0Shell Commands or CQL Shell Commands: help, capture, copy, describe, expand, show, tracing, paging, source, and exit with syntax. <\/span><\/p>\n

So, let’s explore Cassandra Documented\u00a0Shell Commands.<\/span><\/p>\n

\"10<\/a>

10 Cassandra Documented Shell Commands | CQL Shell Commands<\/p><\/div>\n

2. Cassandra Documented Shell Commands<\/h2>\n

There are many documented shell commands in Cassandra. Cassandra Documented\u00a0Shell commands help the user to get documentation on the topic. These documents help the user to know and troubleshoot their query. <\/span><\/p>\n

Apart from this, these are simple commands used to do some specific tasks. There are many documented shell commands in CQLSH. They are:<\/span><\/p>\n

Test your knowledge how much you know about Cassandra<\/a><\/strong><\/p>\n

a. Help<\/h3>\n

Help command allows the user to access help for all the other commands. In other words, it describes and explains all the other cqlsh commands. When this command is executed, a bunch of topics is displayed in a window. <\/span><\/p>\n

This contains a description and helps for all cqlsh commands. <\/span>
\nA Syntax of Help Command-<\/strong>
\n<\/span><\/p>\n

cqlsh:keyspace>HELP<\/pre>\n
b. Capture<\/span><\/h3>\n
There may be times when a user wants to store the output in a file. Capture command lets the user do so. It allows the latest output of a command to be captured, and then this captured output is then added to a new file.<\/span>
\nA Syntax of Capture Command-<\/strong><\/span><\/p>\n
cqlsh:keyspace>CAPTURE<\/pre>\n
Do you know about Cassandra Cluster<\/a><\/strong><\/p>\n
c. Consistency<\/span><\/h3>\n
When consistency command is executed the user gets the information about the consistency level. A user can know current consistency level. Apart from this, a user can also set a new consistency.<\/span>
\nA Syntax of Consistency Command-<\/strong>
\n<\/span><\/p>\n
cqlsh:keyspace> CONSISTENCY<\/pre>\n
d. Copy<\/h3>\n
The user may sometimes want to copy data. This Copy Command lets the user to either copy data from Cassandra to other files. Apart from this, it also allows the user to copy data from other places to Cassandra.
\n<\/span>
\nA Syntax of Copy Command-
\n<\/strong><\/span><\/p>\n
cqlsh:keyspace> COPY<\/pre>\n
Let’s take a tour to Cassandra Troubleshooting<\/a><\/strong><\/p>\n
e. Describe<\/h3>\n
Describe Command is widely used for verification. A user can verify all the data using this command. Along with proper syntax, this command displays the data stored in the data types. <\/span><\/p>\n
These data types can be collection data type or user-defined data type or simple data type as well. This command describes the cluster of Cassandra and its objects.
\n<\/span>
\nA Syntax of Describe Command-<\/strong>
\n<\/span><\/p>\n
cqlsh:keyspace> DESCRIBE<\/pre>\n
Let’s discuss Important Features of\u00a0Cassandra<\/a><\/strong><\/p>\n
f. Expand<\/span><\/h3>\n
This command expands the output. After the execution of the command, the output of the query is expanded vertically. Using Expand command, the user can look into the details of the output.
\n<\/span>
\nA Syntax of Expand Command-<\/strong><\/p>\n
cqlsh:keyspace> EXPAND\r\n<\/pre>\n
g. Show<\/h3>\n
There are a lot of details or description about Cassandra or cqlsh. Show command helps the user to display such details. These details include Cassandra version, host, data type assumption etc.
\n<\/span>
\nA Syntax of Show Command-
\n<\/strong><\/span><\/p>\n
cqlsh:keyspace> SHOW<\/pre>\n
You must read about Cassandra API<\/a><\/strong><\/p>\n
h. Tracing<\/span><\/h3>\n
This is a simple command which user uses to enable or disable request tracing.
\n<\/span>
\nA Syntax of Tracing Command-
\n<\/strong><\/span><\/p>\n
cqlsh:keyspace> TRACING<\/pre>\n
i. Paging<\/span><\/h3>\n
This is a simple command which user uses to enable or disable query paging. <\/span>
\nA Syntax of Paging Command-
\n<\/strong><\/p>\n
cqlsh:keyspace> PAGING<\/pre>\n
j. Source<\/span><\/h3>\n
Source command allows the user to execute source files. These files contain CQL statements. Using this command, the user automatically connects the cqlsh with the file. After this connection, the file is automatically executed.<\/span>
\nA Syntax of Source Command-<\/strong>
\n<\/span><\/p>\n
cqlsh:keyspace> SOURCE<\/pre>\n
Let’s read about Cassandra Architecture in detail<\/a><\/strong><\/p>\n
k. Exit<\/span><\/h3>\n
This is a simple command that terminates cqlsh. In other words, this commands exits the user from the window.<\/span>
\nA Syntax of Exit Command-<\/strong>
\n<\/span><\/p>\n
cqlsh:keyspace> EXIT<\/pre>\n
So, this was all\u00a0about Cassandra Documented\u00a0Shell Commands Tutorial. Hope you like our explanation<\/b>.<\/p>\n
Do you know about Cassandra Monitoring Tools<\/a><\/strong><\/p>\n
3. Conclusion<\/h2>\n
Hence, In this Cassandra Documented\u00a0Shell Commands tutorial, we got to know about the CQLSH Commands:\u00a0Exit Command, Source Command, Paging Command, Tracing Command,\u00a0Show-Command, Expand Command, Describe Command, Copy Command, Consistency Command, Capture Command, and Help Command with syntax. <\/span><\/p>\n
Furthermore, if you have any query regarding Cassandra Documented\u00a0Shell Commands, Feel free to ask in the comment section.\u00a0<\/span><\/p>\n
Related Topic-\u00a0Why Cassandra Is So Popular?<\/a><\/strong><\/p>\n
For reference\u00a0<\/a><\/strong><\/p>\n
1. Objective In the last Cassandra tutorial, we studied Cassandra Data Models, now we are going to learn about top 10 Cassandra Documented\u00a0Shell Commands or CQL Shell Commands: help, capture, copy, describe, expand, show,...<\/p>\n","protected":false},"author":7,"featured_media":16879,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[2286,2387,2914,2987,3028,3030,3774,4458,4461,5614,9387,12839,12840,12841,12846,13016,14868],"class_list":["post-16188","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cassandra","tag-capture-command","tag-cassandra-shell-commands","tag-consistency-command","tag-copy-command","tag-cql-shell-commands","tag-cqlsh-commands","tag-describe-command","tag-exit-command","tag-expand-command","tag-help-command","tag-paging-command","tag-shell-commands-in-cassandra","tag-shell-commands-in-cql","tag-shell-commands-in-cqlsh","tag-show-command","tag-source-command","tag-tracing-command"],"yoast_head":"\n10 Cassandra Documented Shell Commands | CQL Shell Commands - DataFlair<\/title>\n<meta name=\"description\" content=\"CQL Shell Commands, Cassandra Documented Shell Commands: Exit,Source,Paging,Tracing, Show, Expand,Describe,Copy,Consistency,Capture,Help Command with syntax\" \/>\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-documented-shell-commands\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"10 Cassandra Documented Shell Commands | CQL Shell Commands - DataFlair\" \/>\n<meta property=\"og:description\" content=\"CQL Shell Commands, Cassandra Documented Shell Commands: Exit,Source,Paging,Tracing, Show, Expand,Describe,Copy,Consistency,Capture,Help Command with syntax\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/\" \/>\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-05-20T07:00:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-05T08:15:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-DOCUMENTED-SHELL-COMMANDS-01-1.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=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"10 Cassandra Documented Shell Commands | CQL Shell Commands - DataFlair","description":"CQL Shell Commands, Cassandra Documented Shell Commands: Exit,Source,Paging,Tracing, Show, Expand,Describe,Copy,Consistency,Capture,Help Command with syntax","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-documented-shell-commands\/","og_locale":"en_US","og_type":"article","og_title":"10 Cassandra Documented Shell Commands | CQL Shell Commands - DataFlair","og_description":"CQL Shell Commands, Cassandra Documented Shell Commands: Exit,Source,Paging,Tracing, Show, Expand,Describe,Copy,Consistency,Capture,Help Command with syntax","og_url":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-05-20T07:00:45+00:00","article_modified_time":"2021-04-05T08:15:35+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-DOCUMENTED-SHELL-COMMANDS-01-1.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"10 Cassandra Documented Shell Commands | CQL Shell Commands","datePublished":"2018-05-20T07:00:45+00:00","dateModified":"2021-04-05T08:15:35+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/"},"wordCount":708,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-DOCUMENTED-SHELL-COMMANDS-01-1.jpg","keywords":["Capture Command","Cassandra Shell Commands","Consistency Command","Copy Command","CQL Shell Commands","cqlsh commands","Describe Command","Exit Command","Expand Command","Help Command","Paging Command","Shell Commands in Cassandra","Shell Commands in CQL","Shell commands in cqlsh","Show Command","Source Command","Tracing Command"],"articleSection":["Cassandra Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/","url":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/","name":"10 Cassandra Documented Shell Commands | CQL Shell Commands - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-DOCUMENTED-SHELL-COMMANDS-01-1.jpg","datePublished":"2018-05-20T07:00:45+00:00","dateModified":"2021-04-05T08:15:35+00:00","description":"CQL Shell Commands, Cassandra Documented Shell Commands: Exit,Source,Paging,Tracing, Show, Expand,Describe,Copy,Consistency,Capture,Help Command with syntax","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-DOCUMENTED-SHELL-COMMANDS-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-DOCUMENTED-SHELL-COMMANDS-01-1.jpg","width":1200,"height":628,"caption":"10 Cassandra Documented Shell Commands | CQL Shell Commands"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/cassandra-documented-shell-commands\/#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":"10 Cassandra Documented Shell Commands | CQL Shell Commands"}]},{"@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\/16188","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=16188"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16188\/revisions"}],"predecessor-version":[{"id":90518,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16188\/revisions\/90518"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/16879"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=16188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=16188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=16188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}