March 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2895) Missing message for multi-source validation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2895?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2895. ----------------------------------- Resolution: Done Added the missing validation message. > Missing message for multi-source validation > ------------------------------------------- > > Key: TEIID-2895 > URL: https://issues.jboss.org/browse/TEIID-2895 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.7 > > > User is seeing: > {code} > <Missing message for key "multi_source_update_not_allowed" in: org.teiid.query.i18n> > {code} > rather than the actual message. -- 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

10 years, 9 months

1
0
0 / 0

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

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2887?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-2887: -------------------------------- Fix Version/s: 8.7 > 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: 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 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2249) Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-2249. -------------------------------- Assignee: Steven Hawkins (was: Van Halbert) Resolution: Done Sorry, editing the wrong jira. > Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS > ---------------------------------------------------------------------------------------------------------- > > Key: TEIID-2249 > URL: https://issues.jboss.org/browse/TEIID-2249 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.5 > > > Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead. > One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server. -- 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2249) Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-2249: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS > ---------------------------------------------------------------------------------------------------------- > > Key: TEIID-2249 > URL: https://issues.jboss.org/browse/TEIID-2249 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Debbie Steigner > Assignee: Van Halbert > Fix For: 8.5 > > > Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead. > One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server. -- 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2249) Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2249?page=com.atlassian.jira.plugin... ] Van Halbert reopened TEIID-2249: -------------------------------- > Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS > ---------------------------------------------------------------------------------------------------------- > > Key: TEIID-2249 > URL: https://issues.jboss.org/browse/TEIID-2249 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Debbie Steigner > Assignee: Van Halbert > Fix For: 8.5 > > > Our proposal is to allow for the more efficient use of large ad-hoc result-sets by rather than creating a long 'IN' list, inserting them in to a temporary table - for example a # table in Sybase and SQL Server - and then generating an SQL join to that instead. > One of the difference to materialized views (or at least my understanding), is that this work happens at a data-source rather than within the Teiid server. -- 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2895) Missing message for multi-source validation

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2895: ------------------------------------- Summary: Missing message for multi-source validation Key: TEIID-2895 URL: https://issues.jboss.org/browse/TEIID-2895 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.7 User is seeing: {code} <Missing message for key "multi_source_update_not_allowed" in: org.teiid.query.i18n> {code} rather than the actual message. -- 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2894) Add support for the row lock query(SELECT FOR UPDATE) to the source database

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2894?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2894: --------------------------------------- This is quite problematic for us to support. The additional syntax is fairly straight-forward, but we would need additional translator support and would need to support updatable resultsets - which generally conflicts with our detached processing model. > Add support for the row lock query(SELECT FOR UPDATE) to the source database > ---------------------------------------------------------------------------- > > Key: TEIID-2894 > URL: https://issues.jboss.org/browse/TEIID-2894 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Van Halbert > Assignee: Steven Hawkins > > We need support for the row lock query(SELECT FOR UPDATE) in teiid query engine. -- 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2894) Add support for the row lock query(SELECT FOR UPDATE) to the source database

by Van Halbert (JIRA)

Van Halbert created TEIID-2894: ---------------------------------- Summary: Add support for the row lock query(SELECT FOR UPDATE) to the source database Key: TEIID-2894 URL: https://issues.jboss.org/browse/TEIID-2894 Project: Teiid Issue Type: Feature Request Components: Server Reporter: Van Halbert Assignee: Steven Hawkins We need support for the row lock query(SELECT FOR UPDATE) in teiid query engine. -- 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2826) Change build to use zip translator packaging when building jboss kit

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2826?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2826: ------------------------------------- Fixed the build and updated per your suggestions! > Change build to use zip translator packaging when building jboss kit > -------------------------------------------------------------------- > > Key: TEIID-2826 > URL: https://issues.jboss.org/browse/TEIID-2826 > Project: Teiid > Issue Type: Sub-task > Components: Build/Kits > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Labels: Beta2 > Fix For: 8.7 > > > Change build to use zip translator packaging when building jboss kit -- 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

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2826) Change build to use zip translator packaging when building jboss kit

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2826?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2826: ------------------------------------- > Why is the embedded assembly called module-dist.xml? module is generic term >Why are the kits/assemblies combined? each kit directory represent different assembly > It seems like we'd want them separated to avoid putting in exclusions sure we can do that, just liked keep in same dir >Could the creation of the rar modules be done in just in a generic task, rather than requiring an assembly for each? in jboss-as and embedded, the definition of RAR is modified, these tasks represent that. I was trying to accomplish the task through pom.xml, but it was not straight forward so I choose this path. Let me see what is issue, I can define exclusions * with specific to avoid possibly. before you revert > Change build to use zip translator packaging when building jboss kit > -------------------------------------------------------------------- > > Key: TEIID-2826 > URL: https://issues.jboss.org/browse/TEIID-2826 > Project: Teiid > Issue Type: Sub-task > Components: Build/Kits > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Labels: Beta2 > Fix For: 8.7 > > > Change build to use zip translator packaging when building jboss kit -- 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

10 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2014