December 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2738) Hive Translator does not utilize some or all of the Importer Properties.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2738?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2738. --------------------------------- > Hive Translator does not utilize some or all of the Importer Properties. > ------------------------------------------------------------------------- > > Key: TEIID-2738 > URL: https://issues.jboss.org/browse/TEIID-2738 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.6 > Reporter: Andy Yip > Assignee: Steven Hawkins > Fix For: 8.6 > > -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2732) Improve repeated string serialization performance

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2732?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2732. --------------------------------- > Improve repeated string serialization performance > ------------------------------------------------- > > Key: TEIID-2732 > URL: https://issues.jboss.org/browse/TEIID-2732 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6, 7.7.9 > > > In Teiid 7.5 we switched away from object serialization to writing every value to the serialization stream. This provides better performance for distinct/small values, but adds a significant amount of overhead compared to just object serialization for large and repeated values. -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2730) Cannot query Sybase database with jconn3.jar

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2730?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2730. --------------------------------- > Cannot query Sybase database with jconn3.jar > -------------------------------------------- > > Key: TEIID-2730 > URL: https://issues.jboss.org/browse/TEIID-2730 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.4 > Environment: java oracle 1.7, Teiid 8.4.1-redhat4 in DV 6.0.0.ER3, Teiid Designer 8.3.beta3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 8.6 > > Attachments: bqtHNB.vdb, bqt_HNB.xmi, jconn3.jar > > > In teiid designer, I created a connection profile to Sybase database with URL jdbc:sybase:Tds:vmg07.mw.lab.eng.bos.redhat.com:5000/bqt2 and driver jconn3.jar. > I created a relational source model from the jdbc connection and VDB with the source model. Then I deployed the VDB and executed query select * from "bqt_HNB"."g1" which resulted in this error message: > TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 bqt_HNB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."e1", g_0."e2" FROM "bqt2"."dbo"."g1" g_0] > Console: > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[bqt_HNB.g1.e1, bqt_HNB.g1.e2] SELECT g_0.e1, g_0.e2 FROM bqt_HNB.g1 AS g_0 > ============================================================================ > 10:55:07,362 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) SybaseExecutionFactory Commit=true;DatabaseProductName=Adaptive Server Enterprise;DatabaseProductVersion=Adaptive Server Enterprise/15.0.3/EBF 16549 ESD#1/P/x86_64/Enterprise Linux/ase1503/2681/64-bit/FBO/Mon Mar 9 04:10:47 2009;DriverMajorVersion=6;DriverMajorVersion=0;DriverName=jConnect (TM) for JDBC (TM);DriverVersion=jConnect (TM) for JDBC(TM)/6.05(Build 26564)/P/EBF16903/JDK14/Sun May 31 1:05:35 2009;IsolationLevel=2 > 10:55:07,555 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=dg2FpIhALlUI.0.0.0: org.teiid.translator.jdbc.JDBCExecutionException: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."e1", g_0."e2" FROM "bqt2"."dbo"."g1" g_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:254) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45] > at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2] > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45] > at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45] > Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near 'e1'. > at com.sybase.jdbc3.tds.Tds.a(Unknown Source) > at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) > at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) > at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) > at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) > at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source) > at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) > at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84) > ... 13 more > 10:55:07,568 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) TEIID30020 Processing exception for request dg2FpIhALlUI.0 'TEIID30504 bqt_HNB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."e1", g_0."e2" FROM "bqt2"."dbo"."g1" g_0]'. Originally TeiidProcessingException 'Incorrect syntax near 'e1'. > ' com.sybase.jdbc3.tds.Tds.a(Unknown Source). Enable more detailed logging to see the entire stacktrace. -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2743) XMLTable does not account for DST

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2743?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2743. --------------------------------- > XMLTable does not account for DST > --------------------------------- > > Key: TEIID-2743 > URL: https://issues.jboss.org/browse/TEIID-2743 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > The fix for TEIID-2112 does not consider DST server timezones. While it is not typically expected for a server to be running in DST, we should still handle this situation. -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2750) Improve handling of messages that are too large

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2750?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2750. --------------------------------- > Improve handling of messages that are too large > ----------------------------------------------- > > Key: TEIID-2750 > URL: https://issues.jboss.org/browse/TEIID-2750 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Driver > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > It is often unclear when a client message is too large. There is also no mechanism to allow for larger messages. -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2736) MongoDB: failed to translate to mongo query with boolean value expression

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2736?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2736. --------------------------------- > MongoDB: failed to translate to mongo query with boolean value expression > -------------------------------------------------------------------------- > > Key: TEIID-2736 > URL: https://issues.jboss.org/browse/TEIID-2736 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: Teiid 8.6 beta with mongoDB > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: Beta2, teiid > Fix For: 8.4.1, 8.6 > > > Fail to translate the following SQL to mongo query: > select "grade", > "name", > "score", > "state", > "grade" as "test", > ("name" = "state") as "name2" > from "mongoDBDS"."grades" > where "grade" = 'B' > However, it works with the query contains group by and boolean value expression: > elect "grade" as "test", > "grade", > ("name" = "state") as "name2", > sum("score") as "sum_score" > from "mongoDBDS"."grades" > where "grade" = 'B' > group by "grade", "grade", ("name" = "state") > order by "grade", "test", "name2" -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2673) CNF exception when getting data through infinispan-cache translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2673?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2673. --------------------------------- > CNF exception when getting data through infinispan-cache translator > ------------------------------------------------------------------- > > Key: TEIID-2673 > URL: https://issues.jboss.org/browse/TEIID-2673 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Labels: infinispan > Fix For: 8.4.1, 8.6 > > > When getting data through infinispan-cache translator using remote hot rod access, DV will throw "...ClassNotFoundException: org.infinispan.client.hotrod.impl.transport.tcp.TcpTransportFactory". > Workaround: > Add "<module name="org.infinispan.client.hotrod"/>" as a dependency into module "org.jboss.teiid". -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2704) DB2 lob values must be read inline

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2704?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2704. --------------------------------- > DB2 lob values must be read inline > ---------------------------------- > > Key: TEIID-2704 > URL: https://issues.jboss.org/browse/TEIID-2704 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.6, 7.7.9 > > > With the DB2 9 driver and selecting a lob column, the resulting instance becomes invalid after the next row of the result is transitioned to. -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2725) Group by doesn't work with MongoDB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2725?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2725. --------------------------------- > Group by doesn't work with MongoDB > ---------------------------------- > > Key: TEIID-2725 > URL: https://issues.jboss.org/browse/TEIID-2725 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Environment: Teiid with MongoDB > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.4.1, 8.6 > > > Group by SQL with/ without aggregate function returns incorrect values: > For example: > Original SQL: > select "grade", sum("score") as "sum_score" from "mongoDBDS"."grades" group by "grade" order by "grade" > > Transform query: > SELECT grades.grade AS c_0, SUM(grades.score) AS c_1 FROM grades GROUP BY grades.grade ORDER BY c_0 > $group:{ "_id" : "$grade" , "c_1" : { "$sum" : "$score"}} > $project:{ "c_0" : "$grade" , "c_1" : 1} > $sort:{ "c_0" : 1} > Expected Result: > grade score > A 187 > F 55 > Actual Result: (INCORRECT) > grade score > 242 > It only returns SUM(score) and group by fields are ignore. -- 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

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2690) Tuples lost in a with clause item.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2690?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2690. --------------------------------- > Tuples lost in a with clause item. > ---------------------------------- > > Key: TEIID-2690 > URL: https://issues.jboss.org/browse/TEIID-2690 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.1, 7.7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.4.1, 8.6, 7.7.8 > > > Related to TEIID-2442 - the BatchIterator created for the creation of the temp table backing a with clause item cannot be created after blocking without loosing tuples. > On 8.3.x+ a single block is not sufficient to induce this behavior if there are any tuples that have been retrieved since the last block as the access node logic will return the partial batch. Thus may occur as a somewhat rare timing issue in 8.3.x+. However in 7.7.7/7.7.8 a single block cause the recreation of the BatchIterator making the affect almost certain once the row count exceeds the computed working batch size (nominally 256 rows, but allowed to vary based upon the row width). -- 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

11 years, 1 month

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2013