DROP RESULT TABLE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Drops the specified result table.
A result table is used only to read query results in parallel.
Syntax
DROP RESULT TABLE <result_table_name>;
Remarks
-
This command can be run on the master aggregator node, or a child aggregator node (see Node Requirements for SingleStore Commands ).
-
This command does not wait for any running queries against the result table to finish before dropping the table.
This is because it is assumed that each reader that is reading the result table has completed its read before DROP RESULT TABLE
is run.For more information, see Read Query Results in Parallel.
Example
DROP RESULT TABLE my_result_tbl;
Last modified: November 29, 2022