March 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5876) MongoDB import name conflict issues

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5876?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5876. ----------------------------------- Resolution: Done This ended up being fairly easy to address as the existing test metadata highlighted the issue. Also decided to maintain backwards compatibility, but simply require users to turn on duplicate renaming. [~rareddy] I believe in other places (couchbase?) we took the approach of generating long names for nested structures in the translator, would you have rather add an option for that? > MongoDB import name conflict issues > ----------------------------------- > > Key: TEIID-5876 > URL: https://issues.redhat.com/browse/TEIID-5876 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 14.0 > > Original Estimate: 4 hours > Time Spent: 2 hours > Remaining Estimate: 2 hours > > There are two issues with the import logic and naming: > 1. There's an assumption that any table in the schema was created by the mongodb import. In general this is not true as other imports or ddl may have already run. > 2. If a child construct has a field name that matches an existing table, the two entities will get intertwined in the metadata, which is invalid. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5876) MongoDB import name conflict issues

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5876?focusedWorklogId=12450513&pag... ] Steven Hawkins logged work on TEIID-5876: ----------------------------------------- Author: Steven Hawkins Created on: 13/Mar/20 10:25 AM Start Date: 13/Mar/20 10:25 AM Worklog Time Spent: 2 hours Issue Time Tracking ------------------- Remaining Estimate: 2 hours (was: 4 hours) Time Spent: 2 hours Worklog Id: (was: 12450513) > MongoDB import name conflict issues > ----------------------------------- > > Key: TEIID-5876 > URL: https://issues.redhat.com/browse/TEIID-5876 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 14.0 > > Original Estimate: 4 hours > Time Spent: 2 hours > Remaining Estimate: 2 hours > > There are two issues with the import logic and naming: > 1. There's an assumption that any table in the schema was created by the mongodb import. In general this is not true as other imports or ddl may have already run. > 2. If a child construct has a field name that matches an existing table, the two entities will get intertwined in the metadata, which is invalid. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5876) MongoDB import name conflict issues

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5876?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5876: ---------------------------------- Original Estimate: 4 hours Remaining Estimate: 4 hours Story Points: 0.5 (was: 1) Sprint: DV Sprint 60 > MongoDB import name conflict issues > ----------------------------------- > > Key: TEIID-5876 > URL: https://issues.redhat.com/browse/TEIID-5876 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 14.0 > > Original Estimate: 4 hours > Remaining Estimate: 4 hours > > There are two issues with the import logic and naming: > 1. There's an assumption that any table in the schema was created by the mongodb import. In general this is not true as other imports or ddl may have already run. > 2. If a child construct has a field name that matches an existing table, the two entities will get intertwined in the metadata, which is invalid. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5040) Add translator override to change the Google spreadsheet

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5040?page=com.atlassian.jira.plugi... ] Work on TEIID-5040 started by Steven Hawkins. --------------------------------------------- > Add translator override to change the Google spreadsheet > -------------------------------------------------------- > > Key: TEIID-5040 > URL: https://issues.redhat.com/browse/TEIID-5040 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Deborah Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 14.0 > > > We would like to add a "sheet name" override to the googlesheet resource adapter. So we can configure multiple google sheets without having to configure multiple resource adaptors (1 for each google sheet.) -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5040) Add translator override to change the Google spreadsheet

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5040?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5040: ---------------------------------- Fix Version/s: 14.0 (was: 13.x) > Add translator override to change the Google spreadsheet > -------------------------------------------------------- > > Key: TEIID-5040 > URL: https://issues.redhat.com/browse/TEIID-5040 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Deborah Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 14.0 > > > We would like to add a "sheet name" override to the googlesheet resource adapter. So we can configure multiple google sheets without having to configure multiple resource adaptors (1 for each google sheet.) -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3928) Usage with analytical platforms

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3928?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3928. ----------------------------------- Fix Version/s: (was: 13.x) Resolution: Out of Date There are a couple of more specific issues for this work. > Usage with analytical platforms > ------------------------------- > > Key: TEIID-3928 > URL: https://issues.redhat.com/browse/TEIID-3928 > Project: Teiid > Issue Type: Sub-task > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Steven Hawkins > Priority: Major > > We should promote analytical platforms, such as Spark/Hive/PrestoDB, with usages of Teiid/DV as a data loader (we support a wider variety of sources can have views that perform incoming transformation/filtering logic) and for top level integration (since we provide more robust client support, transaction support, and broader federation). This effort will include documentation, additional integration code, and sample code. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2052) Add Problem/Resolution to query problem using the query plan

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-2052?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-2052. ----------------------------------- Fix Version/s: (was: 13.x) Resolution: Out of Date The docs have been updated as to reading query plans. There are also a lot of annotations on the debug log that state things like predicate blank can't be pushed. As for a resolution though that is a little more difficult as generally if there is a compensation that can be taken we'll do so automatically. Otherwise the only option is for the user to modify their sql, typically to use different predicates. > Add Problem/Resolution to query problem using the query plan > ------------------------------------------------------------ > > Key: TEIID-2052 > URL: https://issues.redhat.com/browse/TEIID-2052 > Project: Teiid > Issue Type: Enhancement > Components: Documentation > Affects Versions: 7.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Optional > Attachments: INClauseNotPushedDown.odt > > > Adding content that could be used for query problem resolution. The initial attachment does the following: > - states the query problem (i.e., not pushing down the "IN" clause) > - provides the query plan (and debug log) for the query being submitted > - provides recommendations for resolving the problem > - then indicates how this problem was resolved and what the resulting query plan / debug log > The idea here is to continue to add other problem scenarios so that this information is really useful for resolving issues. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3280) Embedded Teiid | VDB scoped translators

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-3280?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-3280. ----------------------------------- Fix Version/s: (was: 13.x) Resolution: Won't Fix Given that our bootable runtime support has moved to a single vdb paradigm, this will likely never get worked. > Embedded Teiid | VDB scoped translators > ----------------------------------------- > > Key: TEIID-3280 > URL: https://issues.redhat.com/browse/TEIID-3280 > Project: Teiid > Issue Type: Enhancement > Components: Embedded > Reporter: Shiveeta Mattoo > Assignee: Steven Hawkins > Priority: Minor > > - Translator instances, once created are applicable for all VDB deployment invocations. > - Seeking support for VDB scoped translators which could enable configuring properties for translators specific to VDB instances. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5526) Missing data source thorntail

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5526?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5526. ----------------------------------- Fix Version/s: (was: 13.x) Resolution: Won't Fix > Missing data source thorntail > ----------------------------- > > Key: TEIID-5526 > URL: https://issues.redhat.com/browse/TEIID-5526 > Project: Teiid > Issue Type: Quality Risk > Components: thorntail > Reporter: Steven Hawkins > Priority: Minor > > If you define a vdb and there is a source for which a jndi name is not matched with a data source from the configuration, the vdb will still be deployed, but won't be active - and there is no indication in the default console log as to the progress or lack thereof with the metadata load. > Given the presumed static nature of thorntail deployments, this scenario should result in a failed deployment like embedded. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5895) Create common mongodb logic

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5895?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5895: --------------------------------------- Partially completed with TEIID-5611. > Create common mongodb logic > --------------------------- > > Key: TEIID-5895 > URL: https://issues.redhat.com/browse/TEIID-5895 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 14.0 > > > Similar to the refactoring of infinispan connectivity, the logic should be shared between teiid and teiid spring boot. As well as a review of similar potential issues with the join filtering and TEIID-5876 -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2020