March 2015 - teiid-issues - Jboss List Archives

[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)

9 years, 10 months

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)

9 years, 10 months

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)

9 years, 10 months

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)

9 years, 10 months

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)

9 years, 10 months

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)

9 years, 10 months

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)

9 years, 10 months

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)

9 years, 10 months

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)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3363) Download links for 8.10 are wrong

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3363?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3363. --------------------------------- > Download links for 8.10 are wrong > --------------------------------- > > Key: TEIID-3363 > URL: https://issues.jboss.org/browse/TEIID-3363 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: website > > http://teiid.jboss.org/downloads/ > For everything *except* Teiid runtime, download links are missing the "Final" qualifier. > {code} > http://sourceforge.net/projects/teiid/files/teiid-8.10.0-embedded-dist.zi... > {code} > should be > {code} > http://sourceforge.net/projects/teiid/files/teiid-8.10.0.Final-embedded-d... > {code} -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2015