March 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3341) Metadata load failure between retries of multi-source models

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3341?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3341. --------------------------------- > Metadata load failure between retries of multi-source models > ------------------------------------------------------------ > > Key: TEIID-3341 > URL: https://issues.jboss.org/browse/TEIID-3341 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 7.7 > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 8.10 > > > The code will attempt to load from each source until one is successful. There is an issue however that the metadatafactory is not being reset, so the next load attempt will be against existing metadata. At the debug level this will be seen as "Failed to get metadata, trying next source." > From the forum post - If the metadata factories are chained like "NATIVE, DDL", with invalid DDL, a duplicate table issue is seen instead. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2816) HBase Connector/Translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2816?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2816. --------------------------------- > HBase Connector/Translator > -------------------------- > > Key: TEIID-2816 > URL: https://issues.jboss.org/browse/TEIID-2816 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, JDBC Connector, JDBC Driver > Affects Versions: Open To Community > Reporter: devin pinkston > Assignee: Kylin Soong > Labels: HBase, Translator > Fix For: 8.10 > > > Develop a HBase translator/connector. Potentially using the Phoenix JDBC driver, supports most SQL and handles connections: > https://github.com/forcedotcom/phoenix -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3134) Impala sorting Issue

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3134?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3134. --------------------------------- > Impala sorting Issue > -------------------- > > Key: TEIID-3134 > URL: https://issues.jboss.org/browse/TEIID-3134 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > Attachments: server.log > > > String sorting of impala is inconsistent with our expectations: > Impala sorting > --------------------------- > SELECT BQT1.SmallA.StringNum FROM BQT1.SmallA > Results > 1: -1 > 2: -10 > 3: -11 > 4: -12 > 5: -13 > 6: -14 > 7: -15 > 8: -16 > 9: -17 > 10: -18 > 11: -19 > 12: -2 > 13: -20 > 14: -21 > 15: -22 > 16: -24 > 17: -3 > 18: -4 > 19: -5 > 20: -6 > 21: -8 > 22: -9 > 23: 0 > 24: 1 > 25: 10 > 26: 11 > 27: 12 > 28: 13 > 29: 14 > 30: 15 > 31: 16 > 32: 17 > 33: 18 > 34: 19 > 35: 2 > 36: 20 > 37: 21 > 38: 22 > 39: 23 > 40: 24 > 41: 3 > 42: 4 > 43: 5 > 44: 6 > 45: 7 > 46: 8 > 47: null > 48: null > 49: null > 50: null > Expected > --------------------------- > While we expect sorting to be consistent with other sources: > 1: 0 > 2: 1 > 3: -1 > 4: 10 > 5: -10 > 6: 11 > 7: -11 > 8: 12 > 9: -12 > 10: 13 > 11: -13 > 12: 14 > 13: -14 > 14: 15 > 15: -15 > 16: 16 > 17: -16 > 18: 17 > 19: -17 > 20: 18 > 21: -18 > 22: 19 > 23: -19 > 24: 2 > 25: -2 > 26: 20 > 27: -20 > 28: 21 > 29: -21 > 30: 22 > 31: -22 > 32: 23 > 33: 24 > 34: -24 > 35: 3 > 36: -3 > 37: 4 > 38: -4 > 39: 5 > 40: -5 > 41: 6 > 42: -6 > 43: 7 > 44: 8 > 45: -8 > 46: -9 > 47: null > 48: null > 49: null > 50: null -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3348) MongoDB: Teiid 8.10 CR are not compatible with MongoDB 2.4.8

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3348?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3348. --------------------------------- > MongoDB: Teiid 8.10 CR are not compatible with MongoDB 2.4.8 > ------------------------------------------------------------- > > Key: TEIID-3348 > URL: https://issues.jboss.org/browse/TEIID-3348 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.10 > Environment: Teiid 8.10 with MongoDB 2.4.8 > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.10 > > > I am not able to run any query with with Teiid 8.10 CR1 against MongoDB version 2.4.8. But it works for MongoDB version 2.6.6 > Caused by: java.lang.NullPointerException > at org.teiid.translator.mongodb.MongoDBQueryExecution.close(MongoDBQueryExecution.java:144) > at org.teiid.translator.mongodb.MongoDBQueryExecution.cancel(MongoDBQueryExecution.java:150) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.cancel(ConnectorWorkItem.java:191) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:209) > at $Proxy183.cancel(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.fullyCloseSource(DataTierTupleSource.java:323) > at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:378) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154) > at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3330) Add relational node id to plans to match debug log

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3330?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3330. --------------------------------- > Add relational node id to plans to match debug log > -------------------------------------------------- > > Key: TEIID-3330 > URL: https://issues.jboss.org/browse/TEIID-3330 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > The processing plans would match up better with the debug log if the node id for relational plans were also included in the plan. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3288) Upgrade JDG DSL querying using hotrod client over protobuffers to JDG 6.4

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3288?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3288. --------------------------------- > Upgrade JDG DSL querying using hotrod client over protobuffers to JDG 6.4 > ------------------------------------------------------------------------- > > Key: TEIID-3288 > URL: https://issues.jboss.org/browse/TEIID-3288 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors, Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1, 8.10 > > > Upgrade the JDG DSL remote hotrod client over protobuffers from the JDG 6.3 tech preview to JDG 6.4. > This upgrade will allow user to specify what's query able using annotations and will eliminate the dependency protobuf jar. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3326) Add back a drools quick start

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3326?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3326. --------------------------------- > Add back a drools quick start > ----------------------------- > > Key: TEIID-3326 > URL: https://issues.jboss.org/browse/TEIID-3326 > Project: Teiid > Issue Type: Quality Risk > Components: Quick Starts > Reporter: Steven Hawkins > Fix For: 8.10 > > > Add back a Drools quick start: https://docs.jboss.org/author/display/teiidexamples/Drools+Component+Inte... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3337) Netty exception related to close logged at warn level

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3337?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3337. --------------------------------- > Netty exception related to close logged at warn level > ----------------------------------------------------- > > Key: TEIID-3337 > URL: https://issues.jboss.org/browse/TEIID-3337 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > An exception with the message "An existing connection was forcibly closed by the remote host" is still being logged at a warning level -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3319) Union with different datatypes gives error in mysql

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3319?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3319. --------------------------------- > Union with different datatypes gives error in mysql > --------------------------------------------------- > > Key: TEIID-3319 > URL: https://issues.jboss.org/browse/TEIID-3319 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Mark Tawk > Assignee: Steven Hawkins > Fix For: 8.10 > > > Hello, > I'm using Teiid 8.9.0 Alpha2 with mysql5.7 and mysql5 translator. > I have a union query with fields of different types, int and varchar. > Teiid is adding dynamically the cast as char to the int field but the jdbc query is giving an error on mysql level (Illegal mix of collations for operation 'UNION') > I edited the generated jdbc query and added cast as char to both fields int and varchar, mysql executes the jdbc query without a problem. > I added convert to String to both union fields in Teiid sql query, but the jdbc query generated by teiid is not adding the cast to the string field. > Teiid sql query: > select "ITRITPTicketsView"."ITRITPTicketsView_jiraissue_" as "ITRITPTicketsView_jiraissue_" > from ((select convert("ITRITPTicketsView_sub"."jiraissue_ID", string) as "ITRITPTicketsView_jiraissue_" from "implifyBusinessModel"."ITRITPTicketsView" "ITRITPTicketsView_sub") > union > (select convert("SDView_sub"."incidentsm1_INCIDENT_ID", string) as "SDView_incidentsm1_INCIDENT_" from "implifyBusinessModel"."SDView" "SDView_sub") > ) "ITRITPTicketsView" > LIMIT 0 , 10 > The generated error: > org.teiid.translator.jdbc.JDBCExecutionException: 1271 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: (SELECT cast(g_1.`jiraissue_ID` AS char) AS c_0 FROM `implify_view`.`ITRITPTicketsView` AS g_1) UNION (SELECT g_0.`incidentsm1_INCIDENT_ID` AS c_0 FROM `implify_view`.`SDView` AS g_0) LIMIT 10] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:151) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.sql.SQLException: Illegal mix of collations for operation 'UNION' > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838) > at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) > at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2212) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:141) > ... 12 more > Feb 03, 2015 8:43:32 AM org.teiid.logging.JavaLogger log > WARNING: TEIID30020 Processing exception for request AxQ9XTXrAYkm.0 'TEIID30504 implify_viewModelVDB: 1271 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: (SELECT cast(g_1.`jiraissue_ID` AS char) AS c_0 FROM `implify_view`.`ITRITPTicketsView` AS g_1) UNION (SELECT g_0.`incidentsm1_INCIDENT_ID` AS c_0 FROM `implify_view`.`SDView` AS g_0) LIMIT 10]'. Originally TeiidProcessingException 'Illegal mix of collations for operation 'UNION'' SQLError.java:1084. Enable more detailed logging to see the entire stacktrace. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3352) Can't cast from decimal to boolean in postgresql

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3352?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3352. --------------------------------- > Can't cast from decimal to boolean in postgresql > ------------------------------------------------ > > Key: TEIID-3352 > URL: https://issues.jboss.org/browse/TEIID-3352 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > We can't cast directly to boolean in postgresql from decimal. The Teiid conversion assume anything that isn't 0 is true (matches h2 and other handling). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2015