April 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2931) Perform equi-join full outer joins in a streaming manner

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2931?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2931: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1089704 > Perform equi-join full outer joins in a streaming manner > -------------------------------------------------------- > > Key: TEIID-2931 > URL: https://issues.jboss.org/browse/TEIID-2931 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.8 > > > A pass to compute the right outer matches is only needed when there is non-equi join criteria, since we'll already have determined the right outer values that fail to match the equi-join predicates on the first pass. Note that second passes are limited only to the match regions, but we don't have effective buffering logic for that so we just fully buffer each side. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2893) Add support for EAP 6.2/6.3

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2893?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-2893: ----------------------------------- Assignee: Ramesh Reddy > Add support for EAP 6.2/6.3 > --------------------------- > > Key: TEIID-2893 > URL: https://issues.jboss.org/browse/TEIID-2893 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits, Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Blocker > Fix For: 8.7.1 > > > Add support for EAP 6.2 or 6.3. The final version will not be known until EAP 6.3 release date is known. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2893) Add support for EAP 6.2/6.3

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2893?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2893: ---------------------------------- Assignee: (was: Steven Hawkins) > Add support for EAP 6.2/6.3 > --------------------------- > > Key: TEIID-2893 > URL: https://issues.jboss.org/browse/TEIID-2893 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits, Server > Affects Versions: 8.7.1 > Reporter: Van Halbert > Priority: Blocker > Fix For: 8.7.1 > > > Add support for EAP 6.2 or 6.3. The final version will not be known until EAP 6.3 release date is known. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2885) Allow dependent join pushdown to be chosen by the planner

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2885?page=com.atlassian.jira.plugin... ] Work on TEIID-2885 started by Steven Hawkins. > Allow dependent join pushdown to be chosen by the planner > --------------------------------------------------------- > > Key: TEIID-2885 > URL: https://issues.jboss.org/browse/TEIID-2885 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1 > > > As a follow on to TEIID-2249, the planner should be able to choose when to use full join pushdown, rather than only relying upon a hint. One downside to this currently is that there isn't a good way to do a back off to a different join processing (unless we embedded an alternative plan) and so we may have to add failure logic if too many independent values are retrieved. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1896) incorrect xml generated from jsontoxml with nested arrays

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1896?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1896. --------------------------------- > incorrect xml generated from jsontoxml with nested arrays > --------------------------------------------------------- > > Key: TEIID-1896 > URL: https://issues.jboss.org/browse/TEIID-1896 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.0, 7.7.9 > > > Non-root arrays are being nested, which is against the expectation defined in the reference. Instead of: > <root> > <x> > <x>1</x> > <x>1</x> > </x> > </root> > it should be: > <root> > <x>1</x> > <x>1</x> > </root> -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2714) Buffer defrag not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2714?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2714. --------------------------------- > Buffer defrag not working > ------------------------- > > Key: TEIID-2714 > URL: https://issues.jboss.org/browse/TEIID-2714 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6, 7.7.9 > > > The defrag task is not working as expected because the header values are written by an object output stream - and not as standalone values into the block data. > For most data usage patterns this isn't an issue as the storage files are self compacting over time due to low block assignments. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2863) Allow both gssapi and username/password authentication on the same transport

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2863?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2863. --------------------------------- > Allow both gssapi and username/password authentication on the same transport > ---------------------------------------------------------------------------- > > Key: TEIID-2863 > URL: https://issues.jboss.org/browse/TEIID-2863 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 8.7 > > Attachments: auth.patch > > > With GSSAPI support enabled, username/password support on the same transport is effectively disabled. JDBC/ODBC should ideally support both on the same transport. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2814) HIVE: quote is removed for TIMESTAMP field in where clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2814?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2814. --------------------------------- > HIVE: quote is removed for TIMESTAMP field in where clause > ----------------------------------------------------------- > > Key: TEIID-2814 > URL: https://issues.jboss.org/browse/TEIID-2814 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: HIVE and Teiid 8.6 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > Fix For: 8.4.2, 8.7 > > > I am running teiid 8.6 against HIVE. And I found out that quote was removed for TIMESTAMP field in where clause. And it caused java.sql.SQLException: Error while processing statement: FAILED: ParseException line 1:88 missing EOF > Original SQL: > select "the_date", > "store_sales" > from "hive2"."sales_seq" > where ("the_date" > '1970-05-16 00:10:04') > Teiid generated SQL: > SELECT g_0.the_date, g_0.store_sales FROM sales_seq g_0 WHERE g_0.the_date > 1970-05-16 00:10:04.0 > Exception: > Caused by: java.sql.SQLException: Error while processing statement: FAILED: > ParseException line 1:88 missing EOF at '00' near '16' -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2728) Very large sorts are inefficient

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2728?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2728. --------------------------------- > Very large sorts are inefficient > -------------------------------- > > Key: TEIID-2728 > URL: https://issues.jboss.org/browse/TEIID-2728 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.6 > > > This is a regression of TEIID-2429. When the memory space needed for a sort is estimated to be above 2 GB, the expression used (even though it's assigned to a long) will overflow. This then causes the processing to use the batch size as the intermediate sort buffer size, which for any high row count will lead to many passes (the logic typically should achieve at most a two pass sort). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2862) index out of bounds when a union branch with limit/order by is removed

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2862?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2862. --------------------------------- > index out of bounds when a union branch with limit/order by is removed > ---------------------------------------------------------------------- > > Key: TEIID-2862 > URL: https://issues.jboss.org/browse/TEIID-2862 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7 > > > When the first union branch is removed and the other branch contains a limit/order by, then the logic that should be updating the parent order by instead uses the child. This results in an index out of bounds exception. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2014