nodesync disable

Disables NodeSync on one or more target tables by setting the nodesync enabled property to false.

Synopsis

[dse] nodesync <main_options> disable
[(-k <keyspace_name> | --keyspace <keyspace_name>)]
[--quiet]
[(-v | --verbose)]
[--] [(<table_list> | "*")]

Syntax conventions Description

Syntax conventions	Description
UPPERCASE	Literal keyword.
Lowercase	Not literal.
<`Italics>`	Variable value. Replace with a valid option or user-defined value.
`[ ]`	Optional. Square brackets ( `[ ]` ) surround optional command arguments. Do not type the square brackets.
`( )`	Group. Parentheses ( `( )` ) identify a group to choose from. Do not type the parentheses.
`\|`	Or. A vertical bar ( `\|` ) separates alternative elements. Type any one of the elements. Do not type the vertical bar.
`...`	Repeatable. An ellipsis ( `...` ) indicates that you can repeat the syntax element as often as required.
`'<Literal string>'`	Single quotation ( `'` ) marks must surround literal strings in CQL statements. Use single quotation marks to preserve upper case.
`{ <key>:<value> }`	Map collection. Braces ( `{ }` ) enclose map collections or key value pairs. A colon separates the key and the value.
`<<datatype1>,<datatype2>>`	Set, list, map, or tuple. Angle brackets ( `< >` ) enclose data types in a set, list, map, or tuple. Separate the data types with a comma.
`cql_statement;`	End CQL statement. A semicolon ( `;` ) terminates all CQL statements.
`[ -- ]`	Separate the command line options from the command arguments with two hyphens ( `--` ). This syntax is useful when arguments might be mistaken for command line options.
`' <<schema> ... </schema> >'`	Search CQL only: Single quotation marks ( `'` ) surround an entire XML schema declaration.
`@<xml_entity>='<xml_entity_type>'`	Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files.

UPPERCASE

Literal keyword.

Lowercase

Not literal.

<`Italics>`

Variable value. Replace with a valid option or user-defined value.

[ ]

Optional. Square brackets ( [ ] ) surround optional command arguments. Do not type the square brackets.

( )

Group. Parentheses ( ( ) ) identify a group to choose from. Do not type the parentheses.

|

Or. A vertical bar ( | ) separates alternative elements. Type any one of the elements. Do not type the vertical bar.

...

Repeatable. An ellipsis ( ... ) indicates that you can repeat the syntax element as often as required.

'<Literal string>'

Single quotation ( ' ) marks must surround literal strings in CQL statements. Use single quotation marks to preserve upper case.

{ <key>:<value> }

Map collection. Braces ( { } ) enclose map collections or key value pairs. A colon separates the key and the value.

<<datatype1>,<datatype2>>

Set, list, map, or tuple. Angle brackets ( < > ) enclose data types in a set, list, map, or tuple. Separate the data types with a comma.

cql_statement;

End CQL statement. A semicolon ( ; ) terminates all CQL statements.

[ -- ]

Separate the command line options from the command arguments with two hyphens ( -- ). This syntax is useful when arguments might be mistaken for command line options.

' <<schema> ... </schema> >'

Search CQL only: Single quotation marks ( ' ) surround an entire XML schema declaration.

@<xml_entity>='<xml_entity_type>'

Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrconfig files.

Main options

The following options apply to all nodesync commands.

-ca, --cql-auth-provider cql_Authprovider: CQL auth provider class name.

-cp, --cql-password cql_password: CQL password.

-cs | --cql-ssl: Use SSL for CQL connection.

-cu, --cql-username cql_username: CQL username.

-h, --host cql_host: Connect to the specified remote CQL host.

help: Displays options and usage instructions. Use nodesync help subcommand for more information on a specific command.

-jp, --jmx-password jmx_password: JMX password.

-jpf, --jmx-password-file jmx_password_file: Path to JMX password file.

-js | --jmx-ssl: Use SSL for JMX.
-ju, --jmx-username jmx_username: JMX username.

-p, --port cql_port: Connection port for CQL.

-k, --keyspace keyspace_name

Specify a default keyspace for unqualified table names or wildcards in the table_list.

Successfully run nodesync disable and nodesync enable commands on alterable keyspaces; system_distributed keyspace or a user-created keyspace. An error results when attempting to run these commands on an unalterable keyspace such as system_auth.

Success example:

nodesync disable -v -k system_distributed "*"

Nodesync disabled for system_distributed.nodesync_status
Nodesync disabled for system_distributed.backups
...
Nodesync disabled for system_distributed.repair_history

Error example:

nodesync disable -v -k system_auth "*"

Error: Keyspace [system_auth] is not alterable.

Use a CQL command to enable or disable nodesync for unalterable keyspaces such as a system_* keyspace.

Example:

ALTER TABLE system_auth.roles WITH nodesync = {'enabled': 'false'};

--quiet: Suppress warning and error messages.

-v | --verbose: Display all messages.
--: Separates table list from the rest of the command.

table_list

Target tables using any of the following methods:

Qualified table names: keyspace_name.table_name. For example, cycling.comments.
Default keyspace -k option with:
- Unqualified table names. For example -k cycling cyclist_alt_stats comments cyclist_races.
- An asterisk in double quotes to select all tables. For example, -k cycling "*".

-n, --nodes node_list: Only disable tracing on the listed nodes. Specify the host name or IP address in a comma separated list.

Default: all nodes.

--quiet: Suppresses messages from displaying on stdout.

Disable options

The following options apply to the disable subcommand:

-k, --keyspace keyspace_name

Specify a default keyspace for unqualified table names or wildcards in the table_list.

Success example:

nodesync disable -v -k system_distributed "*"

Nodesync disabled for system_distributed.nodesync_status
Nodesync disabled for system_distributed.backups
...
Nodesync disabled for system_distributed.repair_history

Error example:

nodesync disable -v -k system_auth "*"

Error: Keyspace [system_auth] is not alterable.

Use a CQL command to enable or disable nodesync for unalterable keyspaces such as a system_* keyspace.

Example:

ALTER TABLE system_auth.roles WITH nodesync = {'enabled': 'false'};

--quiet

Suppress warning and error messages.

-v | --verbose

Display all messages.

--

Separates table list from the rest of the command.

table_list

Target tables using any of the following methods:

Qualified table names: keyspace_name.table_name. For example, cycling.comments.
Default keyspace -k option with:
- Unqualified table names. For example -k cycling cyclist_alt_stats comments cyclist_races.
- An asterisk in double quotes to select all tables. For example, -k cycling "*".

Examples

Disable on single table

Set nodesync enabled to false on one table:

nodesync disable demo.health_data

No messages returned on success.

Disable on list of tables in different keyspaces

Set nodesync enabled to false on some tables in a keyspace:

nodesync disable -v -k demo -- test1 test2 test3

Displays a message for each table that was disabled:
Nodesync disabled for demo.test1
Nodesync disabled for demo.test2
Nodesync disabled for demo.test3

Disable on all tables in a keyspace

Set nodesync enabled to false on all tables in a keyspace:

nodesync disable -v -k demo "*"

Displays a message for each table that was disabled:

Nodesync disabled for demo.test2
Nodesync disabled for demo.health_data
Nodesync disabled for demo.test1
Nodesync disabled for demo.test
Nodesync disabled for demo.test3

Disable on list of tables in different keyspaces

Set nodesync enabled to false on all tables in a keyspace:

nodesync disable -v demo.test demo.test3 cycling.comments cycling.cyclist_races

Displays a message for each table that was disabled:

Nodesync disabled for demo.test
Nodesync disabled for cycling.comments
Nodesync disabled for demo.test3
Nodesync disabled for cycling.cyclist_races

nodesync disable

Synopsis

Main options

Disable options

Examples

Disable on single table

Disable on list of tables in different keyspaces

Disable on all tables in a keyspace

Disable on list of tables in different keyspaces

Was this helpful?

Give Feedback