Close

Installing Cassandra And Intro To CQLSH

[Updated: Mar 31, 2020, Created: Mar 30, 2020]

Cassandra 

In this tutorial we will see how to install Apache Cassandra in windows 10. We will also show how to use Cassandra's command line shell to execute CQL (Cassandra Query Language).

Download Cassandra

Download the latest Apache Cassandra from here. For this tutorial we installed version 3.11.6 (apache-cassandra-3.11.6-bin.tar.gz).

Installing Cassandra

Using following command in git-bash to extract apache-cassandra-3.11.6-bin.tar.gz to a location of your choice.

$ apache-cassandra-3.11.6-bin.tar.gz

After extraction:

$ ls -la apache-cassandra-3.11.6
total 532
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:40 ./
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 ../
-rw-r--r-- 1 Joe 197121      0 Mar 30 23:40 .toDelete
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 bin/
-rw-r--r-- 1 Joe 197121   4832 Feb 10 16:57 CASSANDRA-14092.txt
-rw-r--r-- 1 Joe 197121 372667 Feb 10 16:57 CHANGES.txt
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 conf/
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:39 data/
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 doc/
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 interface/
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 javadoc/
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 lib/
-rw-r--r-- 1 Joe 197121  11609 Feb 10 16:57 LICENSE.txt
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:39 logs/
-rw-r--r-- 1 Joe 197121 115680 Feb 10 16:57 NEWS.txt
-rw-r--r-- 1 Joe 197121   2811 Feb 10 16:57 NOTICE.txt
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 pylib/
drwxr-xr-x 1 Joe 197121      0 Mar 30 23:21 tools/

Running Cassandra

Edit D:\apache-cassandra-3.11.6\bin\cassandra.bat, set Java 8 as JAVA_HOME:

......

echo Starting with legacy startup options

if NOT DEFINED CASSANDRA_MAIN set CASSANDRA_MAIN=org.apache.cassandra.service.CassandraDaemon
set JAVA_HOME=D:\programs\java\jdk1.8.0_151
if NOT DEFINED JAVA_HOME goto :err

....

Run cassandra bat, D:\apache-cassandra-3.11.6\bin\cassandra.bat

D:\apache-cassandra-3.11.6\bin>cassandra.bat
WARNING! Powershell script execution unavailable.
   Please use 'powershell Set-ExecutionPolicy Unrestricted'
   on this user-account to run cassandra with fully featured
   functionality on this platform.
Starting with legacy startup options
Starting Cassandra Server
INFO  [main] 2020-03-31 02:16:54,696 YamlConfigurationLoader.java:89 - Configuration location: file:/D:/apache-cassandra-3.11.6/conf/cassandra.yaml
INFO  [main] 2020-03-31 02:16:55,546 Config.java:516 - Node configuration:[allocate_tokens_for_keyspace=null; authenticator=AllowAllAuthenticator; authorizer=AllowAllAuthorizer; auto_bootstrap=true; auto_snapshot=true; back_pressure_enabled=false; back_pressure_strategy=org.apache.cassandra.net.RateBasedBackPressure{high_ratio=0.9, factor=5, flow=FAST}; batch_size_fail_threshold_in_kb=50; batch_size_warn_threshold_in_kb=5; batchlog_replay_throttle_in_kb=1024; broadcast_address=null; broadcast_rpc_address=null; buffer_pool_use_heap_if_exhausted=true; cas_contention_timeout_in_ms=1000; cdc_enabled=false; cdc_free_space_check_interval_ms=250; cdc_raw_directory=null; cdc_total_space_in_mb=0; client_encryption_options=<REDACTED>; cluster_name=Test Cluster; column_index_cache_size_in_kb=2; column_index_size_in_kb=64; commit_failure_policy=stop; commitlog_compression=null; commitlog_directory=null; commitlog_max_compression_buffers_in_pool=3; commitlog_periodic_queue_size=-1; commitlog_segment_size_in_mb=32; commitlog_sync=periodic; commitlog_sync_batch_window_in_ms=NaN; commitlog_sync_period_in_ms=10000; commitlog_total_space_in_mb=null; compaction_large_partition_warning_threshold_mb=100; compaction_throughput_mb_per_sec=16; concurrent_compactors=null; concurrent_counter_writes=32; concurrent_materialized_view_writes=32; concurrent_reads=32; concurrent_replicates=null; concurrent_writes=32; counter_cache_keys_to_save=2147483647; counter_cache_save_period=7200; counter_cache_size_in_mb=null; counter_write_request_timeout_in_ms=5000; credentials_cache_max_entries=1000; credentials_update_interval_in_ms=-1; credentials_validity_in_ms=2000; cross_node_timeout=false; data_file_directories=[Ljava.lang.String;@1d76aeea; disk_access_mode=auto; disk_failure_policy=stop; disk_optimization_estimate_percentile=0.95; disk_optimization_page_cross_chance=0.1; disk_optimization_strategy=ssd; dynamic_snitch=true; dynamic_snitch_badness_threshold=0.1; dynamic_snitch_reset_interval_in_ms=600000; dynamic_snitch_update_interval_in_ms=100; enable_materialized_views=true; enable_sasi_indexes=true; enable_scripted_user_defined_functions=false; enable_user_defined_functions=false; enable_user_defined_functions_threads=true; encryption_options=null; endpoint_snitch=SimpleSnitch; file_cache_round_up=null; file_cache_size_in_mb=null; gc_log_threshold_in_ms=200; gc_warn_threshold_in_ms=1000; hinted_handoff_disabled_datacenters=[]; hinted_handoff_enabled=true; hinted_handoff_throttle_in_kb=1024; hints_compression=null; hints_directory=null; hints_flush_period_in_ms=10000; incremental_backups=false; index_interval=null; index_summary_capacity_in_mb=null; index_summary_resize_interval_in_minutes=60; initial_token=null; inter_dc_stream_throughput_outbound_megabits_per_sec=200; inter_dc_tcp_nodelay=false; internode_authenticator=null; internode_compression=dc; internode_recv_buff_size_in_bytes=0; internode_send_buff_size_in_bytes=0; key_cache_keys_to_save=2147483647; key_cache_save_period=14400; key_cache_size_in_mb=null; listen_address=localhost; listen_interface=null; listen_interface_prefer_ipv6=false; listen_on_broadcast_address=false; max_hint_window_in_ms=10800000; max_hints_delivery_threads=2; max_hints_file_size_in_mb=128; max_mutation_size_in_kb=null; max_streaming_retries=3; max_value_size_in_mb=256; memtable_allocation_type=heap_buffers; memtable_cleanup_threshold=null; memtable_flush_writers=0; memtable_heap_space_in_mb=null; memtable_offheap_space_in_mb=null; min_free_space_per_drive_in_mb=50; native_transport_flush_in_batches_legacy=true; native_transport_max_concurrent_connections=-1; native_transport_max_concurrent_connections_per_ip=-1; native_transport_max_concurrent_requests_in_bytes=-1; native_transport_max_concurrent_requests_in_bytes_per_ip=-1; native_transport_max_frame_size_in_mb=256; native_transport_max_negotiable_protocol_version=-2147483648; native_transport_max_threads=128; native_transport_port=9042; native_transport_port_ssl=null; num_tokens=256; otc_backlog_expiration_interval_ms=200; otc_coalescing_enough_coalesced_messages=8; otc_coalescing_strategy=DISABLED; otc_coalescing_window_us=200; partitioner=org.apache.cassandra.dht.Murmur3Partitioner; permissions_cache_max_entries=1000; permissions_update_interval_in_ms=-1; permissions_validity_in_ms=2000; phi_convict_threshold=8.0; prepared_statements_cache_size_mb=null; range_request_timeout_in_ms=10000; read_request_timeout_in_ms=5000; repair_session_max_tree_depth=18; request_scheduler=org.apache.cassandra.scheduler.NoScheduler; request_scheduler_id=null; request_scheduler_options=null; request_timeout_in_ms=10000; role_manager=CassandraRoleManager; roles_cache_max_entries=1000; roles_update_interval_in_ms=-1; roles_validity_in_ms=2000; row_cache_class_name=org.apache.cassandra.cache.OHCProvider; row_cache_keys_to_save=2147483647; row_cache_save_period=0; row_cache_size_in_mb=0; rpc_address=localhost; rpc_interface=null; rpc_interface_prefer_ipv6=false; rpc_keepalive=true; rpc_listen_backlog=50; rpc_max_threads=2147483647; rpc_min_threads=16; rpc_port=9160; rpc_recv_buff_size_in_bytes=null; rpc_send_buff_size_in_bytes=null; rpc_server_type=sync; saved_caches_directory=null; seed_provider=org.apache.cassandra.locator.SimpleSeedProvider{seeds=127.0.0.1}; server_encryption_options=<REDACTED>; slow_query_log_timeout_in_ms=500; snapshot_before_compaction=false; ssl_storage_port=7001; sstable_preemptive_open_interval_in_mb=50; start_native_transport=true; start_rpc=false; storage_port=7000; stream_throughput_outbound_megabits_per_sec=200; streaming_keep_alive_period_in_secs=300; streaming_socket_timeout_in_ms=86400000; thrift_framed_transport_size_in_mb=15; thrift_max_message_length_in_mb=16; thrift_prepared_statements_cache_size_mb=null; tombstone_failure_threshold=100000; tombstone_warn_threshold=1000; tracetype_query_ttl=86400; tracetype_repair_ttl=604800; transparent_data_encryption_options=org.apache.cassandra.config.TransparentDataEncryptionOptions@78dd667e; trickle_fsync=false; trickle_fsync_interval_in_kb=10240; truncate_request_timeout_in_ms=60000; unlogged_batch_across_partitions_warn_threshold=10; user_defined_function_fail_timeout=1500; user_defined_function_warn_timeout=500; user_function_timeout_policy=die; windows_timer_interval=1; write_request_timeout_in_ms=2000]
INFO  [main] 2020-03-31 02:16:55,551 DatabaseDescriptor.java:381 - DiskAccessMode 'auto' determined to be mmap, indexAccessMode is mmap
INFO  [main] 2020-03-31 02:16:55,552 DatabaseDescriptor.java:439 - Global memtable on-heap threshold is enabled at 503MB
INFO  [main] 2020-03-31 02:16:55,552 DatabaseDescriptor.java:443 - Global memtable off-heap threshold is enabled at 503MB
INFO  [main] 2020-03-31 02:16:55,697 RateBasedBackPressure.java:123 - Initialized back-pressure with high ratio: 0.9, factor: 5, flow: FAST, window size: 2000.
INFO  [main] 2020-03-31 02:16:55,698 DatabaseDescriptor.java:773 - Back-pressure is disabled with strategy org.apache.cassandra.net.RateBasedBackPressure{high_ratio=0.9, factor=5, flow=FAST}.
INFO  [main] 2020-03-31 02:16:55,843 JMXServerUtils.java:246 - Configured JMX server at: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:7199/jmxrmi
INFO  [main] 2020-03-31 02:16:55,856 CassandraDaemon.java:489 - Hostname: DESKTOP-VCSEKL5
INFO  [main] 2020-03-31 02:16:55,871 CassandraDaemon.java:496 - JVM vendor/version: Java HotSpot(TM) 64-Bit Server VM/1.8.0_151
INFO  [main] 2020-03-31 02:16:55,872 CassandraDaemon.java:497 - Heap size: 1.968GiB/1.968GiB
INFO  [main] 2020-03-31 02:16:55,874 CassandraDaemon.java:502 - Code Cache Non-heap memory: init = 2555904(2496K) used = 4963392(4847K) committed = 5046272(4928K) max = 251658240(245760K)
INFO  [main] 2020-03-31 02:16:55,874 CassandraDaemon.java:502 - Metaspace Non-heap memory: init = 0(0K) used = 18539120(18104K) committed = 19267584(18816K) max = -1(-1K)
INFO  [main] 2020-03-31 02:16:55,875 CassandraDaemon.java:502 - Compressed Class Space Non-heap memory: init = 0(0K) used = 2277104(2223K) committed = 2490368(2432K) max = 1073741824(1048576K)
INFO  [main] 2020-03-31 02:16:55,876 CassandraDaemon.java:502 - Par Eden Space Heap memory: init = 279183360(272640K) used = 106101288(103614K) committed = 279183360(272640K) max = 279183360(272640K)
INFO  [main] 2020-03-31 02:16:55,876 CassandraDaemon.java:502 - Par Survivor Space Heap memory: init = 34865152(34048K) used = 0(0K) committed = 34865152(34048K) max = 34865152(34048K)
INFO  [main] 2020-03-31 02:16:55,877 CassandraDaemon.java:502 - CMS Old Gen Heap memory: init = 1798569984(1756416K) used = 0(0K) committed = 1798569984(1756416K) max = 1798569984(1756416K)
INFO  [main] 2020-03-31 02:16:55,878 CassandraDaemon.java:504 - Classpath: D:\programs\cassandra\apache-cassandra-3.11.6\conf;D:\programs\cassandra\apache-cassandra-3.11.6\lib\airline-0.6.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\antlr-runtime-3.5.2.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\apache-cassandra-3.11.6.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\apache-cassandra-thrift-3.11.6.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\asm-5.0.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\caffeine-2.2.6.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\cassandra-driver-core-3.0.1-shaded.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\commons-cli-1.1.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\commons-codec-1.9.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\commons-lang3-3.1.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\commons-math3-3.2.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\compress-lzf-0.8.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\concurrent-trees-2.4.0.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\concurrentlinkedhashmap-lru-1.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\disruptor-3.0.1.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\ecj-4.4.2.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\guava-18.0.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\HdrHistogram-2.1.9.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\high-scale-lib-1.0.6.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\hppc-0.5.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jackson-core-asl-1.9.13.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jackson-mapper-asl-1.9.13.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jamm-0.3.0.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\javax.inject.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jbcrypt-0.3m.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jcl-over-slf4j-1.7.7.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jctools-core-1.2.1.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jflex-1.6.0.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jna-4.2.2.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\joda-time-2.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\json-simple-1.1.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jstackjunit-0.0.1.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\libthrift-0.9.2.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\log4j-over-slf4j-1.7.7.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\logback-classic-1.1.3.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\logback-core-1.1.3.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\lz4-1.3.0.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\metrics-core-3.1.5.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\metrics-jvm-3.1.5.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\metrics-logback-3.1.5.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\netty-all-4.0.44.Final.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\ohc-core-0.4.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\ohc-core-j8-0.4.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\reporter-config-base-3.0.3.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\reporter-config3-3.0.3.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\sigar-1.6.4.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\slf4j-api-1.7.7.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\snakeyaml-1.11.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\snappy-java-1.1.1.7.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\snowball-stemmer-1.3.0.581.1.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\ST4-4.0.8.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\stream-2.5.2.jar;D:\programs\cassandra\apache-cassandra-3.11.6\lib\thrift-server-0.3.7.jar;D:\programs\cassandra\apache-cassandra-3.11.6\build\classes\main;D:\programs\cassandra\apache-cassandra-3.11.6\build\classes\thrift;D:\programs\cassandra\apache-cassandra-3.11.6\lib\jamm-0.3.0.jar
INFO  [main] 2020-03-31 02:16:55,884 CassandraDaemon.java:506 - JVM Arguments: [-ea, -javaagent:D:\programs\cassandra\apache-cassandra-3.11.6\lib\jamm-0.3.0.jar, -Xms2G, -Xmx2G, -XX:+HeapDumpOnOutOfMemoryError, -XX:+UseParNewGC, -XX:+UseConcMarkSweepGC, -XX:+CMSParallelRemarkEnabled, -XX:SurvivorRatio=8, -XX:MaxTenuringThreshold=1, -XX:CMSInitiatingOccupancyFraction=75, -XX:+UseCMSInitiatingOccupancyOnly, -Dlogback.configurationFile=logback.xml, -Djava.library.path=D:\programs\cassandra\apache-cassandra-3.11.6\lib\sigar-bin, -Dcassandra.jmx.local.port=7199, -Dcassandra, -Dcassandra-foreground=yes, -Dcassandra.logdir=D:\programs\cassandra\apache-cassandra-3.11.6\logs, -Dcassandra.storagedir=D:\programs\cassandra\apache-cassandra-3.11.6\data]
WARN  [main] 2020-03-31 02:16:55,897 StartupChecks.java:169 - JMX is not enabled to receive remote connections. Please see cassandra-env.sh for more info.
WARN  [main] 2020-03-31 02:16:55,899 StartupChecks.java:220 - The JVM is not configured to stop on OutOfMemoryError which can cause data corruption. Use one of the following JVM options to configure the behavior on OutOfMemoryError:  -XX:+ExitOnOutOfMemoryError, -XX:+CrashOnOutOfMemoryError, or -XX:OnOutOfMemoryError="<cmd args>;<cmd args>"
INFO  [main] 2020-03-31 02:16:55,902 SigarLibrary.java:44 - Initializing SIGAR library
WARN  [main] 2020-03-31 02:16:55,941 SigarLibrary.java:174 - Cassandra server running in degraded mode. Is swap disabled? : false,  Address space adequate? : true,  nofile limit adequate? : true, nproc limit adequate? : true
INFO  [main] 2020-03-31 02:16:56,160 QueryProcessor.java:116 - Initialized prepared statement caches with 10 MB (native) and 10 MB (Thrift)
INFO  [main] 2020-03-31 02:16:56,993 ColumnFamilyStore.java:427 - Initializing system.IndexInfo
INFO  [main] 2020-03-31 02:16:57,787 ColumnFamilyStore.java:427 - Initializing system.batches
INFO  [main] 2020-03-31 02:16:57,795 ColumnFamilyStore.java:427 - Initializing system.paxos
INFO  [main] 2020-03-31 02:16:57,813 ColumnFamilyStore.java:427 - Initializing system.local
INFO  [SSTableBatchOpen:1] 2020-03-31 02:16:57,858 BufferPool.java:234 - Global buffer pool is enabled, when pool is exhausted (max is 503.000MiB) it will allocate on heap
INFO  [main] 2020-03-31 02:16:58,247 CacheService.java:100 - Initializing key cache with capacity of 100 MBs.
INFO  [main] 2020-03-31 02:16:58,263 CacheService.java:122 - Initializing row cache with capacity of 0 MBs
INFO  [main] 2020-03-31 02:16:58,267 CacheService.java:151 - Initializing counter cache with capacity of 50 MBs
INFO  [main] 2020-03-31 02:16:58,273 CacheService.java:162 - Scheduling counter cache save to every 7200 seconds (going to save all keys).
INFO  [main] 2020-03-31 02:16:58,292 ColumnFamilyStore.java:427 - Initializing system.peers
INFO  [main] 2020-03-31 02:16:58,304 ColumnFamilyStore.java:427 - Initializing system.peer_events
INFO  [main] 2020-03-31 02:16:58,316 ColumnFamilyStore.java:427 - Initializing system.range_xfers
INFO  [main] 2020-03-31 02:16:58,334 ColumnFamilyStore.java:427 - Initializing system.compaction_history
INFO  [main] 2020-03-31 02:16:58,366 ColumnFamilyStore.java:427 - Initializing system.sstable_activity
INFO  [main] 2020-03-31 02:16:58,391 ColumnFamilyStore.java:427 - Initializing system.size_estimates
INFO  [main] 2020-03-31 02:16:58,418 ColumnFamilyStore.java:427 - Initializing system.available_ranges
INFO  [main] 2020-03-31 02:16:58,429 ColumnFamilyStore.java:427 - Initializing system.transferred_ranges
INFO  [main] 2020-03-31 02:16:58,440 ColumnFamilyStore.java:427 - Initializing system.views_builds_in_progress
INFO  [main] 2020-03-31 02:16:58,453 ColumnFamilyStore.java:427 - Initializing system.built_views
INFO  [main] 2020-03-31 02:16:58,465 ColumnFamilyStore.java:427 - Initializing system.hints
INFO  [main] 2020-03-31 02:16:58,478 ColumnFamilyStore.java:427 - Initializing system.batchlog
INFO  [main] 2020-03-31 02:16:58,488 ColumnFamilyStore.java:427 - Initializing system.prepared_statements
INFO  [main] 2020-03-31 02:16:58,497 ColumnFamilyStore.java:427 - Initializing system.schema_keyspaces
INFO  [main] 2020-03-31 02:16:58,509 ColumnFamilyStore.java:427 - Initializing system.schema_columnfamilies
INFO  [main] 2020-03-31 02:16:58,518 ColumnFamilyStore.java:427 - Initializing system.schema_columns
INFO  [main] 2020-03-31 02:16:58,528 ColumnFamilyStore.java:427 - Initializing system.schema_triggers
INFO  [main] 2020-03-31 02:16:58,540 ColumnFamilyStore.java:427 - Initializing system.schema_usertypes
INFO  [main] 2020-03-31 02:16:58,548 ColumnFamilyStore.java:427 - Initializing system.schema_functions
INFO  [main] 2020-03-31 02:16:58,562 ColumnFamilyStore.java:427 - Initializing system.schema_aggregates
INFO  [main] 2020-03-31 02:16:58,567 ViewManager.java:137 - Not submitting build tasks for views in keyspace system as storage service is not initialized
INFO  [main] 2020-03-31 02:16:58,809 ApproximateTime.java:44 - Scheduling approximate time-check task with a precision of 10 milliseconds
INFO  [main] 2020-03-31 02:16:58,879 ColumnFamilyStore.java:427 - Initializing system_schema.keyspaces
INFO  [main] 2020-03-31 02:16:58,907 ColumnFamilyStore.java:427 - Initializing system_schema.tables
INFO  [main] 2020-03-31 02:16:58,938 ColumnFamilyStore.java:427 - Initializing system_schema.columns
INFO  [main] 2020-03-31 02:16:58,967 ColumnFamilyStore.java:427 - Initializing system_schema.triggers
INFO  [main] 2020-03-31 02:16:58,992 ColumnFamilyStore.java:427 - Initializing system_schema.dropped_columns
INFO  [main] 2020-03-31 02:16:59,018 ColumnFamilyStore.java:427 - Initializing system_schema.views
INFO  [main] 2020-03-31 02:16:59,043 ColumnFamilyStore.java:427 - Initializing system_schema.types
INFO  [main] 2020-03-31 02:16:59,068 ColumnFamilyStore.java:427 - Initializing system_schema.functions
INFO  [main] 2020-03-31 02:16:59,138 ColumnFamilyStore.java:427 - Initializing system_schema.aggregates
INFO  [main] 2020-03-31 02:16:59,163 ColumnFamilyStore.java:427 - Initializing system_schema.indexes
INFO  [main] 2020-03-31 02:16:59,183 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_schema as storage service is not initialized
INFO  [main] 2020-03-31 02:16:59,738 StorageService.java:639 - Populating token metadata from system tables
INFO  [main] 2020-03-31 02:16:59,763 StorageService.java:646 - Token metadata: Normal Tokens:
localhost/127.0.0.1:[-9209351516045600480, -9208314220035687324, -9175132298823768609, -9071824094410066770, -9035080551389464316, -9006830278411162025, -8994911724442476416, -8944594319131748737, -8885797842313516530, -8812976705500048520, -8689706146315471764, -8646006560967245443, -8612668681080028201, -8602794454297527853, -8316500809035015696, -8261330455971041974, -8153781439999062938, -8146054821016928405, -8100189406343615646, -8072920255145674945, -7819924095019944246, -7780128972441864446, -7719633756253500461, -7664311508047856250, -7646869732067608688, -7536079526550749085, -7529976163225453225, -7514655331668032921, -7509499970922060269, -7458053140055679811, -7325622674835528192, -7312177235747159072, -7271920237328344383, -6741567844917619638, -6722655700356527276, -6694064687973150476, -6614225798836457105, -6560011369521566828, -6557537264066315802, -6517637669961083916, -6405792488979223164, -6173917882023991289, -6084202722459806100, -6015184467517972168, -5974267721215364831, -5890603014701605335, -5829864232530123642, -5785968387135303380, -5778065985761257503, -5752916695097339592, -5737784908370436046, -5666937867821873151, -5666466727606083180, -5598438137440113264, -5536345641436785479, -5449780668152215008, -5446669324003355912, -5441167742120193465, -5438032710521999945, -5413441777317306107, -5383539045295622683, -5242670809123440300, -5156844866426930235, -5122922363828428641, -5093389836877066994, -5020866652487768585, -4886592648030032651, -4796905069033487245, -4757796068807996505, -4487442745590762312, -4460352920441121538, -4446945598467728176, -4402928173032491450, -4375435730683076057, -4308103690217677255, -4245988515516034055, -4194900799119667281, -4168911276942588576, -3944257039237710274, -3884879759650132227, -3849790111699493046, -3816749557816012882, -3806039966083836335, -3773552684529801979, -3587315458700627516, -3547576942459691003, -3534584129331032015, -3379549467557761384, -3365090666847828552, -3358285336043348111, -3344619085132946254, -3301694718923016641, -3287656314225239569, -3182431638411065932, -3173876518138951503, -3157699364988824666, -3141282622279183262, -3138843713617770778, -2944514402104112913, -2841474183431630119, -2749753097803982390, -2745823107694074585, -2731668288387314590, -2707555686858936157, -2643939242414527975, -2616739358523346664, -2607800100465696232, -2483283779498904385, -2480748296308935372, -2427653756882210772, -2258960796707320177, -2166311131961736898, -1925348328125998191, -1923108537795362407, -1896272270861555798, -1875916276677589996, -1761613342074387519, -1732112963874255011, -1600853134206624975, -1523481069823064040, -1233005863240237262, -1024099870689933281, -992980976682033678, -984335286447094385, -983835866631561841, -902053720323466730, -774791428750612164, -646783033602914546, -646023490087886936, -638410362507942742, -624900974228390751, -551741365399220545, -543555572892063847, -326365868435529541, -242121165648693536, -235367774107488169, 113451264110927451, 152473565383822540, 261675073891208642, 407968747596080986, 417721155182415652, 452195575733303489, 463491126111392228, 476959732602076564, 507213604339214606, 571537049664244508, 605650892583943474, 685007361629595289, 708409634745224077, 748479521683365428, 774840660042934392, 838792286727945619, 901266613889603813, 911815499505071080, 920162826689972791, 971485268811604703, 1059164154085237454, 1240955742103123537, 1350814205932392141, 1473274700825739347, 1614751659968812305, 1738397347962483787, 1764354584500741873, 1867578732662854834, 1896495415336871608, 1901087944983721433, 2015893666038948018, 2016494406050991957, 2028748811479882926, 2039451823717579912, 2070807680891408564, 2365160757218547272, 2377849209446843029, 2397344521320097034, 2433017068688254426, 2623076091591214751, 2665471739454474505, 2838884257855872891, 2883495511377044789, 2966986600158078566, 2986240376951729122, 3008253992364550915, 3082712829195260926, 3220831628266754008, 3289313165773687077, 3361825887022792502, 3383097921664694468, 3469328330408994990, 3643949100138237056, 3683249481556771525, 3823403057829598122, 3996067725427141781, 4057234670280765555, 4083971864132985060, 4151198995478299542, 4200013849027953918, 4281293041750911417, 4359739179896197100, 4410347559756704896, 4506893861639691157, 4568881642283264665, 4700539923741978479, 4778414253007821876, 4946838616795907310, 4995773257256286243, 5055017771388582820, 5273396960871567013, 5316253710289079666, 5321890870306785011, 5370043023338540276, 5455204579388833628, 5460391413557630342, 5824512640386665289, 5858497364339869746, 5890098754568603730, 6090055108937072211, 6167716541575823764, 6239146763639692987, 6352050251921015508, 6367072426219424390, 6367087381032698638, 6511030943991138261, 6604202935771778808, 6796363947737341914, 6908828059899227360, 6931094188625304665, 7048594223985868278, 7201641586215687055, 7307105557185696903, 7309229624866569054, 7386003502116056711, 7525941526876963178, 7616916836255708052, 7674764769330802376, 7697809222416543312, 7734985494757368289, 7801150857263518690, 7848828764636448238, 7861797396835407834, 7977992686554794244, 7980454214987282430, 8158249083490635752, 8184481145868157662, 8287904203782927841, 8313979016061537470, 8338088568897335082, 8455509605646740029, 8507110414958045180, 8657860012040111240, 8663999517216102174, 8802891186012337534, 8826029636704335071, 8916785392506462706, 9012357521252900819, 9052954448438876444, 9210311954338416931]

INFO  [main] 2020-03-31 02:16:59,980 ColumnFamilyStore.java:427 - Initializing system_distributed.parent_repair_history
INFO  [main] 2020-03-31 02:17:00,024 ColumnFamilyStore.java:427 - Initializing system_distributed.repair_history
INFO  [main] 2020-03-31 02:17:00,049 ColumnFamilyStore.java:427 - Initializing system_distributed.view_build_status
INFO  [main] 2020-03-31 02:17:00,078 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_distributed as storage service is not initialized
INFO  [main] 2020-03-31 02:17:00,093 ColumnFamilyStore.java:427 - Initializing system_auth.resource_role_permissons_index
INFO  [main] 2020-03-31 02:17:00,126 ColumnFamilyStore.java:427 - Initializing system_auth.role_members
INFO  [main] 2020-03-31 02:17:00,143 ColumnFamilyStore.java:427 - Initializing system_auth.role_permissions
INFO  [main] 2020-03-31 02:17:00,159 ColumnFamilyStore.java:427 - Initializing system_auth.roles
INFO  [main] 2020-03-31 02:17:00,188 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_auth as storage service is not initialized
INFO  [main] 2020-03-31 02:17:00,193 ColumnFamilyStore.java:427 - Initializing system_traces.events
INFO  [main] 2020-03-31 02:17:00,216 ColumnFamilyStore.java:427 - Initializing system_traces.sessions
INFO  [main] 2020-03-31 02:17:00,232 ViewManager.java:137 - Not submitting build tasks for views in keyspace system_traces as storage service is not initialized
INFO  [pool-3-thread-1] 2020-03-31 02:17:00,239 AutoSavingCache.java:174 - Completed loading (5 ms; 16 keys) KeyCache cache
INFO  [main] 2020-03-31 02:17:00,264 CommitLog.java:147 - Replaying D:\programs\cassandra\apache-cassandra-3.11.6\data\commitlog\CommitLog-6-1585638956053.log
INFO  [main] 2020-03-31 02:17:00,293 CommitLog.java:149 - Log replay complete, 0 replayed mutations
INFO  [main] 2020-03-31 02:17:00,294 StorageService.java:639 - Populating token metadata from system tables
INFO  [main] 2020-03-31 02:17:00,309 StorageService.java:646 - Token metadata: Normal Tokens:
localhost/127.0.0.1:[-9209351516045600480, -9208314220035687324, -9175132298823768609, -9071824094410066770, -9035080551389464316, -9006830278411162025, -8994911724442476416, -8944594319131748737, -8885797842313516530, -8812976705500048520, -8689706146315471764, -8646006560967245443, -8612668681080028201, -8602794454297527853, -8316500809035015696, -8261330455971041974, -8153781439999062938, -8146054821016928405, -8100189406343615646, -8072920255145674945, -7819924095019944246, -7780128972441864446, -7719633756253500461, -7664311508047856250, -7646869732067608688, -7536079526550749085, -7529976163225453225, -7514655331668032921, -7509499970922060269, -7458053140055679811, -7325622674835528192, -7312177235747159072, -7271920237328344383, -6741567844917619638, -6722655700356527276, -6694064687973150476, -6614225798836457105, -6560011369521566828, -6557537264066315802, -6517637669961083916, -6405792488979223164, -6173917882023991289, -6084202722459806100, -6015184467517972168, -5974267721215364831, -5890603014701605335, -5829864232530123642, -5785968387135303380, -5778065985761257503, -5752916695097339592, -5737784908370436046, -5666937867821873151, -5666466727606083180, -5598438137440113264, -5536345641436785479, -5449780668152215008, -5446669324003355912, -5441167742120193465, -5438032710521999945, -5413441777317306107, -5383539045295622683, -5242670809123440300, -5156844866426930235, -5122922363828428641, -5093389836877066994, -5020866652487768585, -4886592648030032651, -4796905069033487245, -4757796068807996505, -4487442745590762312, -4460352920441121538, -4446945598467728176, -4402928173032491450, -4375435730683076057, -4308103690217677255, -4245988515516034055, -4194900799119667281, -4168911276942588576, -3944257039237710274, -3884879759650132227, -3849790111699493046, -3816749557816012882, -3806039966083836335, -3773552684529801979, -3587315458700627516, -3547576942459691003, -3534584129331032015, -3379549467557761384, -3365090666847828552, -3358285336043348111, -3344619085132946254, -3301694718923016641, -3287656314225239569, -3182431638411065932, -3173876518138951503, -3157699364988824666, -3141282622279183262, -3138843713617770778, -2944514402104112913, -2841474183431630119, -2749753097803982390, -2745823107694074585, -2731668288387314590, -2707555686858936157, -2643939242414527975, -2616739358523346664, -2607800100465696232, -2483283779498904385, -2480748296308935372, -2427653756882210772, -2258960796707320177, -2166311131961736898, -1925348328125998191, -1923108537795362407, -1896272270861555798, -1875916276677589996, -1761613342074387519, -1732112963874255011, -1600853134206624975, -1523481069823064040, -1233005863240237262, -1024099870689933281, -992980976682033678, -984335286447094385, -983835866631561841, -902053720323466730, -774791428750612164, -646783033602914546, -646023490087886936, -638410362507942742, -624900974228390751, -551741365399220545, -543555572892063847, -326365868435529541, -242121165648693536, -235367774107488169, 113451264110927451, 152473565383822540, 261675073891208642, 407968747596080986, 417721155182415652, 452195575733303489, 463491126111392228, 476959732602076564, 507213604339214606, 571537049664244508, 605650892583943474, 685007361629595289, 708409634745224077, 748479521683365428, 774840660042934392, 838792286727945619, 901266613889603813, 911815499505071080, 920162826689972791, 971485268811604703, 1059164154085237454, 1240955742103123537, 1350814205932392141, 1473274700825739347, 1614751659968812305, 1738397347962483787, 1764354584500741873, 1867578732662854834, 1896495415336871608, 1901087944983721433, 2015893666038948018, 2016494406050991957, 2028748811479882926, 2039451823717579912, 2070807680891408564, 2365160757218547272, 2377849209446843029, 2397344521320097034, 2433017068688254426, 2623076091591214751, 2665471739454474505, 2838884257855872891, 2883495511377044789, 2966986600158078566, 2986240376951729122, 3008253992364550915, 3082712829195260926, 3220831628266754008, 3289313165773687077, 3361825887022792502, 3383097921664694468, 3469328330408994990, 3643949100138237056, 3683249481556771525, 3823403057829598122, 3996067725427141781, 4057234670280765555, 4083971864132985060, 4151198995478299542, 4200013849027953918, 4281293041750911417, 4359739179896197100, 4410347559756704896, 4506893861639691157, 4568881642283264665, 4700539923741978479, 4778414253007821876, 4946838616795907310, 4995773257256286243, 5055017771388582820, 5273396960871567013, 5316253710289079666, 5321890870306785011, 5370043023338540276, 5455204579388833628, 5460391413557630342, 5824512640386665289, 5858497364339869746, 5890098754568603730, 6090055108937072211, 6167716541575823764, 6239146763639692987, 6352050251921015508, 6367072426219424390, 6367087381032698638, 6511030943991138261, 6604202935771778808, 6796363947737341914, 6908828059899227360, 6931094188625304665, 7048594223985868278, 7201641586215687055, 7307105557185696903, 7309229624866569054, 7386003502116056711, 7525941526876963178, 7616916836255708052, 7674764769330802376, 7697809222416543312, 7734985494757368289, 7801150857263518690, 7848828764636448238, 7861797396835407834, 7977992686554794244, 7980454214987282430, 8158249083490635752, 8184481145868157662, 8287904203782927841, 8313979016061537470, 8338088568897335082, 8455509605646740029, 8507110414958045180, 8657860012040111240, 8663999517216102174, 8802891186012337534, 8826029636704335071, 8916785392506462706, 9012357521252900819, 9052954448438876444, 9210311954338416931]

INFO  [main] 2020-03-31 02:17:00,492 QueryProcessor.java:163 - Preloaded 0 prepared statements
INFO  [main] 2020-03-31 02:17:00,496 StorageService.java:657 - Cassandra version: 3.11.6
INFO  [main] 2020-03-31 02:17:00,498 StorageService.java:658 - Thrift API version: 20.1.0
INFO  [main] 2020-03-31 02:17:00,499 StorageService.java:659 - CQL supported versions: 3.4.4 (default: 3.4.4)
INFO  [main] 2020-03-31 02:17:00,501 StorageService.java:661 - Native protocol supported versions: 3/v3, 4/v4, 5/v5-beta (default: 4/v4)
INFO  [main] 2020-03-31 02:17:00,560 IndexSummaryManager.java:87 - Initializing index summary manager with a memory pool size of 100 MB and a resize interval of 60 minutes
INFO  [main] 2020-03-31 02:17:00,842 MessagingService.java:750 - Starting Messaging Service on localhost/127.0.0.1:7000 (Software Loopback Interface 1)
INFO  [main] 2020-03-31 02:17:00,877 StorageService.java:589 - Unable to gossip with any peers but continuing anyway since node is in its own seed list
INFO  [main] 2020-03-31 02:17:00,898 StorageService.java:743 - Loading persisted ring state
INFO  [main] 2020-03-31 02:17:00,902 StorageService.java:871 - Starting up server gossip
INFO  [main] 2020-03-31 02:17:00,986 TokenMetadata.java:497 - Updating topology for localhost/127.0.0.1
INFO  [main] 2020-03-31 02:17:00,989 TokenMetadata.java:497 - Updating topology for localhost/127.0.0.1
INFO  [main] 2020-03-31 02:17:01,040 StorageService.java:1038 - Using saved tokens [-1024099870689933281, -1233005863240237262, -1523481069823064040, -1600853134206624975, -1732112963874255011, -1761613342074387519, -1875916276677589996, -1896272270861555798, -1923108537795362407, -1925348328125998191, -2166311131961736898, -2258960796707320177, -235367774107488169, -242121165648693536, -2427653756882210772, -2480748296308935372, -2483283779498904385, -2607800100465696232, -2616739358523346664, -2643939242414527975, -2707555686858936157, -2731668288387314590, -2745823107694074585, -2749753097803982390, -2841474183431630119, -2944514402104112913, -3138843713617770778, -3141282622279183262, -3157699364988824666, -3173876518138951503, -3182431638411065932, -326365868435529541, -3287656314225239569, -3301694718923016641, -3344619085132946254, -3358285336043348111, -3365090666847828552, -3379549467557761384, -3534584129331032015, -3547576942459691003, -3587315458700627516, -3773552684529801979, -3806039966083836335, -3816749557816012882, -3849790111699493046, -3884879759650132227, -3944257039237710274, -4168911276942588576, -4194900799119667281, -4245988515516034055, -4308103690217677255, -4375435730683076057, -4402928173032491450, -4446945598467728176, -4460352920441121538, -4487442745590762312, -4757796068807996505, -4796905069033487245, -4886592648030032651, -5020866652487768585, -5093389836877066994, -5122922363828428641, -5156844866426930235, -5242670809123440300, -5383539045295622683, -5413441777317306107, -543555572892063847, -5438032710521999945, -5441167742120193465, -5446669324003355912, -5449780668152215008, -551741365399220545, -5536345641436785479, -5598438137440113264, -5666466727606083180, -5666937867821873151, -5737784908370436046, -5752916695097339592, -5778065985761257503, -5785968387135303380, -5829864232530123642, -5890603014701605335, -5974267721215364831, -6015184467517972168, -6084202722459806100, -6173917882023991289, -624900974228390751, -638410362507942742, -6405792488979223164, -646023490087886936, -646783033602914546, -6517637669961083916, -6557537264066315802, -6560011369521566828, -6614225798836457105, -6694064687973150476, -6722655700356527276, -6741567844917619638, -7271920237328344383, -7312177235747159072, -7325622674835528192, -7458053140055679811, -7509499970922060269, -7514655331668032921, -7529976163225453225, -7536079526550749085, -7646869732067608688, -7664311508047856250, -7719633756253500461, -774791428750612164, -7780128972441864446, -7819924095019944246, -8072920255145674945, -8100189406343615646, -8146054821016928405, -8153781439999062938, -8261330455971041974, -8316500809035015696, -8602794454297527853, -8612668681080028201, -8646006560967245443, -8689706146315471764, -8812976705500048520, -8885797842313516530, -8944594319131748737, -8994911724442476416, -9006830278411162025, -902053720323466730, -9035080551389464316, -9071824094410066770, -9175132298823768609, -9208314220035687324, -9209351516045600480, -983835866631561841, -984335286447094385, -992980976682033678, 1059164154085237454, 113451264110927451, 1240955742103123537, 1350814205932392141, 1473274700825739347, 152473565383822540, 1614751659968812305, 1738397347962483787, 1764354584500741873, 1867578732662854834, 1896495415336871608, 1901087944983721433, 2015893666038948018, 2016494406050991957, 2028748811479882926, 2039451823717579912, 2070807680891408564, 2365160757218547272, 2377849209446843029, 2397344521320097034, 2433017068688254426, 261675073891208642, 2623076091591214751, 2665471739454474505, 2838884257855872891, 2883495511377044789, 2966986600158078566, 2986240376951729122, 3008253992364550915, 3082712829195260926, 3220831628266754008, 3289313165773687077, 3361825887022792502, 3383097921664694468, 3469328330408994990, 3643949100138237056, 3683249481556771525, 3823403057829598122, 3996067725427141781, 4057234670280765555, 407968747596080986, 4083971864132985060, 4151198995478299542, 417721155182415652, 4200013849027953918, 4281293041750911417, 4359739179896197100, 4410347559756704896, 4506893861639691157, 452195575733303489, 4568881642283264665, 463491126111392228, 4700539923741978479, 476959732602076564, 4778414253007821876, 4946838616795907310, 4995773257256286243, 5055017771388582820, 507213604339214606, 5273396960871567013, 5316253710289079666, 5321890870306785011, 5370043023338540276, 5455204579388833628, 5460391413557630342, 571537049664244508, 5824512640386665289, 5858497364339869746, 5890098754568603730, 605650892583943474, 6090055108937072211, 6167716541575823764, 6239146763639692987, 6352050251921015508, 6367072426219424390, 6367087381032698638, 6511030943991138261, 6604202935771778808, 6796363947737341914, 685007361629595289, 6908828059899227360, 6931094188625304665, 7048594223985868278, 708409634745224077, 7201641586215687055, 7307105557185696903, 7309229624866569054, 7386003502116056711, 748479521683365428, 7525941526876963178, 7616916836255708052, 7674764769330802376, 7697809222416543312, 7734985494757368289, 774840660042934392, 7801150857263518690, 7848828764636448238, 7861797396835407834, 7977992686554794244, 7980454214987282430, 8158249083490635752, 8184481145868157662, 8287904203782927841, 8313979016061537470, 8338088568897335082, 838792286727945619, 8455509605646740029, 8507110414958045180, 8657860012040111240, 8663999517216102174, 8802891186012337534, 8826029636704335071, 8916785392506462706, 9012357521252900819, 901266613889603813, 9052954448438876444, 911815499505071080, 920162826689972791, 9210311954338416931, 971485268811604703]
INFO  [main] 2020-03-31 02:17:01,061 StorageService.java:1478 - JOINING: Finish joining ring
INFO  [main] 2020-03-31 02:17:01,147 StorageService.java:2386 - Node localhost/127.0.0.1 state jump to NORMAL
INFO  [main] 2020-03-31 02:17:01,404 NativeTransportService.java:73 - Netty using Java NIO event loop
INFO  [main] 2020-03-31 02:17:01,527 Server.java:158 - Using Netty Version: [netty-buffer=netty-buffer-4.0.44.Final.452812a, netty-codec=netty-codec-4.0.44.Final.452812a, netty-codec-haproxy=netty-codec-haproxy-4.0.44.Final.452812a, netty-codec-http=netty-codec-http-4.0.44.Final.452812a, netty-codec-socks=netty-codec-socks-4.0.44.Final.452812a, netty-common=netty-common-4.0.44.Final.452812a, netty-handler=netty-handler-4.0.44.Final.452812a, netty-tcnative=netty-tcnative-1.1.33.Fork26.142ecbb, netty-transport=netty-transport-4.0.44.Final.452812a, netty-transport-native-epoll=netty-transport-native-epoll-4.0.44.Final.452812a, netty-transport-rxtx=netty-transport-rxtx-4.0.44.Final.452812a, netty-transport-sctp=netty-transport-sctp-4.0.44.Final.452812a, netty-transport-udt=netty-transport-udt-4.0.44.Final.452812a]
INFO  [main] 2020-03-31 02:17:01,528 Server.java:159 - Starting listening for CQL clients on localhost/127.0.0.1:9042 (unencrypted)...
INFO  [main] 2020-03-31 02:17:01,979 CassandraDaemon.java:556 - Not starting RPC server as requested. Use JMX (StorageService->startRPCServer()) or nodetool (enablethrift) to start it

Getting started with CQLSH

CQLSH is a command line shell, which is used to run CQL (Cassandra Query Language).

To use CQLSH, Python 2.7 must be installed (Installaing Python 2.7 tutorial).

Invoke \bin\cqlsh.bat:

D:\programs\cassandra\apache-cassandra-3.11.6\bin>cqlsh.bat

WARNING: console codepage must be set to cp65001 to support utf-8 encoding on Windows platforms.
If you experience encoding problems, change your console codepage with 'chcp 65001' before starting cqlsh.

Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.11.6 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
WARNING: pyreadline dependency missing.  Install to enable tab completion.
cqlsh>

Creating Keyspace

cqlsh> CREATE KEYSPACE my_test_keyspace WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 3};
cqlsh>

Listing Keyspaces

cqlsh> desc keyspaces;

system_schema  system              system_traces
system_auth    system_distributed  my_test_keyspace

cqlsh>

Creating table

cqlsh> create table my_test_keyspace.TestTable (x int PRIMARY KEY, y text);
cqlsh>

Listing tables

cqlsh> desc tables

Keyspace system_schema
----------------------
tables     triggers    views    keyspaces  dropped_columns
functions  aggregates  indexes  types      columns

Keyspace system_auth
--------------------
resource_role_permissons_index  role_permissions  role_members  roles

Keyspace system
---------------
available_ranges          peers               batchlog        transferred_ranges
batches                   compaction_history  size_estimates  hints
prepared_statements       sstable_activity    built_views
"IndexInfo"               peer_events         range_xfers
views_builds_in_progress  paxos               local

Keyspace system_distributed
---------------------------
repair_history  view_build_status  parent_repair_history

Keyspace system_traces
----------------------
events  sessions

Keyspace my_test_keyspace
-------------------------
testtable

cqlsh>
cqlsh> SELECT table_name FROM system_schema.tables WHERE keyspace_name = 'my_test_keyspace';

 table_name
------------
  testtable

(1 rows)
cqlsh>

Listing columns

cqlsh> SELECT * FROM system_schema.columns WHERE keyspace_name = 'my_test_keyspace';

 keyspace_name    | table_name | column_name | clustering_order | column_name_bytes | kind          | position | type
------------------+------------+-------------+------------------+-------------------+---------------+----------+------
 my_test_keyspace |  testtable |           x |             none |              0x78 | partition_key |        0 |  int
 my_test_keyspace |  testtable |           y |             none |              0x79 |       regular |       -1 | text

(2 rows)
cqlsh>

Inserting data

cqlsh> insert into my_test_keyspace.testtable (x, y) values (5, 'foo');

Querying data

cqlsh> select * from my_test_keyspace.testtable;

 x | y
---+-----
 5 | foo

(1 rows)
cqlsh>

See Also