May 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4669) Issues with jConnect and Sybase IQ

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4669?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4669. ----------------------------------- Resolution: Done Marking as resolved given that the child issues have been addressed. > Issues with jConnect and Sybase IQ > ---------------------------------- > > Key: TEIID-4669 > URL: https://issues.jboss.org/browse/TEIID-4669 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > jConnect is not as fully-featured as the SQL Anywhere driver, to support it we may need to drop some pushdown and other support. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3647) Create native connector to interact with HDFS as a datasource

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3647?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3647: ---------------------------------- Fix Version/s: 10.x (was: 9.3) > Create native connector to interact with HDFS as a datasource > ------------------------------------------------------------- > > Key: TEIID-3647 > URL: https://issues.jboss.org/browse/TEIID-3647 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 10.x > > > Would like to have native connector > To interact with HDFS as a datasource from a DV perspective there are at least two options: > 1 - HttpFS > 2 - WebHDFS > Both options seems to be in practise very slow. I heard 2x slower. > It would be nice if we can create a native HDFS connector. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3733) Add support for web scraping

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3733?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3733: ---------------------------------- Fix Version/s: 10.x (was: 9.3) > Add support for web scraping > ---------------------------- > > Key: TEIID-3733 > URL: https://issues.jboss.org/browse/TEIID-3733 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 10.x > > > Add support for web scraping. > Here's one from CA using JSoup - https://github.com/rokhmanov/teiid-translators/blob/master/translator-scr... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4880) Join Elimination in Star Schema

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4880?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4880. ----------------------------------- Fix Version/s: 9.3 Resolution: Done Changed the logic to more generally run optional join removal and to look for key information with inner joins. > Join Elimination in Star Schema > ------------------------------- > > Key: TEIID-4880 > URL: https://issues.jboss.org/browse/TEIID-4880 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7.11.6_2 > Reporter: Madou Coulibaly > Assignee: Steven Hawkins > Fix For: 9.3 > > > Suppose we have the following star schema : > * Fact_Sales (Fact table) > * Dim_Date, Dim_Store and Dim_Product (Dimension tables) > Each table has a PK (id field) > Fact_Sales has a foreign key for each dimension (date_id, store_id, product_id) in order to link them. > Then, suppose we create an aggregate view of the fact table and its dimensions: > SELECT > \* > FROM Fact_Sales F > INNER JOIN Dim_Date D ON (F.Date_Id = D.Id) > INNER JOIN Dim_Store S ON (F.Store_Id = S.Id) > INNER JOIN Dim_Product P ON (F.Product_Id = P.Id) > Suppose now we only project fields from the fact table (Fact_Sales) and just one of its dimension (Dim_Product) in a query: > SELECT > Fact_Sales.<fields>, Dim_Product.<fields> > FROM aggregate_view > During the Query Optimization, Teiid should be able to use the PK_FK constraints which link the fact table with its dimension in order to deduct that no fields from the other dimensions (Dim_Date, Dim_Store) are projected so the joins with these tables can be removed for the Query Plan. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4663) Support a more secure block mode for client/server encryption

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4663?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4663: --------------------------------- Fix Version/s: 8.12.11.6_3 > Support a more secure block mode for client/server encryption > ------------------------------------------------------------- > > Key: TEIID-4663 > URL: https://issues.jboss.org/browse/TEIID-4663 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Driver, Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0.6, 9.1.2, 9.2, 8.12.11.6_3 > > > ECB is the current default for the socket transport encryption of secure messages. While this is relatively ok for small messages as we also have a message key acting as a CTR counter to some of the blocks, it does not provide strong security - especially for large data volume scenarios, such as when using larger login payloads or the secure requests option. We should default instead to CBC with an explicit initialization vector. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4742) Provide query prioritization feature

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4742?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4742: ------------------------------------- Fix Version/s: 10.x (was: 9.3) Assignee: (was: Steven Hawkins) > Provide query prioritization feature > ------------------------------------ > > Key: TEIID-4742 > URL: https://issues.jboss.org/browse/TEIID-4742 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Van Halbert > Fix For: 10.x > > > as the system’s utilization surges, query prioritization, queuing and resource scaling will dynamically manage the added load without degrading or crashing the system or impacting essential / critical mission operations -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4866) Enhance SQL Alchemy integration to work with Superset

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4866?page=com.atlassian.jira.plugin... ] Work on TEIID-4866 started by Steven Hawkins. --------------------------------------------- > Enhance SQL Alchemy integration to work with Superset > ----------------------------------------------------- > > Key: TEIID-4866 > URL: https://issues.jboss.org/browse/TEIID-4866 > Project: Teiid > Issue Type: Sub-task > Components: ODBC > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > Superset (previously Caravel) integration allows for an expanded set of sources, which was requested https://github.com/airbnb/superset/issues/241 > After some initial testing it looks like we still have some type and other issues to address. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4882) Nested dependent join planning issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4882?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4882: ---------------------------------- > Nested dependent join planning issue > ------------------------------------ > > Key: TEIID-4882 > URL: https://issues.jboss.org/browse/TEIID-4882 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > Regular dependent joins nested under a fully pushed dependent join will not be fully planned as rule push select criteria will not be run on the sub plan. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4886) Allow join grouping to optimize across left outer joins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4886?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4886. ----------------------------------- Resolution: Done Updated the grouping logic to look across left outer joins in certain circumstances. > Allow join grouping to optimize across left outer joins > ------------------------------------------------------- > > Key: TEIID-4886 > URL: https://issues.jboss.org/browse/TEIID-4886 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > In a from clause such as: > (a.t1 inner join b.t1 ... inner join a.t2 ...) left outer join b.t2 ... > It is possible to group the b.t1 and b.t2 together, but generally won't be found by the grouping and then ordering logic. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4886) Allow join grouping to optimize across left outer joins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4886?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4886: ---------------------------------- > Allow join grouping to optimize across left outer joins > ------------------------------------------------------- > > Key: TEIID-4886 > URL: https://issues.jboss.org/browse/TEIID-4886 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > In a from clause such as: > (a.t1 inner join b.t1 ... inner join a.t2 ...) left outer join b.t2 ... > It is possible to group the b.t1 and b.t2 together, but generally won't be found by the grouping and then ordering logic. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2017