[
https://issues.jboss.org/browse/TEIID-2381?page=com.atlassian.jira.plugin...
]
Vineela Gampa commented on TEIID-2381:
--------------------------------------
Adding another usecase
We have a usecase where we set hints to the transformation query of a view in getMetadata
call of a translator. when we are querying for that view we also pass a general hint /*+
sh:'data_window' */. we observed that teiid hints are getting ovveriden. Is there
any property with which we can ask teiid to append the hints rather than ovveriding them ?
Below is the snippet of what happens in getMetadata call.
if (v != null) {
v.setVirtual(true);
v.setTableType(Type.View);
String transformation = null;
String localHint = "";
if (hint != null) {
localHint = "/*+ sh:'" + hint + "' */ ";
}
String localCacheHint = "";
if (cacheHint != null) {
localCacheHint = "/*+ " + cacheHint + " */ ";
}
transformation = "SELECT " + localHint +
columnList.toString() + " FROM GSV." + tableName + " AS b";
if (cacheHint != null) {
v.setMaterialized(true);
transformation = localCacheHint + transformation;
}
Expanded source hint support
----------------------------
Key: TEIID-2381
URL:
https://issues.jboss.org/browse/TEIID-2381
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
We currently look at the source hint in only the root user query (not in subqueries nor
the with clause) and only consider it in a very narrow set of circumstances when it's
used in a view.
--
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