{"id":16868,"date":"2018-05-31T04:00:39","date_gmt":"2018-05-31T04:00:39","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=16868"},"modified":"2021-04-05T13:45:22","modified_gmt":"2021-04-05T08:15:22","slug":"cassandra-shell-commands","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/","title":{"rendered":"9 Cassandra Shell Commands – You Must Know"},"content":{"rendered":"

1. Objective<\/h2>\n

In this Cassandra tutorial<\/strong><\/a>, we will study about the Cassandra shell commands used in CQLSH<\/strong><\/a>. Along\u00a0with this, we will discuss different Cassandra Shell Commands: Help, Version, Color, No color, Debug, Execute, File, U, and P with syntax and example.<\/span><\/p>\n

So, let’s Start with Cassandra Shell Commands.<\/span><\/p>\n

\"9<\/a>

9 Cassandra Shell Commands – You Must Know<\/p><\/div>\n

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

Cassandra shell commands basically manipulate the cqlsh prompt window. Apart from this, shell commands help the user to perform various operations and display various documentation. CQLSH provide with many shell commands.\u00a0<\/span><\/p>\n

Have a look at Cassandra\u00a0Cluster<\/a><\/strong><\/p>\n

a. Help<\/h3>\n

This command is used to display the help documentation. Furthermore, this also helps the user to get a description of the cqlsh commands. The user can use ‘help’ keyword to perform the operation.<\/span>
\nDo you know Major Difference & Similarities between HBase vs Cassandra<\/a><\/strong>
\nA Syntax of Help Command-<\/strong>
\n<\/span><\/p>\n

clqsh>HELP;<\/pre>\n
b. Version<\/span><\/h3>\n
There are a lot of versions of Cassandra that are upgraded since the development of the technology. This command provides the version of cqlsh the user is using.<\/span>
\nA Syntax of Version Command-<\/strong>
\n<\/span><\/p>\n
cqlsh>VERSION;<\/pre>\n
c. Color<\/span><\/h3>\n
The user can use the colorful output for a better presentation. The user can use this command for the said purpose. To perform the operation ‘COLOR’ keyword can be used.<\/span>
\nA Syntax of Color Command-<\/strong>
\n<\/span><\/p>\n
cqlsh>COLOR('<colour name>');<\/pre>\n
d. No Color<\/h3>\n
There might be a possibility that the user might want to change the color setting back to no color. For that, the user can use ‘NO COLOR’ keyword. This command directs cqlsh not to use colored output.<\/span>
\nLet’s learn Cassandra Curd Operation \u2013 Create, Update, Read & Delete<\/a><\/strong>
\nA Syntax of No Color Command-<\/strong>
\n<\/span><\/p>\n
cqlsh>NO COLOR;<\/pre>\n
e. Debug<\/span><\/h3>\n
Debugging is detection and elimination of error in a code. CQLSH provides the user to show debugging information for a source code. The ‘DEBUG’ keyword is used to perform the said operation.<\/span>
\nA Syntax of Debug Command-<\/strong>
\n<\/span><\/p>\n
cqlsh>DEBUG;<\/pre>\n
f. Execute\u00a0<\/span><\/h3>\n
CQLSH provides a command that executes a CQL command. The command first accepts the cql command. Then after accepting the command, it executes the command. <\/span><\/p>\n
‘EXECUTE’ key word is used to perform the said operation. The CQL command is added to the ‘EXECUTE’ statement.<\/span><\/p>\n
Do you know about Cassandra Troubleshooting<\/a><\/strong>
\nA Syntax of Execute Command-<\/strong>
\n<\/span><\/p>\n
cqlsh>EXECUTE <CQL_statements>;<\/pre>\n
g. File<\/span><\/h3>\n
CQLSH gives an advantage for the user to store the code in a file. That file can be executed using a SHELL COMMAND. This command lets the user to connect cqlsh with the file. ‘FILE’ keyword is used to perform the said operation in addition to the file name.<\/span>
\nA Syntax of File Command-<\/strong>
\n<\/span><\/p>\n
cqlsh>FILE('<file name>');<\/pre>\n
h. U<\/h3>\n
Cassandra provides a special feature in which you can authenticate a user. The default name in Cassandra is ‘Cassandra’. Using ‘U’ keyword is used to assign a user.<\/span>
\nDo You Know Why Cassandra Is So Popular?<\/a><\/strong>
\nA Syntax of U Command-<\/strong><\/span><\/p>\n
cqlsh>U<\"user name\">;<\/pre>\n
i. P<\/h3>\n
The user can assign a password to the authenticated user. Cassandra sets default password to be ‘\u00c7assandra’. Using ‘P’ keyword user can set the password.<\/span>
\nA Syntax of P Command-\u00a0<\/strong>
\n<\/span><\/p>\n
cqlsh>P<\"password\">;<\/pre>\n
So, this was all about Cassandra Shell Commands. Hope you like our explanation.<\/p>\n
3. Conclusion<\/h2>\n
As a result, in this article, we get to know about Cassandra shell commands. In the next article, we will study the Documented Shell Commands<\/strong><\/a>. They are a bit similar, but the difference is of the documentation and the prompt window. <\/span><\/p>\n
Furthermore, If have any doubt, feel free to ask in the comment section.<\/span>
\nRelated Topic-\u00a0Cassandra Architecture\u00a0<\/a><\/strong><\/span>
\nFor reference\u00a0<\/strong><\/span><\/a>
1. Objective In this Cassandra tutorial, we will study about the Cassandra shell commands used in CQLSH. Along\u00a0with this, we will discuss different Cassandra Shell Commands: Help, Version, Color, No color, Debug, Execute, File,...<\/p>\n","protected":false},"author":7,"featured_media":16886,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[2387,2639,3592,4447,4673,5614,9090,9370,12839,15126,15365],"class_list":["post-16868","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cassandra","tag-cassandra-shell-commands","tag-color-command","tag-debug-command","tag-execute-command","tag-file-command","tag-help-command","tag-no-color-command","tag-p-command","tag-shell-commands-in-cassandra","tag-u-command","tag-version-command"],"yoast_head":"\n9 Cassandra Shell Commands - You Must Know - DataFlair<\/title>\n<meta name=\"description\" content=\"Cassandra Shell Commands - What are the shell commands in Cassandra, Help,Version, Color, No color, Debug, Execute, File, U, P command with syntax & example\" \/>\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-shell-commands\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"9 Cassandra Shell Commands - You Must Know - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Cassandra Shell Commands - What are the shell commands in Cassandra, Help,Version, Color, No color, Debug, Execute, File, U, P command with syntax & example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/cassandra-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-31T04:00:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-05T08:15:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Shell-Commands-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=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"9 Cassandra Shell Commands - You Must Know - DataFlair","description":"Cassandra Shell Commands - What are the shell commands in Cassandra, Help,Version, Color, No color, Debug, Execute, File, U, P command with syntax & example","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-shell-commands\/","og_locale":"en_US","og_type":"article","og_title":"9 Cassandra Shell Commands - You Must Know - DataFlair","og_description":"Cassandra Shell Commands - What are the shell commands in Cassandra, Help,Version, Color, No color, Debug, Execute, File, U, P command with syntax & example","og_url":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-05-31T04:00:39+00:00","article_modified_time":"2021-04-05T08:15:22+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Shell-Commands-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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"9 Cassandra Shell Commands – You Must Know","datePublished":"2018-05-31T04:00:39+00:00","dateModified":"2021-04-05T08:15:22+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/"},"wordCount":591,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Shell-Commands-01.jpg","keywords":["Cassandra Shell Commands","color command","Debug command","execute command","file command","Help Command","No color Command","P command","Shell Commands in Cassandra","U command","Version command"],"articleSection":["Cassandra Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/","url":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/","name":"9 Cassandra Shell Commands - You Must Know - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Shell-Commands-01.jpg","datePublished":"2018-05-31T04:00:39+00:00","dateModified":"2021-04-05T08:15:22+00:00","description":"Cassandra Shell Commands - What are the shell commands in Cassandra, Help,Version, Color, No color, Debug, Execute, File, U, P command with syntax & example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Shell-Commands-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/Cassandra-Shell-Commands-01.jpg","width":1200,"height":628,"caption":"9 Cassandra Shell Commands - You Must Know"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/cassandra-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":"9 Cassandra Shell Commands – You Must Know"}]},{"@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\/16868","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=16868"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16868\/revisions"}],"predecessor-version":[{"id":90505,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16868\/revisions\/90505"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/16886"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=16868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=16868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=16868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}