Satya's NoSQL Blog

MongoDB import commands

2023-02-02T12:11:00.000+05:30

mongoimport commands cheatsheet in MongoDB

mongoimport -- imports data from JSON/CSV files

mongoimport --help

--help

--verbose, -v

--quiet

--version

--host <hostname><:port>, -h <hostname><:port>

--port <27017 | port>

--ipv6

--ssl

--sslCAFile <filename>

--sslPEMKeyFile <filename>

--sslPEMKeyPassword <value>

--sslCRLFile <filename>

--sslAllowInvalidCertificates

--sslAllowInvalidHostnames

--sslFIPSMode

--username <username>, -u <username>

--password <password>, -p <password>

--authenticationDatabase <dbname>

--authenticationMechanism [SCRAM-SHA-1 | MONGODB-CR | MONGODB-X509 | GSSAPI | PLAIN]

--gssapiServiceName

--gssapiHostName

--db <database>, -d <database>

--collection <collection>, -c <collection>

--fields <field1[,field2]>, -f <field1[,field2]>

--fieldFile <filename>

--ignoreBlanks

--type <json|csv|tsv>

--file <filename>

--drop

--headerline

--upsert

--upsertFields <field1[,field2]>

--stopOnError

--jsonArray

--maintainInsertionOrder [false|true]

--numInsertionWorkers <1|int>

--writeConcern <document>

mongoimport --version

mongoimport --db users --collection contacts --file contacts.json

mongoimport --db users --collection contacts --file contacts.json --verbose

mongoimport --db users --type csv --headerline --file /opt/backups/contacts.csv

mongoimport --host mongodb1.example.net --port 37017 --username user --password pass --collection contacts --db marketing --file /opt/backups/mdb1-examplenet.json

mongoimport --db users --collection contacts --type csv --headerline --file /opt/backups/contacts.csv

Related MongoDB Articles: MongoDB mongoexport commands

MongoDB mongoexport commands

2022-11-20T16:12:00.000+05:30

mongoexport commands in MongoDB

mongoexport -- exports in JSON/CSV

mongoexport --help

--help

--verbose, -v

--quiet

--version

--host <hostname><:port>, -h <hostname><:port>

--port < 27017 | port>

--ipv6

--ssl

--sslCAFile <filename>

--sslPEMKeyFile <filename>

--sslPEMKeyPassword <value>

--sslCRLFile <filename>

--sslAllowInvalidCertificates

--sslAllowInvalidHostnames

--sslFIPSMode

--username <username>, -u <username>

--password <password>, -p <password>

--authenticationDatabase <dbname>

--authenticationMechanism [SCRAM-SHA-1 | MONGODB-CR | MONGODB-X509| GSSAPI | PLAIN]

--gssapiServiceName

--gssapiHostName

--db <database>, -d <database>

--collection <collection>, -c <collection>

--fields <field1[,field2]>, -f <field1[,field2]>

--fieldFile <filename>

--query <JSON>, -q <JSON>

--type <json|string>

--out <file>, -o <file>

--jsonArray

--pretty

--slaveOk, -k

--forceTableScan

--skip <number>

--limit <number>

--sort <JSON>

mongoexport --version

mongoexport --db test --collection traffic --out traffic.json

mongoexport --db test --collection traffic --out traffic.json --verbose

mongoexport -d test -c records -q '{ a: { $gte: 3 } }' --out exportdir/myRecords.json

mongoexport --db users --collection contacts --type=csv --fields name,address --out /opt/backups/contacts.csv

mongoexport --db users --collection contacts --type=csv --fieldFile fields.txt --out /opt/backups/contacts.csv

mongoexport --db sales --collection customers --out customers.json --journal

mongoexport --host mongodb1.example.net --port 37017 --username user --password pass --collection contacts --db marketing --out mdb1-examplenet.json

mongoexport --db sales --collection contacts --query '{"field": 1}'

Related MongoDB Articles: mongod MongoDB server

MongoDB mongodump utility

2022-05-16T13:21:00.000+05:30

mongodump commands MongoDB

mongodump -- export in binary format

mongodump --help

mongodump --version

mongodump

mongodump --db myDb # all databases, except local, will be exported

mongodump --host ec2-***.amazonaws.com --username admin --password secret --authenticationDatabase admin --db myDB --collection dept --out /tmp/

mongodump --host 172.16.33.44 --username admin --password secret --authenticationDatabase admin --db myDB --collection dept --archive=/tmp/dump/dump.gz --gzip

Related MongoDB Articles: mongorestore utility in MongoDB

15+ Best interview questions of MongoDB database

Q1. What are the default Databases in MongoDB?

Answer:

Q2. What is sharding in MongoDB? Define Horizontal Scaling?

Answer:

The process of storing data records across multiple machines is referred to as Sharding.

Q3. Explain what is a replica set in MongoDB?

Answer:

A replica set is a group of Mongo instances that host the same data set.

In a replica set, one node is primary, and another is secondary. From primary, all data replicates to the secondary nodes.

Q4. What are the utilities for backup and restore in MongoDB?

Answer:

mongoexport -- exports in JSON/CSV

mongoimport -- imports data from JSON/CSV files

mongodump -- export in binary format

mongorestore -- imports data in binary data (mongodump output)

Q5. What is Aggregation in MongoDB?

Answer:

Q6. What is the use of Profiler?

Answer:

MongoDB database profiler shows performance characteristics of each operation against the database.

MongoDB's profiler is a database profiling system that can help identify inefficient queries and operations.

Q7. Does MongoDB support have a foreign key relationship?

Answer:

Q8. In which format MongoDB represents document structure? (or) In what format MongoDB data has been stored?

Answer:

BSON format - Binary JSON format

Q9. Is there any need for the "create database" command in MongoDB?

Answer:

Q10. What is _id Field in MongoDB?

Answer:

Q11. What is ObjectId? How is it structured?

Answer:

Q12. What is Storage Engine? What are all the Storage Engines available in MongoDB?

Answer:

Storage Engines - wiredTiger and inMemory

Q13. What is journaling and how does it work?

Answer:

Q14. What is Oplog (Operation Log)?

Answer:

Q15. What are the WAL (Write Ahead Log) files?

Answer:

Related MongoDB Articles: mongod MongoDB server

MongoDB Shell Mongo Client

2022-01-12T14:32:00.004+05:30

MongoDB Shell/Mongo Client commands

mongo

mongo --version

mongo 172.33.28.212

mongo <hostname>:<PORT>

mongo "mongodb://admin:secret@ec2****.amazonaws.com/admin"

mongo --host rs9/localhost:27017,localhost:27018,localhost:27019

mongo mongodb://mongodb0,mongodb1,mongodb2/replicaSet=rs0

help

db.help()

sh.help()

rs.help()

interpreterVersion()

version()

db.version()

db.serverBuildInfo()

db # current active database

show dbs

use test

show collections

rs.status()

db.stats()

db.getCollection("test").insertOne( {a:10, b:true} )

> x = 100;

> x / 5;

typeof db

typeof obj.a;

obj.c instanceof Array;

cls

exit

db.shutdownServer()

Cassandra Interview Questions and Answers

2022-01-01T19:12:00.001+05:30

Cassandra Online Quiz/Mock Test [2022]

Other Articles: Hadoop Online Test/Interview Questions

List of NoSQL Databases

2021-09-29T16:08:00.001+05:30

Here is the list of NoSQL Databases.

CDB (Constant Databse)

Oracle NoSQL Database

Tokyo Cabinet / Tyrant

Trinity

U2 (UniVerse, UniData)

VMware vFabric GemFire

Voldemort

Yserial

ZODB

Related Articles: Cassandra (Apache) New Features cassandra-cli commands Apache Hadoop

mongorestore utility in MongoDB

2021-07-26T15:27:00.004+05:30

MongoDB mongorestore commands cheatsheet

mongorestore -- imports data in binary data (mongodump output)

mongorestore --help

mongorestore --version

mongorestore

mongorestore -host ec2-***.amazonaws.com --username admin --password secret --authenticationDatabase admin

mongorestore -host 172.16.33.44 --username admin --password secret --authenticationDatabase admin --archive=mongo_dump.gz --gzip

Related MongoDB Articles: mongodump commands MongoDB

mongod MongoDB server

2021-07-18T15:39:00.012+05:30

MongoDB server mongod commands

mongod

mongod --config /etc/mongodb.conf

mongod -f /etc/mongodb.conf

mongod --dbpath /Users/satya/mongo/data/db

mongod --dbpath data --logpath logs/temp.log --logappend --httpinterface

mongod --dbpath data --logpath logs/temp.log --logappend --httpinterface --rest

mongod --logpath <LOG_PATH> --dbpath <DATA_PATH> --port <PORT> --fork

mongod --dbpath /Users/satya/mongo/data/db --fork --logpath /Users/satya/mongo/logs/mongodb.log

mongod --replSet <REPL_NAME> --logpath <LOG_PATH> --dbpath <DATA_PATH> --port <PORT> --fork

mongod --replSet <REPL_NAME> --logpath <LOG_PATH> --dbpath <DATA_PATH> --port <PORT> --fork --shardsvr

mongod --dbpath replica11 --port 27011 --logpath replica11/log --logappend --fork --bind_ip_all --replSet replicaset1 --shardsvr

mongod --dbpath replica12 --port 27012 --logpath replica12/log --logappend --fork --bind_ip_all --replSet replicaset1 --shardsvr

mongod --dbpath data --port 27017 --logpath log/mongodb.log --storageEngine=wiredTiger --journal --replSet testrep

mongod --shutdown

mongod --port 20101 --shutdown

mongod --help (or) mongod -h

mongod --version

mongod --verbose (or) mongod -v

mongod --quiet

mongod --port [27017 | <port_number>]

mongod --bind-ip <IP_address>

mongod --max-Conns

mongod --syslog

mongod --syslogFacility [user | <string>]

mongod --logappend

mongod --logRotate [rename | reopen]

mongod --timeStampFormat [ctime|iso8601-utc|iso8601-local]

mongod --pidfilepath <path>

mongod --keyFile <file>

mongod --auth

mongod --noauth

mongod --setParameter <options>

mongod --httpinterface

mongod --nounixsocket

mongod --unixSocketPrefix [/tmp|path]

mongod --fork

mongod --ipv6

mongod --jsonp

mongod --rest

mongod --slowms [100|integer]

mongod --profile [0|1]2]

mongod --cpu

mongod --sysinfo

mongod --objcheck

mongod --noobjcheck

mongod --noscripting

mongod --notablescan

mongod --shutdown

mongod --storageEngine [wiredTiger | inMemory | mmapv1]

mmapv1 - deprecated

wiredTiger - default

mongod --wiredTigerDirectoryForIndexes [false|true]

mongod --wiredTigerCacheSizeGB <size>

mongod --wiredTigerCheckpointDelaySecs [60|seconds]

mongod --wiredTigerStatisticsLogDelaySecs [0|seconds]

mongod --wiredTigerCollectionBlockCompressor [none|snappy|zlib]

mongod --wiredTigerIndexPrefixCompression [false|true]

mongod --directoryperdb

mongod --directoryperdb -dbpath C:\mongodb\data\db --logpath C:\mongodb\log\mongo.log --logappend --rest --install

mongod --noIndexBuildRetry

mongod --nssize <16|value>

mongod --quota

mongod --quotaFiles <8|number>

mongod --smallfiles

mongod --syncdelay <60|value>

mongod --upgrade

mongod --repair

mongod --repairpath <path>

mongod --journal

mongod --nojournal

mongod --journalOptions <arguments>

mongod --journalCommitInterval <value>

mongod --replSet <setname>

mongod --oplogSize <value>

mongod --replIndexPrefetch [all | none | _id_only]

mongod --master

mongod --slave

mongod --source <host><:port>

mongod --only <arg>

mongod --slavedelay <value>

mongod --autoresync

mongod --fastsync

mongod --configsvr

mongod --shardsvr

mongod --sslOnNormalPorts

mongod --sslMode <disabled | allowSSL | preferSSL | requireSSL>

mongod --sslPEMKeyFile <filename>

mongod --sslPEMKeyPassword <value>

mongod --clusterAuthMode <keyFile|sendKeyFile|sendX509|x509>

mongod --sslClusterFile <filename>

mongod --sslClusterPassword <value>

mongod --sslCAFile <filename>

mongod --sslCRLFile <filename>

mongod --sslAllowInvalidCertificates

mongod --sslAllowInvalidHostnames

mongod --sslAllowConnectionsWithoutCertificates

mongod --sslFIPSMod

mongod --auditDestination

mongod --auditFormat

mongod --auditPath

mongod --auditFilter

mongod --snmp-subagent

mongod --snmp-master

Related MongoDB Articles: MongoDB mongoexport commands mongorestore utility in MongoDB

CQL (Cassandra Query Language)

2021-03-15T15:03:00.001+05:30

CQL (Cassandra Query Language)

CQL was introduced, an SQL-like alternative to the traditional RPC interface.
Language drivers are available for Java (JDBC), Python (DBAPI2) and Node.JS (Helenus).

Aggregation, joins, and subqueries are not supported in CQL.

CREATE KEYSPACE <NAME> WITH AND strategy_class = <STRATEGY>
AND strategy_options.<OPTION> = <VALUE> [AND strategy_options. <OPTION> = <VALUE>];
CREATE KEYSPACE test with strategy_class = 'SimpleStrategy' and strategy_options:replication_factor=1;
CREATE KEYSPACE twissandra WITH strategy_class = 'NetworkTopologyStrategy' AND strategy_options:DC1 = 3;

USE <KEYSPACE>;
USE test;

CREATE COLUMNFAMILY <COLUMN FAMILY> (KEY <type> PRIMARY KEY [, name1 type, name2 type, ...]);
CREATE COLUMNFAMILY <COLUMN FAMILY> (KEY <type> PRIMARY KEY [, name1 type, name2 type, ...])
[WITH keyword1 = arg1 [AND keyword2 = arg2 [AND ...]]];
CREATE COLUMNFAMILY users (
... key varchar PRIMARY KEY,
... full_name varchar,
... birth_date int,
... birth_year bigint,
... state varchar
... );
create column family sblocks with comparator = 'UUIDType'
and default_validation_class = 'BytesType'
and key_validation_class = 'UUIDType'

DROP <KEYSPACE|COLUMNFAMILY> namespace;
DROP COLUMNFAMILY users;
DROP KEYSPACE twissandra;

TRUNCATE <COLUMN FAMILY>

CREATE TABLE Fish (KEY blob PRIMARY KEY);

CREATE INDEX [index_name] ON <column_family> (column_name);
CREATE INDEX ON users (birth_date);
CREATE INDEX surnameidx ON users (surname);

SELECT [FIRST N] [REVERSED] <SELECT EXPR> FROM <COLUMN FAMILY> [USING <CONSISTENCY>] [WHERE <CLAUSE>] [LIMIT N];
SELECT * from People;
SELECT key, state FROM users;
SELECT * FROM users WHERE state='UT' AND birth_date > 1980;
SELECT id, given FROM users WHERE surname = thirumani;
SELECT id, given FROM users WHERE surname = thirumani LIMIT 1000;
SELECT '2013-01-01'..'2013-03-28' FROM News WHERE topic = cassandra;
SELECT FIRST 10 REVERSED * FROM News WHERE topic = cassandra;
SELECT surname, given FROM users WHERE id = tsatya;

INSERT INTO (KEY, , , ...) VALUES (, , , ...) [USING <CONSISTENCY>];
INSERT INTO users (key, full_name, birth_date, state) VALUES ('bsanderson', 'Brandon Sanderson', 1975, 'UT');
INSERT INTO NerdMovies (KEY, 11924) VALUES ('fde66cdc-d857-4e90-b1e5-df09a3d40dd6', 'john') USING CONSISTENCY LOCAL_QUORUM AND TTL 86400;
INSERT INTO users (id, given, surname) VALUES (12345, Satya, Thirumani);

UPDATE <COLUMN FAMILY> [USING <CONSISTENCY>] SET name1 = value1, name2 = value2 WHERE KEY = keyname;
UPDATE users SET given = Satya, surname = Thirumani WHERE id = tsatya;
UPDATE inventory SET apples = apples + 1 WHERE id = fruit;
UPDATE inventory SET carrots = carrots - 1 WHERE id = vegetable;

DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY = keyname1
DELETE [COLUMNS] FROM <COLUMN FAMILY> [USING <CONSISTENCY>] WHERE KEY IN (keyname1, keyname2);
DELETE session_token FROM users where KEY = 'thirumani';
DELETE FROM users where KEY = 'thirumani';

BEGIN BATCH [USING CONSISTENCY ]
INSERT or UPDATE or DELETE statements separated by semicolon or "end of line"
APPLY BATCH

BEGIN BATCH
INSERT INTO msgs (owner, subject, body) VALUES(jericevans, 'Hi', 'Hiya');
UPDATE subjects SET subject = now WHERE owner = jericevans
APPLY BATCH

CQL 2.0
types made more consistent w/ SQL
count() returns rows, not columns

CQL 3.0
• Column names are strictly UTF-8
• Column names are case-insensitive (unless quoted)
• Old slice notation is gone (<start>..<end>)
• Static column families are actually static (schema-enforced)

Related Cassandra Articles: List of NoSQL Databases Cassandra nodetool cassandra-cli Commands

Apache Cassandra Terms/Abbreviations

2020-01-30T11:47:00.001+05:30

CQL - Cassandra Query Language
RP - Random Partitioner
OPP - Order Preserving Partitioner
BOP - Byte Ordered Partitioner
RF - Replication Factor
CF - Column Family

JSON - Java Script Object Notation
BSON - Binary JSON
TTL - Time To Live

HDFS - Hadoop Distributed File System
CFS - Cassandra File System
UUID - Universal Unique IDentifier
DSE - Datastax Enterprise

AMI - Amazon Machine Image
OOM - Out Of Memory
SSTables - Sorted String Table
SEDA - Staged Event-Driven Architecture
CRUD - Create Read Update Delete

JRE - Java Runtime Engine
JNA - Java Native Access
JVM - Java Virtual Machine
JMX - Java Management Extensions
JAR - Java ARchive

Related Cassandra Articles: Apache Cassandra New Features Cassandra Database

Cassandra Cluster Manager (CCM)

2019-11-22T18:24:00.001+05:30

CCM (Cassandra Cluster Manager)

ccm help
-v - version
-n - number of nodes
-s - start

ccm create help
ccm create test -v 3.6
ccm create test -v 3.7 -n 5 -s --pwd-auth

ccm populate -n 5

ccm list
ccm status
ccm start
ccm stop
ccm node1 show
ccm remove

Related Articles: Cassandra Query Language (CQL)

New Features in Apache Cassandra

2019-10-05T12:55:00.001+05:30

Cassandra 0.3 (released on Jul 21 2009)
(minor releases: 0.3.0)

Cassandra 0.4 (released on Sept 27 2009)
(minor releases: 0.4.0, 0.4.1, 0.4.2)

Added an option to waiting for commitlog sync before acknowledging writes

New Features in Cassandra 0.5 (released on Jan 25 2010)
(minor releases: 0.5.0, 0.5.1)

Added proactive repair
Added load balancing
Significantly improves bootstrap
Included new tools like JSON-based data export import
Improved command-line interface
New JMX metrics

New Features in Cassandra 0.6 (released on Apr 12 2010)
(minor releases: 0.6.0, 0.6.1, 0.6.2, 0.6.3, 0.6.4, 0.6.5, 0.6.6, 0.6.7, 0.6.8, 0.6.9, 0.6.10, 0.6.11, 0.6.12, 0.6.13)

Added support for integrated caching
Added support for Apache Hadoop MapReduce

New Features in Cassandra 0.7 (released on Jan 08 2011)
(minor releases: 0.7.0, 0.7.1, 0.7.2, 0.7.3, 0.7.4, 0.7.5, 0.7.6, 0.7.7, 0.7.8, 0.7.9)

Added secondary (column) indexes
Added online schema changes/Live schema updates (ability to create, rename, and remove both Keyspaces and ColumnFamilies in live cluster)
Expiring columns (i.e. TTL, Time To Live)

New Features in Cassandra 0.8 (released on Jun 2 2011)
(minor releases: 0.8.0, 0.8.1, 0.8.2, 0.8.3, 0.8.4, 0.8.5, 0.8.6, 0.8.7, 0.8.8, 0.8.9, 0.8.10)

Added Cassandra Query Language (CQL, CQL 1.0)
Self-tuning memtables
Support for zero-downtime upgrades, rolling upgrades
Counters

New Features in Cassandra 1.0 (released on Oct 17 2011)
(minor releases: 1.0.0, 1.0.1, 1.0.2, 1.0.3, 1.0.4, 1.0.5, 1.0.6, 1.0.7, 1.0.8, 1.0.9, 1.0.10, 1.0.11, 1.0.12)

Added integrated compression
CQL 2.0 (Cassandra Query Language)
Leveled compaction
Improved read performance
nodetool upgradesstables was available from Cassandra 1.0.4 onwards

New Features in Cassandra 1.1 (released on Apr 23 2012)
(minor releases: 1.1.0, 1.1.1, 1.1.2, 1.1.3, 1.1.4, 1.1.5, 1.1.6, 1.1.7, 1.1.8, 1.1.9, 1.1.10, 1.1.11, 1.1.12)

CQL 3.0 (Cassandra Query Language)
Added self-tuning (row, key) caches
Row-level isolation
Support for mixed ssd, hdd nodes/spinning disk deployments

New Features in Cassandra 1.2 (released on Jan 2 2013)
(minor releases: 1.2.0, 1.2.1, 1.2.2, 1.2.3, 1.2.4, 1.2.5, 1.2.6, 1.2.7, 1.2.8, 1.2.9, 1.2.10, 1.2.11, 1.2.12, 1.2.13, 1.2.14, 1.2.15, 1.2.16)

Added clustering across virtual nodes
Inter-node communication
Configurable and more frequent tombstone removal
Atomic batches
CQL 3.0.2
Faster startup times
Request tracing
Multiple independent leveled compactions in parallel
Murmur3Partitioner
Improved handling of disk failures

New Features in Cassandra 2.0 (released on Sept 3 2013)
(minor releases: 2.0.1, 2.0.2, 2.0.3, 2.0.4, 2.0.5, 2.0.6, 2.0.7)

Faster reads of compressed data
Faster partition index lookups and cache reads
VNodes are enabled by default in cassandra.yaml

New Features in Cassandra 2.1

Cassandra 2.2

Cassandra 3.0

Cassandra 3.11

Cassandra 3.11.5

Related Cassandra Articles: Cassandra Distributed Database Cassandra cli (Command Line Interface) Cassandra Query Language

Apache Cassandra database

2019-07-27T18:31:00.001+05:30

Apache Cassandra is, an open source, NoSQL, schema-less, non-RDBMS, multi-datacenter, distributed, highly scalable, column-oriented database management system (DBMS), written in Java, at Facebook, by two Indians Avinash Lakshman and Prashant Malik, designed to handle huge amount of data spread out across many servers, released in 2008.

Related Articles: New features in Apache Cassandra Cassandra cli (Command Line Interface) NoSQL Databases Apache Hadoop

Cassandra nodetool

2019-06-15T09:55:00.002+05:30

nodetool (nodeprobe in versions prior to Cassandra 0.6)

nodetool -h HOSTNAME [-p JMX_PORT|8080] COMMAND
nodetool -h HOSTNAME [-p JMX_PORT|8080 -u JMX_USERNAME -pw JMX_PASSWORD] COMMAND
-h,--host <arg> node hostname or ip address
-p,--port <arg> remote jmx agent port number
-pw,--password <arg> remote jmx agent password
-u,--username <arg> remote jmx agent username
nodetool status

info --- Print node information (uptime, load, ...)
bin/nodetool -host 106.136.0.46 info

ring --- Print information of the token ring
bin/nodetool -host 106.136.0.46 ring
join --- Join the ring
move <new token> --- Move node on the token ring to a new token
removetoken status|force|<token> --- Show status of current token removal, force completion of pending removal or remove provided token
nodetool removenode host_id

cfstats --- Print statistics of column families
cfhistograms <keyspace> <cfname> --- Print statistic histograms for a given column family
./nodetool -h -p cfhistograms
netstats [host] --- Print network information on provided host (connecting node by default)
tpstats --- Print usage statistics of thread pools
compactionstats --- Print statistics of compactions

snapshot [snapshotname] --- Take a snapshot using optional name snapshotname
$ nodetool -h localhost -p 7199 snapshot demdb
clearsnapshot --- Remove all existing snapshots
$ nodetool -h localhost -p 7199 clearsnapshot

version --- Print Cassandra version

drain --- Drain the node (stop accepting writes and flush all column families)
decommission --- Decommission the node
loadbalance --- Load balance the node

disablegossip --- Disable gossip (effectively marking the node dead)
enablegossip --- Reenable gossip

disablethrift --- Disable thrift server
enablethrift --- Reenable thrift server

flush [keyspace] [cfnames] --- Flush one or more column family
repair [keyspace] [cfnames] --- Repair one or more column family
cleanup [keyspace] [cfnames] --- Run cleanup on one or more column family
bin/nodetool -host 106.136.0.46 cleanup

compact [keyspace] [cfnames] --- Force a (major) compaction on one or more column family
bin/nodetool -host 106.136.0.46 compact
scrub [keyspace] [cfnames] --- Scrub (rebuild sstables for) one or more column family
invalidatekeycache [keyspace] [cfnames] --- Invalidate the key cache of one or more column family
invalidaterowcache [keyspace] [cfnames] --- Invalidate the row cache of one or more column family

setcachecapacity <keyspace> <cfname> <keycachecapacity> <rowcachecapacity> --- Set the key and row cache capacities of a given column family
setcompactionthreshold <keyspace> <cfname> <minthreshold> <maxthreshold> --- Set the min and max compaction thresholds for a given column family
getcompactionthreshold <keyspace> <cfname> --- Print min and max compaction thresholds for a given column family
setcompactionthroughput
nodetool -h `hostname` setcompactionthroughput 99
nodetool -h `hostname` setcompactionthroughput 0 --- disabling

upgradesstables
rebuildsstables
bin/nodetool -h devbox -p 8585 rebuildsstables my_stuff

Related Cassandra Articles: Cassandra-cli Commnads Cassandra Terms/Abbreviations Hadoop Commands

cassandra-cli Commands

2019-05-04T14:55:00.001+05:30

cassandra cli (Cassandra Command Line Interface) Commands

$ bin/cassandra-cli
$ bin/cassandra-cli --host localhost

[default@unknown] help;
[default@unknown] ?

[default@unknown] connect localhost/9160;
[default@unknown] create keyspace demo;

[default@unknown] drop keyspace demoks;

[default@unknown] describe keyspace demo;
[default@unknown] describe cluster;

[default@unknown] use demo;
[default@demo] create column family test with comparator=UTF8Type and default_validation_class=UTF8Type;
[default@demo] create column family users with comparator=UTF8Type
and column_metadata=[{column_name: full_name, validation_class: UTF8Type}, {column_name: birth_date, validation_class: LongType, index_type: KEYS}];
[default@demo] drop column family test;
[default@demo] update column family users with comparator=UTF8Type
and column_metadata=[{column_name: full_name, validation_class: UTF8Type},
{column_name: birth_date, validation_class: LongType, index_type: KEYS}, {column_name: state, validation_class: UTF8Type, index_type: KEYS}];

[default@demo] set test[row1][col1] = 'val1';
[default@demo] set test[row1][col2] = 'val2' with ttl=120;
[default@demo] set users[prothfuss][full_name] = 'Satya';
[default@demo] set users[prothfuss][birth_date] = 1983
[default@demo] get test[row1];
[default@demo] get users where birth_date = 1945;
[default@demo] get users where state = 'UT' and birth_date > 1980;

[default@demo] list output_words;

show keyspaces

show cluster name

show api version

[default@demo] exit;
[default@demo] quit;

Related Cassandra Articles: Apache Cassandra New Features Cassandra NoSQL Database Cassandra Query Language (CQL)

Satya's NoSQL Blog

MongoDB import commands

mongoimport commands cheatsheet in MongoDB

MongoDB mongoexport commands

mongoexport commands in MongoDB

MongoDB mongodump utility

mongodump commands MongoDB

Top 15 MongoDB interview questions answers

15+ Best interview questions of MongoDB database

MongoDB Shell Mongo Client

MongoDB Shell/Mongo Client commands

Cassandra Interview Questions and Answers

List of NoSQL Databases

mongorestore utility in MongoDB

MongoDB mongorestore commands cheatsheet

mongod MongoDB server

MongoDB server mongod commands

CQL (Cassandra Query Language)

CQL (Cassandra Query Language)

Apache Cassandra Terms/Abbreviations

Cassandra Cluster Manager (CCM)

New Features in Apache Cassandra

Apache Cassandra database

Cassandra nodetool

nodetool (nodeprobe in versions prior to Cassandra 0.6)

cassandra-cli Commands

cassandra cli (Cassandra Command Line Interface) Commands