October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3253) Expand allowed order by expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3253?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3253. --------------------------------- > Expand allowed order by expressions > ----------------------------------- > > Key: TEIID-3253 > URL: https://issues.jboss.org/browse/TEIID-3253 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > with a non-simple query we won't allow derived expressions in the order by such as: > select max\(x), y from t group by y order by case when y is null then 0 else y end > We treat this ordering as unrelated - however it is expressed in terms of expressions from the select clause. Mondrian will generate queries of this form, which requires a workaround of modifying the dialect to use ansi null ordering. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3098) allow pushdown functions to be used by designer import

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3098?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3098. --------------------------------- > allow pushdown functions to be used by designer import > ------------------------------------------------------ > > Key: TEIID-3098 > URL: https://issues.jboss.org/browse/TEIID-3098 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.9 > > > allow pushdown functions to be schema scoped or some other mechanism for the purpose of designer metadata import. If schema scoped, this will require supporting logic that such functions when imported for multiple sources will not be seen as duplicates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3282) inconsistencies with the week function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3282?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3282. --------------------------------- > inconsistencies with the week function > -------------------------------------- > > Key: TEIID-3282 > URL: https://issues.jboss.org/browse/TEIID-3282 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > For consistency we could enforce a standard iso behavior for the week function by default. > For mysql there is the weekofyear function that matches the iso behavior. > hsql uses iso by default > oracle should use iw, not ww > However: > h2 uses the locale (the current teiid behavior) > sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso. > And there are still several others to verify -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1091) Add remaining SQL/XML functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1091?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1091. --------------------------------- > Add remaining SQL/XML functions > ------------------------------- > > Key: TEIID-1091 > URL: https://issues.jboss.org/browse/TEIID-1091 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Affects Versions: 7.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > We should add the remaining functions, xmlparse, xmlserialize, xmlroot, etc. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3224) MongoDB: support direct query execution for Shell type command

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3224?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3224. --------------------------------- > MongoDB: support direct query execution for Shell type command > -------------------------------------------------------------- > > Key: TEIID-3224 > URL: https://issues.jboss.org/browse/TEIID-3224 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: tu nguyen > Assignee: Ramesh Reddy > Labels: Alpaha1 > Fix For: 8.10 > > > Use case: to support external mat view in mongoDB, we need to execute query such as: db.collection.remove({}), db.collection.copyTo() to delete & rename staging table. > Teiid currently only support aggregate query: https://issues.jboss.org/browse/TEIID-2740 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3170) Change build to include spring framework jar dependencies for WS translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3170?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3170. --------------------------------- > Change build to include spring framework jar dependencies for WS translator > --------------------------------------------------------------------------- > > Key: TEIID-3170 > URL: https://issues.jboss.org/browse/TEIID-3170 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.7.1, 8.9 > > > The "org.springframework.spring" module and dependent jars will be added to the kit. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3714) update webservice example to show how to invoke wsdl base procedures and swagger json based procedures

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3714?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3714: ---------------------------------- Component/s: Quick Starts > update webservice example to show how to invoke wsdl base procedures and swagger json based procedures > ------------------------------------------------------------------------------------------------------ > > Key: TEIID-3714 > URL: https://issues.jboss.org/browse/TEIID-3714 > Project: Teiid > Issue Type: Feature Request > Components: Quick Starts > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.12 > > > Teiid WS translator support invoke WSDL based procedure via WSDLMetadatProcessor and WSWSDLProcedureExecution; TEIID-3520 will add similar function for rest webservice. This issue will update webservice example to show: > * how to invoke wsdl base procedures > * how to invoke swagger json based procedures -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3714) update webservice example to show how to invoke wsdl base procedures and swagger json based procedures

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3714?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3714: ---------------------------------- Fix Version/s: 8.12 > update webservice example to show how to invoke wsdl base procedures and swagger json based procedures > ------------------------------------------------------------------------------------------------------ > > Key: TEIID-3714 > URL: https://issues.jboss.org/browse/TEIID-3714 > Project: Teiid > Issue Type: Feature Request > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 8.12 > > > Teiid WS translator support invoke WSDL based procedure via WSDLMetadatProcessor and WSWSDLProcedureExecution; TEIID-3520 will add similar function for rest webservice. This issue will update webservice example to show: > * how to invoke wsdl base procedures > * how to invoke swagger json based procedures -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3131) Broaden aggregate decomposition scenarios

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3131?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3131. --------------------------------- > Broaden aggregate decomposition scenarios > ----------------------------------------- > > Key: TEIID-3131 > URL: https://issues.jboss.org/browse/TEIID-3131 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > Aggregate decomposition is currently inhibited by outer joins and for count(\*). These limitations could be removed with more work. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2842) Impala/ HIVE2: Unsupported compress file

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2842?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2842. --------------------------------- > Impala/ HIVE2: Unsupported compress file > ----------------------------------------- > > Key: TEIID-2842 > URL: https://issues.jboss.org/browse/TEIID-2842 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: Impala/HIVE2 with Teiid > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: teiid > Fix For: 8.7 > > > Teiid makes a query call "Describe table" in HiveMetadataProcessor.addTable(....). However, if the table contains compress file, HIVE2 driver would return the following execption: > {code} > java.sql.SQLException: AnalysisException: Failed to load metadata for table: default.omniturelogs > CAUSED BY: TableLoadingException: Failed to load metadata for table: > omniturelogs > CAUSED BY: RuntimeException: Compressed text files are not supported: hdfs://localhost.localdomain:8020/user/cloudera/omniturelogs/Omniture.0.tsv.gz > at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:161) > at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:149) > at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:182) > at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:246) > at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) > at org.teiid.translator.hive.HiveMetadataProcessor.addTable(HiveMetadataProcessor.java:112) > at org.teiid.translator.hive.HiveMetadataProcessor.getConnectorMetadata(HiveMetadataProcessor.java:48) > > at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:311) > ... 155 more > {code} > Maybe Teiid should call "DESCRIBE FORMATTED table" for table that contains compress file. > Reference: > http://grokbase.com/t/cloudera/impala-user/13b7c9apmx/impala-failed-to-qu... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2015