[JBoss JIRA] (TEIID-1568) Partial Pushdown of WHERE clause columns
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1568?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1568.
-----------------------------------
Resolution: Out of Date
Marking as out of date. A new issue can be logged if one of the existing searchability types (like only, all except like, not searchable, equality only) is not enough.
> Partial Pushdown of WHERE clause columns
> ----------------------------------------
>
> Key: TEIID-1568
> URL: https://issues.jboss.org/browse/TEIID-1568
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Mark Addleman
> Assignee: Steven Hawkins
> Priority: Minor
>
> We have some exotic data sources that can efficiently support WHERE clause filtering on particular columns + operators combinations but are no better than Teiid for other operation. In particular, suppose I have a data source that supplies columns A and B. The data source can efficiently support A='some value' but may not support A>'value' or A!='value' and does not support efficient processing of column B at all. We would like an enhance supports* protocol to describe the particulars of a data source's capabilities with finer detail.
> Even partially solving this problem without operator support would be helpful
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[JBoss JIRA] (TEIID-4792) Unable to use WHERE clause against a JDG data source - ISPN000402: The type com.redhat.demo.sko.pojo.Call has no property named .....
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4792?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-4792:
----------------------------------
Assignee: Van Halbert (was: Steven Hawkins)
> Unable to use WHERE clause against a JDG data source - ISPN000402: The type com.redhat.demo.sko.pojo.Call has no property named .....
> -------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-4792
> URL: https://issues.jboss.org/browse/TEIID-4792
> Project: Teiid
> Issue Type: Bug
> Environment: Mac OS
> JDV 6.3.4
> JDG 6.6.1
> JBDS 10.3.0 with JBDSIS 10.0.2
> Reporter: Cojan van Ballegooijen
> Assignee: Van Halbert
> Attachments: Call_JDG_Module.zip, ChurnPrediction-vdb.xml, Contract_JDG_Module.zip, Screen Shot 2017-03-01 at 16.32.19.png, module pojo.xml, module.xml
>
>
> SELECT * FROM Calls."Call" works as expected and returns all rows
> Adding a where clause
> SELECT * FROM Calls."Call" WHERE Calls."Call".Intlcalls > 0
> generate the following error:
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: org.hibernate.hql.ParsingException: ISPN000402: The type com.redhat.demo.sko.pojo.Call has no property named 'Intlmins'.
> Elapsed Time: 0 hr, 0 min, 0 sec, 191 ms.
> If I join two VBL together and run the join query it returns the same error.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[JBoss JIRA] (TEIID-4218) MongoDB metadata import fails when user has insufficient permissions
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4218?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4218:
----------------------------------
Fix Version/s: 9.3
So at the very least we should be catching this exception, and ideally also offering include/exclude.
> MongoDB metadata import fails when user has insufficient permissions
> --------------------------------------------------------------------
>
> Key: TEIID-4218
> URL: https://issues.jboss.org/browse/TEIID-4218
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Fix For: 9.3
>
>
> The vdb deployment now fails with the following errror:
> 14:26:08,810 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB mongo.1 model "importVDBSrcModel" metadata failed to load. Reason:not authorized for query on bqt.system.users: com.mongodb.MongoEx
> ception: not authorized for query on bqt.system.users
> at com.mongodb.MongoException.parse(MongoException.java:82)
> at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:292)
> at com.mongodb.DBApiLayer$MyCollection.__find(DBApiLayer.java:273)
> at com.mongodb.DBCursor._check(DBCursor.java:368)
> at com.mongodb.DBCursor._hasNext(DBCursor.java:459)
> at com.mongodb.DBCursor.hasNext(DBCursor.java:484)
> at org.teiid.translator.mongodb.MongoDBMetadataProcessor.process(MongoDBMetadataProcessor.java:58)
> at org.teiid.translator.mongodb.MongoDBMetadataProcessor.process(MongoDBMetadataProcessor.java:39)
> at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:935) [teiid-api-8.7.1.6_2-redhat-5.jar:8.7.1.6_2-redhat-5]
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) [teiid-engine-8.7.1.6_2-redhat-5.jar:8.7.1.6_2-redhat-5]
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.7.1.6_2-redhat-5.jar:8.7.1.6_2-redhat-5]
> at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.7.1.6_2-redhat-5.jar:8.7.1.6_2-redhat-5]
> at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.1.6_2-redhat-5.jar:8.7.1.6_2-redhat-5]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]
> at org.jboss.threads.JBossThread.run(JBossThread.java:122)
> The user does not have access to the system tables, but there is no way to exclude those tables from the import (like with the JDBC importer).
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[JBoss JIRA] (TEIID-4474) Re-license under a more permissive license
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4474?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4474:
----------------------------------
Fix Version/s: 10.0
> Re-license under a more permissive license
> ------------------------------------------
>
> Key: TEIID-4474
> URL: https://issues.jboss.org/browse/TEIID-4474
> Project: Teiid
> Issue Type: Task
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 10.0
>
>
> There has been some interest in Teiid re-licensing with a more permissive license, such as the ASL or MIT license. Beyond the obvious work of altering headers and license files, we need permission from the original copyright/copyleft holders to approve the change.
> We'd likely want to use the ASL, but if there are any concerns about GPL compatibility we'll consider the MIT license.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months