June 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5937: --------------------------------------- > Could you please so kind as to check these queries in the description section above? Yes, I see that. The fix addressed a narrower form. The problem is the reliance on output cols in rule merge virtual - they are initially set correctly, but will not be updated as the tree is modified by removing view layers. > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 13.1, 14.0, 13.0.3 > > Original Estimate: 4 hours > Time Spent: 3 hours > Remaining Estimate: 1 hour > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Dmitrii Pogorelov (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Dmitrii Pogorelov edited comment on TEIID-5937 at 6/8/20 12:25 PM: ------------------------------------------------------------------- [~shawkins] that's strange but I applied all your changes in Teiid 13.1 version and still get null value instead of "1". Could you please so kind as to check these queries in the description section above? was (Author: dalex005): [~shawkins] that's strange but I applied all your changes in Teiid 13.1 version and still get null value instead of "1". > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 13.1, 14.0, 13.0.3 > > Original Estimate: 4 hours > Time Spent: 3 hours > Remaining Estimate: 1 hour > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Dmitrii Pogorelov (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Dmitrii Pogorelov commented on TEIID-5937: ------------------------------------------ [~shawkins] that's strange but I applied all your changes in Teiid 13.1 version and still get null value instead of "1". > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 13.1, 14.0, 13.0.3 > > Original Estimate: 4 hours > Time Spent: 3 hours > Remaining Estimate: 1 hour > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years

1
0
0 / 0

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

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-3647?page=com.atlassian.jira.plugi... ] Ramesh Reddy updated TEIID-3647: -------------------------------- Sprint: DV Sprint 65 > Create native connector to interact with HDFS as a datasource > ------------------------------------------------------------- > > Key: TEIID-3647 > URL: https://issues.redhat.com/browse/TEIID-3647 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Priority: Major > Fix For: 15.0 > > > 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.13.8#713008)

4 years

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: ---------------------------------- Original Estimate: 5 hours Remaining Estimate: 5 hours Git Pull Request: https://github.com/teiid/teiid/pull/1285 Story Points: 1 Sprint: DV Sprint 65 It seemed like a good idea to try and tackle this before pulling the functionality into teiid spring boot. The proposed change is to add a config property spreadsheetMap that will take a url like key/value pair list - prefix1=sheetid1;prefix2=sheetid2... This precludes the teiid name prefix from containing = or ;, but that seems acceptable. On import we'll add the each worksheet as prefix + sheet title. That ensures there can be no collisions across spreadsheets. If the user specifies on spreadsheetId in the config, it will still work as before and import with an empty prefix. The functionality is only added for the v4 api. On a side note it an alternative design to the current is to use extension metadata on each table representing a sheet - we need to know the sheet id, work sheet id, and title (which could default to the table name). That would allow the translator to work more independently of the source. A reason for not doing that possibly is so that you could differentiate between different sheets (testing vs. prod) by just changing a source property, rather than adjusting the metadata. > 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: 15.0 > > Original Estimate: 5 hours > Remaining Estimate: 5 hours > > 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

1
0
0 / 0

[JBoss JIRA] (TEIID-5963) Teiid using all typeInfo takes too long from PG

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5963: ---------------------------------- Summary: Teiid using all typeInfo takes too long from PG (was: Teiid imported all schemas from PG) > Teiid using all typeInfo takes too long from PG > ----------------------------------------------- > > Key: TEIID-5963 > URL: https://issues.redhat.com/browse/TEIID-5963 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 14.0 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > When we started teiid spring boot app, we have long start time. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5963) Teiid using all typeInfo takes too long from PG

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugi... ] Work on TEIID-5963 started by Steven Hawkins. --------------------------------------------- > Teiid using all typeInfo takes too long from PG > ----------------------------------------------- > > Key: TEIID-5963 > URL: https://issues.redhat.com/browse/TEIID-5963 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 14.0 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > When we started teiid spring boot app, we have long start time. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years

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: 15.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

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-206?focusedWorklogId=12451232&pa... ] Steven Hawkins logged work on TEIIDSB-206: ------------------------------------------ Author: Steven Hawkins Created on: 05/Jun/20 9:59 AM Start Date: 05/Jun/20 9:59 AM Worklog Time Spent: 2 hours, 30 minutes Work Description: Time spent working with Aditya and updating the VirtualFile interface. Issue Time Tracking ------------------- Remaining Estimate: 2 days, 1 hour, 30 minutes (was: 2 days, 4 hours) Time Spent: 2 hours, 30 minutes Worklog Id: (was: 12451232) > Create native connector to interact with HDFS as a datasource > ------------------------------------------------------------- > > Key: TEIIDSB-206 > URL: https://issues.redhat.com/browse/TEIIDSB-206 > Project: Teiid Spring Boot > Issue Type: Feature Request > Components: datasource > Reporter: Van Halbert > Assignee: Aditya Manglam Sharma > Priority: Major > Fix For: 1.6.0 > > Original Estimate: 2 days, 4 hours > Time Spent: 2 hours, 30 minutes > Remaining Estimate: 2 days, 1 hour, 30 minutes > > 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.13.8#713008)

4 years

1
0
0 / 0

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-206?page=com.atlassian.jira.plug... ] Steven Hawkins updated TEIIDSB-206: ----------------------------------- Original Estimate: 2 days, 4 hours Remaining Estimate: 2 days, 4 hours Story Points: 3 Sprint: DV Sprint 64 > Create native connector to interact with HDFS as a datasource > ------------------------------------------------------------- > > Key: TEIIDSB-206 > URL: https://issues.redhat.com/browse/TEIIDSB-206 > Project: Teiid Spring Boot > Issue Type: Feature Request > Components: datasource > Reporter: Van Halbert > Assignee: Aditya Manglam Sharma > Priority: Major > Fix For: 1.6.0 > > Original Estimate: 2 days, 4 hours > Remaining Estimate: 2 days, 4 hours > > 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.13.8#713008)

4 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2020