[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, 6 months
[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, 6 months
[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, 6 months
[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, 6 months
[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, 6 months
[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, 6 months