September 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4443) STRING_AGG should not be decomposable

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4443?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4443: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1375354, https://bugzilla.redhat.com/show_bug.cgi?id=1375355 Bugzilla Update: Perform > STRING_AGG should not be decomposable > ------------------------------------- > > Key: TEIID-4443 > URL: https://issues.jboss.org/browse/TEIID-4443 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > AggregateSymbol.canStage is returning true for string_agg - even though that is not correct, which can lead to an arrayindexoutofbounds exception when evaluating the final value based upon the partial as no separator will be in the tuple. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4443) STRING_AGG should not be decomposable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4443?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4443. ----------------------------------- Resolution: Done Updated the canStage logic. > STRING_AGG should not be decomposable > ------------------------------------- > > Key: TEIID-4443 > URL: https://issues.jboss.org/browse/TEIID-4443 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > AggregateSymbol.canStage is returning true for string_agg - even though that is not correct, which can lead to an arrayindexoutofbounds exception when evaluating the final value based upon the partial as no separator will be in the tuple. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4443) STRING_AGG should not be decomposable

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4443: ------------------------------------- Summary: STRING_AGG should not be decomposable Key: TEIID-4443 URL: https://issues.jboss.org/browse/TEIID-4443 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 AggregateSymbol.canStage is returning true for string_agg - even though that is not correct, which can lead to an arrayindexoutofbounds exception when evaluating the final value based upon the partial as no separator will be in the tuple. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4442) Remove option to allow for multiple security domains

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4442: ------------------------------------- Summary: Remove option to allow for multiple security domains Key: TEIID-4442 URL: https://issues.jboss.org/browse/TEIID-4442 Project: Teiid Issue Type: Quality Risk Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 The session service logic for backwards compatibility allow for multiple security domains to be configured by default. However that is deprecated logic and should not be allowed anymore. We could also add a system function / option so that the user function returns just the simple name without the at domain suffix. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4435) HIVE: decimal datatype is treated like a string

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4435?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4435. ----------------------------------- Fix Version/s: 9.1 9.0.4 Resolution: Done The issue is that the type name is being reported with the precision/scale, which the importer wasn't looking for. A workaround, and potentially better solution, is to use the import.useDatabaseMetaData option to use the standard JDBC metadata for the import now that the client has matured. > HIVE: decimal datatype is treated like a string > ------------------------------------------------ > > Key: TEIID-4435 > URL: https://issues.jboss.org/browse/TEIID-4435 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.3 > Environment: Connecting through HIVE > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.4 > > > Teiid maps Decimal column (DECIMAL(9,4)) to "java.lang.String" when using org.teiid.translator.hive.HiveExecutionFactory. I would expect it to map to "java.math.BigDecimal" or something else. > Here is my table: > CREATE TABLE tableWithAllTypes(column_bigint BIGINT, column_boolean BOOLEAN, column_char CHAR(1), column_decimal DECIMAL(9,4), column_double DOUBLE, column_float FLOAT, column_int INT, column_smallint SMALLINT, column_string STRING, column_timestamp TIMESTAMP, column_tinyint TINYINT, column_varchar VARCHAR(64)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4439) salesforce-34 translator dependencies issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4439?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4439. ----------------------------------- Resolution: Done Used the execution factory class to override version specific behavior. > salesforce-34 translator dependencies issues > --------------------------------------------- > > Key: TEIID-4439 > URL: https://issues.jboss.org/browse/TEIID-4439 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12, 9.0.3 > Environment: wildfly 10.0.0.Final and teiid-9.1.0.Beta1 > Reporter: Thomas Esche > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.4 > > > Issues if using salesforce-34: As soon as one use a WHERE condition to select a certain ID, the v34 version throws the following exception: > {{java.lang.NoSuchMethodError: Remote java.lang.NoSuchMethodError: com.sforce.soap.partner.QueryResult.setRecords([Lcom/sforce/soap/partner/sobject/SObject;>V > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.retrieve(SalesforceConnectionImpl.java:456) > at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:206) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:367) > ...}} > See discussion: > [https://developer.jboss.org/thread/272248] -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4439) salesforce-34 translator dependencies issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4439?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4439: ---------------------------------- Fix Version/s: 9.1 9.0.4 Affects Version/s: 8.12 > salesforce-34 translator dependencies issues > --------------------------------------------- > > Key: TEIID-4439 > URL: https://issues.jboss.org/browse/TEIID-4439 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12, 9.0.3 > Environment: wildfly 10.0.0.Final and teiid-9.1.0.Beta1 > Reporter: Thomas Esche > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.4 > > > Issues if using salesforce-34: As soon as one use a WHERE condition to select a certain ID, the v34 version throws the following exception: > {{java.lang.NoSuchMethodError: Remote java.lang.NoSuchMethodError: com.sforce.soap.partner.QueryResult.setRecords([Lcom/sforce/soap/partner/sobject/SObject;>V > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.retrieve(SalesforceConnectionImpl.java:456) > at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:206) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:367) > ...}} > See discussion: > [https://developer.jboss.org/thread/272248] -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4441) Add FTP/SFTP based access to the File Resource Adapter

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4441?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4441: -------------------------------- Description: This has been requested few times in the community, it would be nice to give provide this functionality. Using http://commons.apache.org/proper/commons-net/ seems to be right decision. (was: This has been requested few times in the community, it would be nice to give provide this functionality. ) > Add FTP/SFTP based access to the File Resource Adapter > ------------------------------------------------------ > > Key: TEIID-4441 > URL: https://issues.jboss.org/browse/TEIID-4441 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > > This has been requested few times in the community, it would be nice to give provide this functionality. Using http://commons.apache.org/proper/commons-net/ seems to be right decision. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4441) Add FTP/SFTP based access to the File Resource Adapter

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-4441: ----------------------------------- Summary: Add FTP/SFTP based access to the File Resource Adapter Key: TEIID-4441 URL: https://issues.jboss.org/browse/TEIID-4441 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Reporter: Ramesh Reddy Assignee: Steven Hawkins This has been requested few times in the community, it would be nice to give provide this functionality. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4440) Add an option to materialize common tables

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4440: ------------------------------------- Summary: Add an option to materialize common tables Key: TEIID-4440 URL: https://issues.jboss.org/browse/TEIID-4440 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 In addition to the no_inline hint, there should be a materialize hint to force a common table to be evaluated as a table, rather than eligible for partial pushdown. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 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 September 2016