SELECT ... FROM STREAM (ON input_relation SCRIPT 'script_name'); SELECT ... FROM STREAM (ON {table_name | view_name | (query)} [PARTITION BY expression [, ...]] [ORDER BY expression [ASC | DESC] [, ...]] [SCRIPT ('[runtime_name] scriptname')] [MEM_LIMIT_MB ('int' | 'unlimited')] [OUTPUTS ('column_name column_type' [, ...])] [NULLSTRING ('null_string')] [DELIMITER ('delimiter_character')] [TYPEFORMAT ('boolean', 'TRUE', 'FALSE')]) ) [[AS] alias] [, ...] [WHERE ...] [GROUP BY ...] [HAVING ...] [ORDER BY ...] [LIMIT ...] [OFFSET ...] );