December 2012 - teiid-issues - Jboss List Archives

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

by Johnathon Lee (JIRA)

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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2336) Pushdown support for arraytable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2336?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2336: ---------------------------------- Summary: Pushdown support for arraytable (was: Pushdown support for array_get) Description: Rewrite ARRAYTABLE queries as a series of cast and array_get functions calls. This would allow translators to support efficient queries using ARRAYTABLE. See https://community.jboss.org/thread/215915 for more information was: Two parts: (1) Rewrite ARRAYTABLE queries as a series of cast and array_get functions calls. (2) Allow cast and array_get functions to be pushed down to translators. This would allow translators to support efficient queries using ARRAYTABLE. See https://community.jboss.org/thread/215915 for more information Modified the issue to be specific to the rewrite of arraytable as array_get and cast are already supported pushdown functions. > Pushdown support for arraytable > ------------------------------- > > Key: TEIID-2336 > URL: https://issues.jboss.org/browse/TEIID-2336 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > > Rewrite ARRAYTABLE queries as a series of cast and array_get functions calls. > This would allow translators to support efficient queries using ARRAYTABLE. > See https://community.jboss.org/thread/215915 for more information -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2336) Pushdown support for array_get

by Mark Addleman (JIRA)

Mark Addleman created TEIID-2336: ------------------------------------ Summary: Pushdown support for array_get Key: TEIID-2336 URL: https://issues.jboss.org/browse/TEIID-2336 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Mark Addleman Assignee: Steven Hawkins Two parts: (1) Rewrite ARRAYTABLE queries as a series of cast and array_get functions calls. (2) Allow cast and array_get functions to be pushed down to translators. This would allow translators to support efficient queries using ARRAYTABLE. See https://community.jboss.org/thread/215915 for more information -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2335) Embedded Teiid: Handling translator properties

by Mark Addleman (JIRA)

[ https://issues.jboss.org/browse/TEIID-2335?page=com.atlassian.jira.plugin... ] Mark Addleman resolved TEIID-2335. ---------------------------------- Fix Version/s: 8.2 Resolution: Duplicate Issue > Embedded Teiid: Handling translator properties > ----------------------------------------------- > > Key: TEIID-2335 > URL: https://issues.jboss.org/browse/TEIID-2335 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.1 > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.2 > > > There is no way of providing translator properties through the embedded server. This is a problem for using delegating translators with the embedded server. -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2335) Embedded Teiid: Handling translator properties

by Mark Addleman (JIRA)

[ https://issues.jboss.org/browse/TEIID-2335?page=com.atlassian.jira.plugin... ] Mark Addleman commented on TEIID-2335: -------------------------------------- Done > Embedded Teiid: Handling translator properties > ----------------------------------------------- > > Key: TEIID-2335 > URL: https://issues.jboss.org/browse/TEIID-2335 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.1 > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.2 > > > There is no way of providing translator properties through the embedded server. This is a problem for using delegating translators with the embedded server. -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2335) Embedded Teiid: Handling translator properties

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2335?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2335: --------------------------------------- It is public in 8.2 from TEIID-2256. Also there is getExecutionFactory for getting the instances. Should this be resolved as a duplicate then? > Embedded Teiid: Handling translator properties > ----------------------------------------------- > > Key: TEIID-2335 > URL: https://issues.jboss.org/browse/TEIID-2335 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.1 > Reporter: Mark Addleman > Assignee: Steven Hawkins > > There is no way of providing translator properties through the embedded server. This is a problem for using delegating translators with the embedded server. -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2335) Embedded Teiid: Handling translator properties

by Mark Addleman (JIRA)

[ https://issues.jboss.org/browse/TEIID-2335?page=com.atlassian.jira.plugin... ] Mark Addleman commented on TEIID-2335: -------------------------------------- addTranslator(String, ExecutionFactory) is not public so I figured I was either missing something or the API was. I'm using 8.1. For now, I'll hack around the problem using reflection. > Embedded Teiid: Handling translator properties > ----------------------------------------------- > > Key: TEIID-2335 > URL: https://issues.jboss.org/browse/TEIID-2335 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.1 > Reporter: Mark Addleman > Assignee: Steven Hawkins > > There is no way of providing translator properties through the embedded server. This is a problem for using delegating translators with the embedded server. -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2335) Embedded Teiid: Handling translator properties

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2335?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2335: --------------------------------------- You are responsible for setting the appropriate properties, then calling the addTranslator(String, ExecutionFactory) method. Are you looking for a way of getting an ExecutionFactory instance by name to set as the delegate? > Embedded Teiid: Handling translator properties > ----------------------------------------------- > > Key: TEIID-2335 > URL: https://issues.jboss.org/browse/TEIID-2335 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.1 > Reporter: Mark Addleman > Assignee: Steven Hawkins > > There is no way of providing translator properties through the embedded server. This is a problem for using delegating translators with the embedded server. -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2335) Embedded Teiid: Handling translator properties

by Mark Addleman (JIRA)

Mark Addleman created TEIID-2335: ------------------------------------ Summary: Embedded Teiid: Handling translator properties Key: TEIID-2335 URL: https://issues.jboss.org/browse/TEIID-2335 Project: Teiid Issue Type: Feature Request Affects Versions: 8.1 Reporter: Mark Addleman Assignee: Steven Hawkins There is no way of providing translator properties through the embedded server. This is a problem for using delegating translators with the embedded server. -- 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

11 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2334) Add keys to system tables

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2334?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-2334: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > Add keys to system tables > ------------------------- > > Key: TEIID-2334 > URL: https://issues.jboss.org/browse/TEIID-2334 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.3 > > > The metadata changes to implement indexing on the system tables means that it is quite appropriate to include primary keys / indexes on system tables. We should also probably add unique constraints to uids. -- 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

11 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2012