[teiid-issues] [JBoss JIRA] (TEIID-2337) Source Hints documenation states source hints can be used in user and transformation queries
Johnathon Lee created TEIID-2337:
------------------------------------
Summary: Source Hints documenation states source hints can be used in user
and transformation queries
Key: TEIID-2337
URL: https://issues.jboss.org/browse/TEIID-2337
Project: Teiid
Issue Type: Bug
Components: JDBC Driver, Query Engine
Affects Versions: 8.2, 7.7.2
Reporter: Johnathon Lee
Assignee: Johnathon Lee
Per [1], 15.2.13.4 states that user queries can contain source hints.
Using hints in transformations as follows [2], I can see the HINT being passed to source.
Using a SQL client such as SQuirreL and the Teiid Driver the START USER COMMAND does not
show the HINT being passed in.
[1]
https://access.redhat.com/knowledge/docs/en-US/JBoss_Enterprise_Data_Serv...
[2]
I have completed a few steps in order to verify the source hint can be passed along
using a test vdb (bqt using SLNTDS08.mw.lab.eng.bos.redhat.com).
Created a view (SourceView.SMALLA) with the transformation [1a]. Note that there seems
to be an issue with designer recognizing the format of the hint in the SQL statement and
discarding (which is why the /*+sh:'general hint' has been included). Note that
"Source:" is the Source Name specified by the Translator (this can be seen when
viewing the vdb in designer).
Turned up the logging to trace for org.teiid in the logging subsystem [2a].
Verified via the logging that the hint is being passed to the source system [3a]
[1a]
SELECT /*+sh:'general hint' Source:'FIRST_ROWS(10)' */
*
FROM
Source.SmallA
[2a]
...
<logger category="org.teiid">
<level name="TRACE"/>
</logger>
...
[3a]
8:54:01,592 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue6) Source-specific
command: SELECT /*+ FIRST_ROWS(10) */ g_0.INTKEY FROM SMALLA g_0
[3]
2012-12-31 08:48:20,413 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1) START
USER COMMAND: startTime=2012-12-31
08:48:20.413 requestID=Rg1eL+X/XzJ3.5 txID=null sessionID=Rg1eL+X/XzJ3 applicationName=JDBC principal=admin@teiid-security vdbName=bqt vdbVersion=1 sql=SELECT
*
FROM
Source.SmallA
--
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