• Keywords JOIN and DISTINCT are not supported

• Subqueries are not supported and will not be pushed down.

• TIBCO Streaming does not support table alias, (irrespective of whether the keyword AS is used or not). Do not use table alias in a TDV query. However, column aliases are supported

• In order to use the ORDER BY clause in your query, you must set the parameter “Result Set Size Limit For TIBCO Streaming” to a value greater than 0 in the Administration > Configuration > Data Sources > TIBCO Streaming Window. You can also specify a FETCH clause in the view to override the default result set size limit.

• When using a GROUP BY clause, calculated columns are not supported in a query.