June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4250) Add translator to support Google Cloud Bigtable

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4250?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4250: ------------------------------- Description: Add translator to support Google Cloud Bigtable > Add translator to support Google Cloud Bigtable > ------------------------------------------------ > > Key: TEIID-4250 > URL: https://issues.jboss.org/browse/TEIID-4250 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Steven Hawkins > > Add translator to support Google Cloud Bigtable -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4250) Add translator to support Google Cloud Bigtable

by Van Halbert (JIRA)

Van Halbert created TEIID-4250: ---------------------------------- Summary: Add translator to support Google Cloud Bigtable Key: TEIID-4250 URL: https://issues.jboss.org/browse/TEIID-4250 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Affects Versions: 9.x Reporter: Van Halbert Assignee: Steven Hawkins -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4249) Materialization Improvements

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-4249: ----------------------------------- Summary: Materialization Improvements Key: TEIID-4249 URL: https://issues.jboss.org/browse/TEIID-4249 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Ramesh Reddy This JIRA will be bucket JIRA for the Meterialization improvements -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4248) Build change for 8.13 caused the release notes to miss the version replacement

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4248: ------------------------------------- Summary: Build change for 8.13 caused the release notes to miss the version replacement Key: TEIID-4248 URL: https://issues.jboss.org/browse/TEIID-4248 Project: Teiid Issue Type: Bug Components: Documentation Affects Versions: 8.13 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 9.0 Substitution is not happening for the release notes: http://docs.jboss.org/teiid/8.13.0.Final/teiid-releasenotes.html -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4247) OData - support date and time functions

by Andrej Šmigala (JIRA)

Andrej Šmigala created TEIID-4247: ------------------------------------- Summary: OData - support date and time functions Key: TEIID-4247 URL: https://issues.jboss.org/browse/TEIID-4247 Project: Teiid Issue Type: Feature Request Components: OData Affects Versions: 8.12.x Reporter: Andrej Šmigala Assignee: Steven Hawkins The functions date() and time() are currently not supported in odata queries, e.g. running query {noformat}http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable?$filter=timeval%20gt%20time(now()){noformat} returns {code:xml} <?xml version='1.0' encoding='UTF-8'?> <error xmlns="http://docs.oasis-open.org/odata/ns/metadata"> <code>TEIID16027</code> <message>TEIID16027 Function time is not currently supported </message> </error> {code} This is allowed behaviour per the [odata spec|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/par...], but it would be good to have these functions implemented. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4246) HANA translator: boolean column is not valid boolean expression in HANA

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4246?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4246: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1343573 Bugzilla Update: Perform > HANA translator: boolean column is not valid boolean expression in HANA > ----------------------------------------------------------------------- > > Key: TEIID-4246 > URL: https://issues.jboss.org/browse/TEIID-4246 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Priority: Critical > > SAP HANA does not take boolean column or literal as boolean expressions. > Query like this won't pass (invoked on HANA directly): > {code:sql} > SELECT (CASE WHEN BooleanValue THEN 'a' ELSE 'b' END) FROM BQT1.smalla; > {code} > The following could serve as workaround (invoked on HANA directly): > {code:sql} > SELECT (CASE WHEN BooleanValue=true THEN 'a' ELSE 'b' END) FROM BQT1.smalla; > {code} > The problem is observable when using boolean column in string function (invoked on Teiid): > {code:sql} > SELECT INTKEY, ('test+' || (BOOLEANVALUE || '+test')) FROM BQT1.SmallA ORDER BY IntKey > {code} > Which results in following error: > {code:sql} > TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 HanaSource: 257 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."INTKEY" AS c_0, concat('test+', concat(CASE WHEN g_0."BOOLEANVALUE" THEN 'true' WHEN not(g_0."BOOLEANVALUE") THEN 'false' END, '+test')) AS c_1 FROM "BQT1"."SMALLA" AS g_0 ORDER BY c_0] > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4246) HANA translator: boolean column is not valid boolean expression in HANA

by Jan Stastny (JIRA)

Jan Stastny created TEIID-4246: ---------------------------------- Summary: HANA translator: boolean column is not valid boolean expression in HANA Key: TEIID-4246 URL: https://issues.jboss.org/browse/TEIID-4246 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.5 Reporter: Jan Stastny Assignee: Steven Hawkins Priority: Critical SAP HANA does not take boolean column or literal as boolean expressions. Query like this won't pass (invoked on HANA directly): {code:sql} SELECT (CASE WHEN BooleanValue THEN 'a' ELSE 'b' END) FROM BQT1.smalla; {code} The following could serve as workaround (invoked on HANA directly): {code:sql} SELECT (CASE WHEN BooleanValue=true THEN 'a' ELSE 'b' END) FROM BQT1.smalla; {code} The problem is observable when using boolean column in string function (invoked on Teiid): {code:sql} SELECT INTKEY, ('test+' || (BOOLEANVALUE || '+test')) FROM BQT1.SmallA ORDER BY IntKey {code} Which results in following error: {code:sql} TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 HanaSource: 257 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."INTKEY" AS c_0, concat('test+', concat(CASE WHEN g_0."BOOLEANVALUE" THEN 'true' WHEN not(g_0."BOOLEANVALUE") THEN 'false' END, '+test')) AS c_1 FROM "BQT1"."SMALLA" AS g_0 ORDER BY c_0] {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4245: ---------------------------------- Fix Version/s: 9.1 > Add support for fetch syntax "FETCH cursorname" > ----------------------------------------------- > > Key: TEIID-4245 > URL: https://issues.jboss.org/browse/TEIID-4245 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1 > > > Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround. > [1] > org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1. > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

by Marc Shirley (JIRA)

Marc Shirley created TEIID-4245: ----------------------------------- Summary: Add support for fetch syntax "FETCH cursorname" Key: TEIID-4245 URL: https://issues.jboss.org/browse/TEIID-4245 Project: Teiid Issue Type: Feature Request Components: ODBC Reporter: Marc Shirley Assignee: Steven Hawkins Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround. [1] org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1. Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4244) Assertion failed error when joining duplicate rows to a table from other source

by dalex dalex (JIRA)

[ https://issues.jboss.org/browse/TEIID-4244?page=com.atlassian.jira.plugin... ] dalex dalex commented on TEIID-4244: ------------------------------------ [~shawkins] thx a lot for the quick fix. > Assertion failed error when joining duplicate rows to a table from other source > ------------------------------------------------------------------------------- > > Key: TEIID-4244 > URL: https://issues.jboss.org/browse/TEIID-4244 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Fix For: 9.0, 8.13.6 > > > I get the following error when joining duplicate rows to a table from other source: > {code} > 17:20:52,718 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue21) irzl30n7Sda0 TEIID30019 Unexpected exception for request irzl30n7Sda0.8: java.lang.AssertionError: ASSERTION > FAILED: expected reference to be not null > at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) [teiid-common-core-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) [teiid-common-core-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:286) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.getBatch(TupleBuffer.java:74) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:62) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.MergeJoinStrategy.compareToPrevious(MergeJoinStrategy.java:279) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:237) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:416) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:148) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:344) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.0.Beta1.jar:8.12.0.Beta1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67] > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 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 June 2016