April 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4646) Add engine support for lead/lag aggregate functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4646?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4646. ----------------------------------- Resolution: Done Added lead/lag/first_value/last_value support. A new capability was not added as all existing sources that support ELEMENTARY_OLAP also support these functions. > Add engine support for lead/lag aggregate functions > --------------------------------------------------- > > Key: TEIID-4646 > URL: https://issues.jboss.org/browse/TEIID-4646 > Project: Teiid > Issue Type: Enhancement > Components: Grammar, JDBC Connector, Misc. Connectors, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > Lead/lag and first_value/last_value analytical function support should be added to the engine with appropriate pushdown support. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4864) Excel translator does not update document

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIID-4864?page=com.atlassian.jira.plugin... ] Michael Echevarria updated TEIID-4864: -------------------------------------- Issue Type: Enhancement (was: Bug) Description: *Changed to enhancement* When attempting to update a row that is in an excel source, an Unsupported Execution createUpdateExecution is thrown. Source file and log attached was: When attempting to update a row that is in an excel source, an Unsupported Execution createUpdateExecution is thrown. Source file and log attached > Excel translator does not update document > ----------------------------------------- > > Key: TEIID-4864 > URL: https://issues.jboss.org/browse/TEIID-4864 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.12.9.6_3 > Environment: JDV 6.3.4 > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Attachments: colors.xlsx, error.log > > > *Changed to enhancement* > When attempting to update a row that is in an excel source, an Unsupported Execution createUpdateExecution is thrown. > Source file and log attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4864) Excel translator does not update document

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4864?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4864: ------------------------------------- Excel translator does not support updates currently. It would be some what major enhancement to provide that. Most of times we have not seen users wanting to create/update Excel documents using Teiid. But surely you can convert this to an Enhancement request. > Excel translator does not update document > ----------------------------------------- > > Key: TEIID-4864 > URL: https://issues.jboss.org/browse/TEIID-4864 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.9.6_3 > Environment: JDV 6.3.4 > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Attachments: colors.xlsx, error.log > > > When attempting to update a row that is in an excel source, an Unsupported Execution createUpdateExecution is thrown. > Source file and log attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4864) Excel translator does not update document

by Michael Echevarria (JIRA)

Michael Echevarria created TEIID-4864: ----------------------------------------- Summary: Excel translator does not update document Key: TEIID-4864 URL: https://issues.jboss.org/browse/TEIID-4864 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.9.6_3 Environment: JDV 6.3.4 Reporter: Michael Echevarria Assignee: Steven Hawkins Attachments: colors.xlsx, error.log When attempting to update a row that is in an excel source, an Unsupported Execution createUpdateExecution is thrown. Source file and log attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4858) hive translator is extremely slow

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIID-4858?page=com.atlassian.jira.plugin... ] Michael Echevarria commented on TEIID-4858: ------------------------------------------- Added the teiid command logs for both queries with the 30 second delay in the slow.log. If that is not the source query for each how would I find it? > hive translator is extremely slow > --------------------------------- > > Key: TEIID-4858 > URL: https://issues.jboss.org/browse/TEIID-4858 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.9.6_3 > Environment: Tested against JDV 6.3.4 and the Cloudera quickstart 5.8 VM with the Cloudera sample data loaded into hive > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Attachments: fast.log, slow.log > > > When querying a table through the hive translator the results take close to 30 seconds to return. > When querying a table through jdbc default results take under 1 second to return. > Both use the same underlying jboss server datasource. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4858) hive translator is extremely slow

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIID-4858?page=com.atlassian.jira.plugin... ] Michael Echevarria updated TEIID-4858: -------------------------------------- Attachment: slow.log > hive translator is extremely slow > --------------------------------- > > Key: TEIID-4858 > URL: https://issues.jboss.org/browse/TEIID-4858 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.9.6_3 > Environment: Tested against JDV 6.3.4 and the Cloudera quickstart 5.8 VM with the Cloudera sample data loaded into hive > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Attachments: fast.log, slow.log > > > When querying a table through the hive translator the results take close to 30 seconds to return. > When querying a table through jdbc default results take under 1 second to return. > Both use the same underlying jboss server datasource. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4858) hive translator is extremely slow

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIID-4858?page=com.atlassian.jira.plugin... ] Michael Echevarria updated TEIID-4858: -------------------------------------- Attachment: fast.log > hive translator is extremely slow > --------------------------------- > > Key: TEIID-4858 > URL: https://issues.jboss.org/browse/TEIID-4858 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.9.6_3 > Environment: Tested against JDV 6.3.4 and the Cloudera quickstart 5.8 VM with the Cloudera sample data loaded into hive > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Attachments: fast.log, slow.log > > > When querying a table through the hive translator the results take close to 30 seconds to return. > When querying a table through jdbc default results take under 1 second to return. > Both use the same underlying jboss server datasource. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4858) hive translator is extremely slow

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4858?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4858: --------------------------------------- What is the source query in each case? Other than supporting additional push down constructs, the execution / retrieval logic will be the same between those two. > hive translator is extremely slow > --------------------------------- > > Key: TEIID-4858 > URL: https://issues.jboss.org/browse/TEIID-4858 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.9.6_3 > Environment: Tested against JDV 6.3.4 and the Cloudera quickstart 5.8 VM with the Cloudera sample data loaded into hive > Reporter: Michael Echevarria > Assignee: Steven Hawkins > > When querying a table through the hive translator the results take close to 30 seconds to return. > When querying a table through jdbc default results take under 1 second to return. > Both use the same underlying jboss server datasource. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4646) Add engine support for lead/lag aggregate functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4646?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4646: --------------------------------------- [~blafond] This change does not alter the javacc grammar, but it does introduce new resolver and validation logic to ensure that the functions match the expected usage pattern, so this is marked as affecting the grammar. > Add engine support for lead/lag aggregate functions > --------------------------------------------------- > > Key: TEIID-4646 > URL: https://issues.jboss.org/browse/TEIID-4646 > Project: Teiid > Issue Type: Enhancement > Components: Grammar, JDBC Connector, Misc. Connectors, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > Lead/lag and first_value/last_value analytical function support should be added to the engine with appropriate pushdown support. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4858) hive translator is extremely slow

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIID-4858?page=com.atlassian.jira.plugin... ] Michael Echevarria commented on TEIID-4858: ------------------------------------------- Only difference I can see is the Execution Factory. Simple returns quickly where Hive takes 30+ seconds. *SimpleJDBCExecutionFactory* Commit=true;DatabaseProductName=Apache Hive;DatabaseProductVersion=1.1.0-cdh5.8.0;DriverMajorVersion=2;DriverMajorVersion=5;DriverName=HiveJDBC;DriverVersion=02.05.18.1050;IsolationLevel=1 *HiveExecutionFactory* Commit=true;DatabaseProductName=Apache Hive;DatabaseProductVersion=1.1.0-cdh5.8.0;DriverMajorVersion=2;DriverMajorVersion=5;DriverName=HiveJDBC;DriverVersion=02.05.18.1050;IsolationLevel=1 > hive translator is extremely slow > --------------------------------- > > Key: TEIID-4858 > URL: https://issues.jboss.org/browse/TEIID-4858 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.9.6_3 > Environment: Tested against JDV 6.3.4 and the Cloudera quickstart 5.8 VM with the Cloudera sample data loaded into hive > Reporter: Michael Echevarria > Assignee: Steven Hawkins > > When querying a table through the hive translator the results take close to 30 seconds to return. > When querying a table through jdbc default results take under 1 second to return. > Both use the same underlying jboss server datasource. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 11 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 April 2017