revokeStreamingSQLTable

First introduced in version: 3.00.4

Syntax

revokeStreamingSQLTable(tableName)

Details

Revoke a streaming SQL table declared via declareStreamingSQLTable.

Only the table declared by the current user can be revoked.
Before revoking a table, all streaming SQL queries registered on it must be revoked first.
This function only removes the streaming SQL feature; the table and its data remain.

Parameters

tableName A STRING scalar indicating the name of the declared streaming SQL table.

Returns

None.

Examples

t=table(1..10 as id,rand(100,10) as val)
share t as st
declareStreamingSQLTable(st)
registerStreamingSQL("select id, val from st where val > 50", "sql_filter")

// Revoke the registered streaming SQL query
revokeStreamingSQL("sql_filter")

// Revoke the streaming SQL table
revokeStreamingSQLTable(`st)