May 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4749) Cassandra type mapping

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4749?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4749: ------------------------------------- Assignee: Steven Hawkins (was: Kylin Soong) > Cassandra type mapping > ---------------------- > > Key: TEIID-4749 > URL: https://issues.jboss.org/browse/TEIID-4749 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > With TEIID-4476 there are more cassandra types mapped. When possible we should avoid mapping to Teiid object. Lists most naturally can be mapped to an array. Several of the other types may be appropriate to map this way, or even to json (for map support). > We also need to then ensure update handling with the conversion of the runtime type back to the expected Cassandra object type. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[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)

8 years, 11 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)

8 years, 11 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)

8 years, 11 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)

8 years, 11 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)

8 years, 11 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)

8 years, 11 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)

8 years, 11 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)

8 years, 11 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)

8 years, 11 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 May 2017