ALTER CLUSTER <cluster_name> ADD <table_name> adds an existing local table to the cluster. The node which receives the ALTER query sends the table to the other nodes in the cluster. All the local tables with the same name on the other nodes of the cluster get replaced with the new table.
After the table is replicated, write statements can be performed on any node but table name must be prefixed with the cluster name like INSERT INTO <clusterName>:<table_name>.
- SQL
- JSON
- PHP
- Python
- javascript
- Java
ALTER CLUSTER click_query ADD clicks_daily_index{u'error': u'', u'total': 0, u'warning': u''}ALTER CLUSTER <cluster_name> DROP <table_name> forgets about a local table, i.e., it doesn't remove the table files on the nodes but just makes it an active non-replicated table.
After a table is removed from a cluster, it becomes a 'local' table and write statements must use just the table name as INSERT INTO <table_name>, without the cluster prefix.
- SQL
- JSON
- PHP
- Python
- javascript
- Java
ALTER CLUSTER posts DROP weekly_index{u'error': u'', u'total': 0, u'warning': u''}