Syntax
------

SPIDER_BG_DIRECT_SQL('sql', 'tmp_table_list', 'parameters')

Description
-----------

Executes the given SQL statement in the background on the remote server, as
defined in the parameters listing. If the query returns a result-set, it
sttores the results in the given temporary table. When the given SQL statement
executes successfully, this function returns the number of called UDF's. It
returns 0 when the given SQL statement fails.

This function is a UDF installed with the Spider storage engine.

Examples
--------

SELECT SPIDER_BG_DIRECT_SQL('SELECT * FROM example_table',  '', 
 'srv "node1", port "8607"') AS "Direct Query";
+--------------+
| Direct Query | 
+--------------+
|            1 |
+--------------+

Parameters
----------

error_rw_mode
-------------

* Description: Returns empty results on network error.
0 : Return error on getting network error.
1: Return 0 records on getting network error.

* Default Table Value: 0
* DSN Parameter Name: erwm

URL: https://mariadb.com/kb/en/spider_bg_direct_sql/