[ https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2383: ---------------------------------------- [~shawkins] Looking at your doc on hints (https://docs.jboss.org/author/display/TEIID/Hints+and+Options) it appears that the hint needs to be constructed/set-up in a certain way. This page doesn't provide a concrete/simple example to test, however, I did find a QueryNode in your RealMetadataFactory test. Is this a valid format/case? * QueryNode vTrans4 = new QueryNode("/*+ cache(ttl:100) */ SELECT x FROM matsrc"); I did debug a little in Designer using something similar: * /*+ cache(ttl:180000)*/ SELECT * FROM ProductsMySQL.product_info The first thing our TransformationValidator does, of course, is parse the SQL and get a Command. But in determining the command it throws away the prepended cache hint. Designer transformation query/UI framework utilizes this *command* in managing the actual SQL, so it's actually lost. Any ideas on how to proceed? -- This message was sent by Atlassian JIRA (v6.3.8#6338)