revokeStreamingSQL

Syntax

revokeStreamingSQL(queryId)

Arguments

queryId (optional) A STRING scalar representing the ID name for the registered streaming SQL query.

Details

Revoke a streaming SQL query registered via registerStreamingSQL. Only for the queries registered by the current user.

Return value: None.

Examples

t=table(1..10 as id,rand(100,10) as val)
share t as st
declareStreamingSQLTable(st)
registerStreamingSQL("select avg(val) from st","sql_avg") 

// Get the status of streaming SQL query
getStreamingSQLStatus("sql_avg")

// Revoke the streaming SQL query
revokeStreamingSQL("sql_avg")