Differentiate between drop and truncate in cqlsh
Answer / Saurabh Giri
In CQLSH, both DROP and TRUNCATE commands are used to remove data from a table. However, they have different behaviors:n1) DROP: This command completely removes the specified table, including the table's schema and any associated data. It cannot be undone once executed.n2) TRUNCATE: This command deletes all rows within a specified table but retains the table structure. Unlike DROP, it can be rolled back if executed as part of a transaction.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you understand by node in cassandra?
Name the types of tunable consistency?
Does Cassandra support ACID transactions?
JMX stands for?
What do you understand by mem-table in cassandra?
What are the differences between a node, a cluster, and datacenter in Cassandra?
How can a user create a Keyspace in Cassandra?
What do you mean by “data centre” in cassandra?
what is a cluster in cassandra?
What is the relationship between apache hadoop, hbase, hive and cassandra?
What is cqlsh? And why is it used?
What are the different types of nosql databases?
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)