January 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2139) Factor out common table expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2139?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2139: --------------------------------------- I've made progress on 1/3, but implementing within a single relational plan does seem too limiting. Performing automatically analysis beyond just a single table does pose additional hurdles (join order / structure, etc.), so the initial focus may be on just single tables/views. > Factor out common table expressions > ----------------------------------- > > Key: TEIID-2139 > URL: https://issues.jboss.org/browse/TEIID-2139 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.3 > > > Query planner should factor out common table expressions within queries so they are only executed once. See https://community.jboss.org/message/742355 for more context. -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2347) Inherently updatable view validation fails with ddl metadata

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2347: ------------------------------------- Summary: Inherently updatable view validation fails with ddl metadata Key: TEIID-2347 URL: https://issues.jboss.org/browse/TEIID-2347 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.3 Depending upon the vdb structure an inherently updatable view may cause an exception during validation since the foreign keys are not yet resolved. -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2345) source hints are not honoured for nested sqls

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2345?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2345. ----------------------------------- Resolution: Rejected The docs were misleading as to the formatting of the hint. An added example should clarify usage. > source hints are not honoured for nested sqls > --------------------------------------------- > > Key: TEIID-2345 > URL: https://issues.jboss.org/browse/TEIID-2345 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.1 > Reporter: Vineela Gampa > Assignee: Steven Hawkins > > Hi > I want to use general hints below. I observed i was able to put my sourcehint as below which yields generalhint information to data_window procedure. As per this document https://docs.jboss.org/author/display/TEIID/Query+Plans if i use KEEP_ALIASES general hint is available for all nested queries but i was not able to get it working > SELECT /*+ sh[KEEP ALIASES]:'foo' bar:'leading' */ \r\n" when i use something like this general hint is null in all the executions. > If i use below general hint is available only to the first execution. > "SELECT /*+ sh:'foo' bar:'leading' */ \r\n" > + " chorus_results.* \r\n" > + "FROM (\r\n" > + " EXEC data_window('select pkey, counter from testing.bigtable WHERE pkey=? LIMIT 300', ?)\r\n" > + ") AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS pkey long, counter long) AS chorus_results LIMIT 0, 20", -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2345) source hints are not honoured for nested sqls

by Vineela Gampa (JIRA)

[ https://issues.jboss.org/browse/TEIID-2345?page=com.atlassian.jira.plugin... ] Vineela Gampa commented on TEIID-2345: -------------------------------------- Steve you can reject it. Its working fine. Forgot to update it. > source hints are not honoured for nested sqls > --------------------------------------------- > > Key: TEIID-2345 > URL: https://issues.jboss.org/browse/TEIID-2345 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.1 > Reporter: Vineela Gampa > Assignee: Steven Hawkins > > Hi > I want to use general hints below. I observed i was able to put my sourcehint as below which yields generalhint information to data_window procedure. As per this document https://docs.jboss.org/author/display/TEIID/Query+Plans if i use KEEP_ALIASES general hint is available for all nested queries but i was not able to get it working > SELECT /*+ sh[KEEP ALIASES]:'foo' bar:'leading' */ \r\n" when i use something like this general hint is null in all the executions. > If i use below general hint is available only to the first execution. > "SELECT /*+ sh:'foo' bar:'leading' */ \r\n" > + " chorus_results.* \r\n" > + "FROM (\r\n" > + " EXEC data_window('select pkey, counter from testing.bigtable WHERE pkey=? LIMIT 300', ?)\r\n" > + ") AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS pkey long, counter long) AS chorus_results LIMIT 0, 20", -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2305) Spreadsheet Authentication

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2305?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2305: ------------------------------------- I believe these are two different tasks. The security-domain one supplies the credentials to the resource-adaptor so that it can authenticate with the source, with simple userid/password. For OAuth negotiations this would need something different, not sure what are the available options are. > Spreadsheet Authentication > -------------------------- > > Key: TEIID-2305 > URL: https://issues.jboss.org/browse/TEIID-2305 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Reporter: Filip Nguyen > Assignee: Filip Nguyen > > Add option to use JAAS module for OAuth for authentication. Same for SimpleLogin (probably needs to implement our own login module for this). -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2305) Spreadsheet Authentication

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2305?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2305: --------------------------------------- This was largely resolved with TEIID-2312 correct? Is there a tie in needed to Bill Burke's OAuth support in the container? > Spreadsheet Authentication > -------------------------- > > Key: TEIID-2305 > URL: https://issues.jboss.org/browse/TEIID-2305 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Reporter: Filip Nguyen > Assignee: Filip Nguyen > > Add option to use JAAS module for OAuth for authentication. Same for SimpleLogin (probably needs to implement our own login module for this). -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2345) source hints are not honoured for nested sqls

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2345?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2345: --------------------------------------- Do you have a further update on this, or can it be rejected? > source hints are not honoured for nested sqls > --------------------------------------------- > > Key: TEIID-2345 > URL: https://issues.jboss.org/browse/TEIID-2345 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.1 > Reporter: Vineela Gampa > Assignee: Steven Hawkins > > Hi > I want to use general hints below. I observed i was able to put my sourcehint as below which yields generalhint information to data_window procedure. As per this document https://docs.jboss.org/author/display/TEIID/Query+Plans if i use KEEP_ALIASES general hint is available for all nested queries but i was not able to get it working > SELECT /*+ sh[KEEP ALIASES]:'foo' bar:'leading' */ \r\n" when i use something like this general hint is null in all the executions. > If i use below general hint is available only to the first execution. > "SELECT /*+ sh:'foo' bar:'leading' */ \r\n" > + " chorus_results.* \r\n" > + "FROM (\r\n" > + " EXEC data_window('select pkey, counter from testing.bigtable WHERE pkey=? LIMIT 300', ?)\r\n" > + ") AS chorus_data_window, ARRAYTABLE(chorus_data_window.tuple COLUMNS pkey long, counter long) AS chorus_results LIMIT 0, 20", -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2321) The JdbcSslConfiguration incorrectly has property keymanagementAlgorithm set to false

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2321?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2321. ----------------------------------- Fix Version/s: 8.0 Resolution: Done This appears to have been addressed on the product side, and is no longer an issue starting in Teiid 8.0. > The JdbcSslConfiguration incorrectly has property keymanagementAlgorithm set to false > ------------------------------------------------------------------------------------- > > Key: TEIID-2321 > URL: https://issues.jboss.org/browse/TEIID-2321 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 7.7.2 > Reporter: Van Halbert > Fix For: 7.7.3, 8.0 > > > The primary issue is the line: > > <property name="keymanagementAlgorithm">false</property> > > The cause of the error message is because "false" is not a known KeyManagerFactory Algorithm. > Suggestion is to comment out the property, and remove 'false' as the value. > The Admin Guild Example 3.3 Configuration. -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2338) staging table performance

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2338?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2338: ---------------------------------- Forum Reference: https://community.jboss.org/message/786894, https://community.jboss.org/thread/219017 (was: https://community.jboss.org/message/786894) > staging table performance > ------------------------- > > Key: TEIID-2338 > URL: https://issues.jboss.org/browse/TEIID-2338 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > Large staging tables should be indexed based upon their usage to improve performance. > Further usage analysis could limit the size of the initial staging table, but is somewhat complicated - and references can be used in dynamic sql. -- 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

13 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2346) TempTable key and leaf sizing is reversed

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2346?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2346. ----------------------------------- Resolution: Done Corrected the size estimates. > TempTable key and leaf sizing is reversed > ----------------------------------------- > > Key: TEIID-2346 > URL: https://issues.jboss.org/browse/TEIID-2346 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.3 > > > The key/leaf sizing is reversed which generally means that the memory reserved will be in greater than what is needed. -- 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

13 years, 2 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2013