[teiid-issues] [JBoss JIRA] (TEIID-2337) Source Hints documenation states source hints can be used in user and transformation queries

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-2337.
---------------------------------


    
> 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: 7.7.2, 8.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_Services/5/html/Data_Services_Reference_Guide/federated_planning.html#query_plan
> [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 at 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