After you specify a keyspace, it's added to the prompt.Īppears. On startup, cqlsh shows the name of the cluster, IP address, and connection port. When no port is specified, the connection uses the You can only connect CQL shell to remote hosts that have a higher By default, CQL shell launches a session with the Specifying a hostname or IP address after the cqlsh command (and options) connects the CQL To direct the command output to a file seeĬonnection timeout in seconds default: 5.ĬQL request timeout in seconds default: 10.Ĭonnecting to a specific host or IP address Version displays after starting cqlsh.Įxecute the CQL statement and exit. Use tilde (~) for paths relative to theĬQL version to use. See Web Browser Control for a list of supported browsers.Įxecute commands from a CQL file, then exit.įolder that contains the cqlshrc file. Search CQL only: Identify the entity and literal value to overwrite the XMLĮlement in the schema and solrConfig files.īrowser to display the CQL command help. Search CQL only: Single quotation marks ( ' ) surround anĮntire XML schema xml_entity=' xml_entity_type' This syntax is useful when arguments might be mistaken for Separate the command line options from the command arguments with two hyphens ( Separate the data types with a comma.Įnd CQL statement. Angle brackets ( ) encloseĭata types in a set, list, map, or tuple. Braces ( ) enclose map collections or key Use single quotation marks to preserve upper case. Single quotation ( ' ) marks must surround literal strings inĬQL statements. A vertical bar ( | ) separates alternative elements. Parentheses ( ( ) ) identify a group to choose from. Square brackets ( ) surround optional commandĪrguments.
Shell is a python-based command line client for executing CQLĬommands interactively. Sets consistency for lightweight transactions (LWT).ĭisplays the Cassandra, CQL, and cqlsh versions, session host details, or tracing session details.Įxecutes a file containing CQL statements.Įnables or disables request tracing for all nodes in the cluster.Įxecute the cqlsh Cassandra python script to start the CQL shell CQL Switches user accounts without ending the CQL shell session.ĭisplays query results in 100-line chunks. Provides information about the connected Cassandra cluster and objects within the cluster. Starts the CQL shell interactive terminal with specified options.Ĭustomize the CQL shell configuration at start up from a properties file.ĭetermines how many nodes in the replica must respond for the coordinator node to successfully process a non-lightweight transaction during the CQL shell session. Introduction to Cassandra Query LanguageĬassandra Query Language (CQL) is a query language for the Cassandra database.ĬQL provides an API to Cassandra that is simpler than the Thrift API.ĬQL input consists of statements that change data, look up data, store data, or change the way data is stored.ĬQL support functions for transforming one or more column values into a new value.
0 kommentar(er)
