[ https://issues.jboss.org/browse/TEIID-2345?page=com.atlassian.jira.plugin... ] Vineela Gampa updated TEIID-2345: --------------------------------- Issue Type: Bug (was: Feature Request) Description: Hi I want to use general hints below. I observed i was able to put my sourcehint as below which yields generalhint information to data_window procedure. As per this document https://docs.jboss.org/author/display/TEIID/Query+Plans if i use KEEP_ALIASES general hint is available for all nested queries but i was not able to get it working SELECT /*+ sh[KEEP ALIASES]:'foo' bar:'leading' */ \r\n" when i use something like this general hint is null in all the executions. If i use below general hint is available only to the first execution. "SELECT /*+ sh:'foo' bar:'leading' */ \r\n" + " chorus_results.* \r\n" + "FROM (\r\n" + " EXEC data_window('select pkey, counter from testing.bigtable WHERE pkey=? LIMIT 300', ?)\r\n" + ") AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS pkey long, counter long) AS chorus_results LIMIT 0, 20", was: Hi I want to use general hints below. I observed i was able to put my sourcehint as below which yields generalhint information to data_window procedure. "SELECT /*+ sh:'foo' bar:'leading' */ \r\n" + " chorus_results.* \r\n" + "FROM (\r\n" + " EXEC data_window('select pkey, counter from testing.bigtable WHERE pkey=? LIMIT 300', ?)\r\n" + ") AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS pkey long, counter long) AS chorus_results LIMIT 0, 20", -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira