June 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3093) SOLR: Translator ignores "Name In Source" attribute of table columns

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3093?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3093. --------------------------------- > SOLR: Translator ignores "Name In Source" attribute of table columns > -------------------------------------------------------------------- > > Key: TEIID-3093 > URL: https://issues.jboss.org/browse/TEIID-3093 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Alpha2 > Fix For: 8.7.1, 8.9 > > > When I create a source model in teiid designer and I specify "Name In Source" attribute in one of the table columns, SOLR translator will ignore the "Name In Source" attribute and it will use a column name to create SOLR query. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3070) Netty worker threads cause system high cpu

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3070?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3070. --------------------------------- > Netty worker threads cause system high cpu > ------------------------------------------ > > Key: TEIID-3070 > URL: https://issues.jboss.org/browse/TEIID-3070 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7, 8.9 > Environment: JDV 6.1.0.DR2 > JDV 6.0 > Reporter: Kylin Soong > Assignee: Kylin Soong > > I have hit this issue many times in deploying a VDB to JDV, All CPU be used by netty worker threads: > ~~~ > "New I/O worker #3" daemon prio=10 tid=0x00007fc71c0d2000 nid=0x320b runnable [0x00007fc7074f3000] > java.lang.Thread.State: RUNNABLE > at sun.nio.ch.EPollArrayWrapper.epollWait(Native Method) > at sun.nio.ch.EPollArrayWrapper.poll(EPollArrayWrapper.java:269) > at sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:79) > at sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:87) > - locked <0x00000000c42b4318> (a sun.nio.ch.Util$2) > - locked <0x00000000c42b4328> (a java.util.Collections$UnmodifiableSet) > - locked <0x00000000c42b42d0> (a sun.nio.ch.EPollSelectorImpl) > at sun.nio.ch.SelectorImpl.select(SelectorImpl.java:98) > at org.jboss.netty.channel.socket.nio.SelectorUtil.select(SelectorUtil.java:64) > ~~~ > Seems this is a exist netty issue, search "jboss netty high cpu" via google we can get lots of result. > Below link have detailed depiction about this issue; > https://github.com/kylinsoong/teiid-samples/tree/master/highcpu -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2887) MongoDB: mongodb DBCollection aggregate error

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2887?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2887. --------------------------------- > MongoDB: mongodb DBCollection aggregate error > ---------------------------------------------- > > Key: TEIID-2887 > URL: https://issues.jboss.org/browse/TEIID-2887 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: Teiid 8.7 Beta1 with MongoDB > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: Beta3, teiid > Fix For: 8.7 > > > Here is my simple JSON object: > "addresst" { "_id": 0, > "name": "Duke Grant", > "age": 38, > "gender": "male", > > "address": { "_id": 0, > "street": "345 Burnett Street", > "city": "Nash", > "state": "Rhode Island", > "zip": 7384 } > } > And I define a schema like following: > REATE FOREIGN TABLE addresst (custid integer PRIMARY KEY, name varchar(25), age integer, gender varchar(25)) OPTIONS(UPDATABLE 'TRUE'); > CREATE FOREIGN TABLE address (custid integer PRIMARY KEY, street varchar(50), city varchar(25), state varchar(25), zipcode varchar(6), FOREIGN KEY (custId) REFERENCES addresst (custid)) OPTIONS(UPDATABLE 'TRUE' , "teiid_mongo:MERGE" 'addresst'); > Got exception when trying to execute a query like following: > select "MongoDB_addresst"."gender" as "MongoDB_addresst_gender", > "MongoDB_address"."state" as "MongoDB_address_state" > from "MongoDB"."addresst" "MongoDB_addresst" > inner join "MongoDB"."address" "MongoDB_address" on ("MongoDB_addresst"."custid" = "MongoDB_address"."custid") > group by "MongoDB_addresst"."gender", "MongoDB_address"."state" > order by "MongoDB_addresst_gender", "MongoDB_address_state" > limit 1000 > Exception: > Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "qa-mongodb.jaspersoft.com/172.17.1.48:27017" , "errmsg" : "exception: dotted field names are only allowed at the top level" , "code" : > 16405 , "ok" : 0.0} > at com.mongodb.CommandResult.getException(CommandResult.java:71) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:110) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1308) > at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:99) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:317) > 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$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:273) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) > ... 3 more -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3185) Support JBoss EAP 6.3 Alpha1 as host environment

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3185?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3185. --------------------------------- > Support JBoss EAP 6.3 Alpha1 as host environment > ------------------------------------------------ > > Key: TEIID-3185 > URL: https://issues.jboss.org/browse/TEIID-3185 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits, Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Blocker > Labels: CR2 > Fix For: 8.9 > > > Now that EAP 6.3.Alpha1 is supported with out any $0 developer license, this would be eligible for accepting as the host environment for Teiid. > We know this late in the cycle, but the benefit is users no longer have to manually put in the RestEasy fix. Also there are many bug fixes. > If there are any concerns, let's hear it. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3353) In SQL Server INSERT ... VALUES clause UUID is not substituted

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3353?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3353. --------------------------------- > In SQL Server INSERT ... VALUES clause UUID is not substituted > -------------------------------------------------------------- > > Key: TEIID-3353 > URL: https://issues.jboss.org/browse/TEIID-3353 > Project: Teiid > Issue Type: Bug > Reporter: Nicholas D > Assignee: Steven Hawkins > Fix For: 8.10 > > > Teiid 8.4, SQL Server 2012 Express > I'm inserting into table with uniqueidentifier field > {code:sql} > INSERT INTO SOME_TABLE(some_uuid, some_ts) > VALUES (uuid(), now()) > {code} > and get something like > bq. 195 Remote org.teiid.translator.jdbc.JDBCExecutionException: 195 TEIID11013:TEIID11004 Error executing statement(s): [Prepared Values: [{ts '2015-02-24 21:02:23.803'}] SQL: INSERT INTO "DS"."dbo"."SOME_TABLE" ("SOME_UUID", "SOME_TS") VALUES (uuid(), ?)] > However if i use INSERT ... SELECT clause it's substituted normally: > {code:sql} > INSERT INTO SOME_TABLE(some_uuid, some_ts) > SELECT uuid(), now() > FROM SOME_OTHER_TABLE > LIMIT 1 > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3248) Null handling in XMLQUERY and XMLTABLE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3248?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3248. --------------------------------- > Null handling in XMLQUERY and XMLTABLE > -------------------------------------- > > Key: TEIID-3248 > URL: https://issues.jboss.org/browse/TEIID-3248 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > Null handling in XMLQUERY and XMLTABLE is not correct - both are currently exceptions. A null context item in XMLQUERY should result in an UNKNOWN result while XMLTABLE should have no result rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2910) HIVE: method not found exception

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2910?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2910. --------------------------------- > HIVE: method not found exception > --------------------------------- > > Key: TEIID-2910 > URL: https://issues.jboss.org/browse/TEIID-2910 > Project: Teiid > Issue Type: Bug > Components: Connector API > Affects Versions: 8.7 > Environment: HIVE 0.11 driver with Teiid 8.7 CR1 > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.7 > > > I just upgraded from Teiid 8.7 BETA1 to Teiid 8.7 BETA1. And I got the following exception when trying to connect to HIVE1/ HIVE2 with HIVE 0.11 driver. > Caused by: java.sql.SQLException: Method not supported > at org.apache.hadoop.hive.jdbc.HiveDatabaseMetaData.getIdentifierQuoteString(HiveDatabaseMetaData.java:391) > at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:105) > at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:309) > And it used to work with Teiid 8.7 BETA1 -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2881) Add support to use DSL when querying remote JDG 6.2

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2881?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2881. --------------------------------- > Add support to use DSL when querying remote JDG 6.2 > --------------------------------------------------- > > Key: TEIID-2881 > URL: https://issues.jboss.org/browse/TEIID-2881 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7, 8.9 > > > Add support for querying remote JDG 6.2 using DSL. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2923) Cassandra: need authorization support in CassandraManagedConnectionFactory

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2923?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2923. --------------------------------- > Cassandra: need authorization support in CassandraManagedConnectionFactory > --------------------------------------------------------------------------- > > Key: TEIID-2923 > URL: https://issues.jboss.org/browse/TEIID-2923 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.6 > Environment: Cassandra with Teiid > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.7 > > > need authorization support in CassandraManagedConnectionFactory. please provide a way to enter username and password. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3307) PostgreSQL: Implement Teiid spatial

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3307?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3307. --------------------------------- > PostgreSQL: Implement Teiid spatial > ----------------------------------- > > Key: TEIID-3307 > URL: https://issues.jboss.org/browse/TEIID-3307 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > Fix For: 8.10 > > > Add support for GEOMETRY and the ST_* functions to the PostgreSQL translator. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 10 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2015