[JBoss JIRA] (TEIID-4632) Clarify in doc's when a MAKEDEP temp table push down will be performed
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4632?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4632:
----------------------------------
Fix Version/s: 9.2
> Clarify in doc's when a MAKEDEP temp table push down will be performed
> ----------------------------------------------------------------------
>
> Key: TEIID-4632
> URL: https://issues.jboss.org/browse/TEIID-4632
> Project: Teiid
> Issue Type: Enhancement
> Components: Documentation
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 9.2
>
>
> Clarify in the documentation when the MAKEDEP temp table push down will be performed. It was tested and confirmed that by changing MaxInCriteriaSize to 1 and MaxDependentPredicates to 1 could force the temp table pushdown. So it would appear that when the number of independent values exceeds MaxInCriteriaSize*MaxDependentPredicates this would be performed (when Enabled Dependent Joins is true).
> So, on page 832 (pdf of 9.1)
> " .. then multiple dependent queries will be issued in parallel".
> May want to rephrase to say if "Enabled Dependent Joins" is true, that pushed down to temp table will occur, other wise, multiple dependent queries will be issued in parallel.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4645) Mongo translator - fail to initialize translator wiith property SupportsAggregatesCount
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4645?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4645:
----------------------------------
Fix Version/s: 9.2
> Mongo translator - fail to initialize translator wiith property SupportsAggregatesCount
> ---------------------------------------------------------------------------------------
>
> Key: TEIID-4645
> URL: https://issues.jboss.org/browse/TEIID-4645
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.8.6_3
> Reporter: Juraj Duráni
> Assignee: Ramesh Reddy
> Fix For: 9.2
>
>
> If translator has *SupportsAggregatesCount* property set, initialization fails.
> {code:plain|title=Exception}
> 08:15:26,455 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-4) MSC000001: Failed to start service jboss.teiid.vdb.mongo_enhancements.1: org.jboss.msc.service.StartException in service jboss.teiid.vdb.mongo_enhancements.1: TEIID50035 TEIID40028 No setSetSupportsAggregatesCount method found for translator property setSupportsAggregatesCount
> at org.teiid.jboss.VDBService.createConnectorManagers(VDBService.java:299)
> at org.teiid.jboss.VDBService.start(VDBService.java:129)
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) [jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
> at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) [jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal]
> Caused by: org.teiid.core.TeiidException: TEIID40028 No setSetSupportsAggregatesCount method found for translator property setSupportsAggregatesCount
> at org.teiid.deployers.TranslatorUtil.getSetter(TranslatorUtil.java:207)
> at org.teiid.deployers.TranslatorUtil.injectProperties(TranslatorUtil.java:167)
> at org.teiid.deployers.TranslatorUtil.buildExecutionFactory(TranslatorUtil.java:123)
> at org.teiid.jboss.VDBService.getExecutionFactory(VDBService.java:320)
> at org.teiid.jboss.VDBService$5.getExecutionFactory(VDBService.java:292)
> at org.teiid.dqp.internal.datamgr.ConnectorManagerRepository.createConnectorManager(ConnectorManagerRepository.java:134)
> at org.teiid.dqp.internal.datamgr.ConnectorManagerRepository.createConnectorManagers(ConnectorManagerRepository.java:108)
> at org.teiid.jboss.VDBService.createConnectorManagers(VDBService.java:296)
> ... 6 more
> {code}
> {code:xml|title=Translator override}
> <translator name="mongodb-no-count-over" type="mongodb">
> <property name="SupportsAggregatesCount" value="false"/>
> </translator>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4644) anonymous block dynamic issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4644?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4644:
----------------------------------
Fix Version/s: 9.2
> anonymous block dynamic issues
> ------------------------------
>
> Key: TEIID-4644
> URL: https://issues.jboss.org/browse/TEIID-4644
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> Using execute immediate 'begin ... end'
> Has several issues. First any variable references such as rowcount will be rewritten in the outer scope and not evaluated as part of the procedure. Also the anonymous block cannot be used with targeting an into as the statement we create is insert into select ... from (begin ... end) .. - which is not valid, however the exception message does not make this clear.
> So we either need to improve these issues or disallow using anonymous blocks as dynamic sql.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4657) Explain how the pojo module.xml should be configured
by Van Halbert (JIRA)
Van Halbert created TEIID-4657:
----------------------------------
Summary: Explain how the pojo module.xml should be configured
Key: TEIID-4657
URL: https://issues.jboss.org/browse/TEIID-4657
Project: Teiid
Issue Type: Task
Components: JDG Connector
Affects Versions: 9.2
Reporter: Van Halbert
Assignee: Steven Hawkins
The JDG resource adapter documentation must explain how the pojo module.xml should be configured.
{code}
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.client.quickstart.remotecache.pojos">
<resources>
<resource-root path="jdg-remote-cache-materialization-pojos.jar" />
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="org.infinispan.client.hotrod" slot="${jdg.slot}" optional="true" services="export"/>
<module name="org.infinispan.protostream" slot="${jdg.slot}" optional="true" services="export"/>
<module name="org.jboss.teiid.resource-adapter.infinispan.hotrod" export="true" />
</dependencies>
</module>
{code}
Also, explain that Teiid Designer feature for reverse engineering that will create the pojo and module.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4657) Explain how the pojo module.xml should be configured
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4657?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-4657:
----------------------------------
Assignee: Van Halbert (was: Steven Hawkins)
> Explain how the pojo module.xml should be configured
> ----------------------------------------------------
>
> Key: TEIID-4657
> URL: https://issues.jboss.org/browse/TEIID-4657
> Project: Teiid
> Issue Type: Task
> Components: JDG Connector
> Affects Versions: 9.2
> Reporter: Van Halbert
> Assignee: Van Halbert
>
> The JDG resource adapter documentation must explain how the pojo module.xml should be configured.
> {code}
> <?xml version="1.0" encoding="UTF-8"?>
> <module xmlns="urn:jboss:module:1.0" name="com.client.quickstart.remotecache.pojos">
> <resources>
> <resource-root path="jdg-remote-cache-materialization-pojos.jar" />
> <!-- Insert resources here -->
> </resources>
> <dependencies>
> <module name="org.infinispan.client.hotrod" slot="${jdg.slot}" optional="true" services="export"/>
> <module name="org.infinispan.protostream" slot="${jdg.slot}" optional="true" services="export"/>
> <module name="org.jboss.teiid.resource-adapter.infinispan.hotrod" export="true" />
> </dependencies>
> </module>
> {code}
> Also, explain that Teiid Designer feature for reverse engineering that will create the pojo and module.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4627) High-level event handling
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4627?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4627:
---------------------------------------
For the initial commit I've wired it in only through the EventDistributor. We can expand from there if need be to handle internal events as well.
> High-level event handling
> -------------------------
>
> Key: TEIID-4627
> URL: https://issues.jboss.org/browse/TEIID-4627
> Project: Teiid
> Issue Type: Enhancement
> Components: Grammar, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> We should look into high-level plugability of event handling at a row level. This could even be handled at the language level with new trigger semantics for source tables: create trigger on tbl on cdc (insert|update...) - which could potentially even specify the topic mapping other details. There is complexity for multi-source models here though.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4622) Adding new data quality functions from osDQ
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4622?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4622:
-------------------------------------
Separate prefix sounds good.
> Adding new data quality functions from osDQ
> -------------------------------------------
>
> Key: TEIID-4622
> URL: https://issues.jboss.org/browse/TEIID-4622
> Project: Teiid
> Issue Type: Feature Request
> Components: Common
> Affects Versions: Open To Community
> Environment: osdq-core and its dependency simmetric 3.0.0 is needed to run these functions
> maven central location
> http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22osdq-core%22
> Reporter: vivek singh
> Assignee: Kylin Soong
> Fix For: Open To Community
>
> Attachments: DateUtil.java, NumberUtil.java, StringUtil.java
>
>
> Following functions have been added into osdq-core for integration with teiid.
> String functions :
> // Encrypting a string using key and AES encryption
> String encrypt ( String val, String key)
> String decrypt ( String val, String key)
> // Fuzzy distance - similarity between two strings
> float levestheindistance ( String a, String b)
> float jarowinklerdistance( String a , String b)
> float cosinedistance (String a, String b)
> // Format check for PII ( personal information)
> boolean isCreditCardFormat(String a)
> boolean isSSNFormat(String a)
> boolean isPhoneFormat(String a)
> boolean isEmailFormat(String a)
> boolean hasWhiteSpace(String a )
> Date Functions
> // converting date into universal recognized format
> long dateToEpoch(java.util.Date date)
> Date epochToDate(long epoch)
> Date epochToDate(long epoch, String TimeZone)
> long diffInSec(date a, date b)
> String convertToFormat ( Date a, String Format)
> Numerical Functions
> // Statistical functions
> double stdDev(Number[] numSeries)
> double range(Number[] numSeries)
> double median(Number[] numSeries)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4627) High-level event handling
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4627?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4627:
-------------------------------------
[~shawkins] How would I invoke these triggers when I receive an external event? should I be issuing a INSERT/UPDATE/DELETE on the source table or you can point me to some other low level hook I can use?
> High-level event handling
> -------------------------
>
> Key: TEIID-4627
> URL: https://issues.jboss.org/browse/TEIID-4627
> Project: Teiid
> Issue Type: Enhancement
> Components: Grammar, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> We should look into high-level plugability of event handling at a row level. This could even be handled at the language level with new trigger semantics for source tables: create trigger on tbl on cdc (insert|update...) - which could potentially even specify the topic mapping other details. There is complexity for multi-source models here though.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4622) Adding new data quality functions from osDQ
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4622?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4622:
---------------------------------------
[~rareddy] [~kylin] I want to make sure we're on the same page about the schema/prefix for these functions. Since it seems like the dependency will be optional, and it's not likely that any will be eligible for pushdown, it seems like a good idea to separate these functions from the rest of the system/SYS functions. We don't need to go to the extent of adding a new schema as we can just use a prefix (osdq.function) and it will still resolve as expected without the prefix. Any thoughts?
> Adding new data quality functions from osDQ
> -------------------------------------------
>
> Key: TEIID-4622
> URL: https://issues.jboss.org/browse/TEIID-4622
> Project: Teiid
> Issue Type: Feature Request
> Components: Common
> Affects Versions: Open To Community
> Environment: osdq-core and its dependency simmetric 3.0.0 is needed to run these functions
> maven central location
> http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22osdq-core%22
> Reporter: vivek singh
> Assignee: Kylin Soong
> Fix For: Open To Community
>
> Attachments: DateUtil.java, NumberUtil.java, StringUtil.java
>
>
> Following functions have been added into osdq-core for integration with teiid.
> String functions :
> // Encrypting a string using key and AES encryption
> String encrypt ( String val, String key)
> String decrypt ( String val, String key)
> // Fuzzy distance - similarity between two strings
> float levestheindistance ( String a, String b)
> float jarowinklerdistance( String a , String b)
> float cosinedistance (String a, String b)
> // Format check for PII ( personal information)
> boolean isCreditCardFormat(String a)
> boolean isSSNFormat(String a)
> boolean isPhoneFormat(String a)
> boolean isEmailFormat(String a)
> boolean hasWhiteSpace(String a )
> Date Functions
> // converting date into universal recognized format
> long dateToEpoch(java.util.Date date)
> Date epochToDate(long epoch)
> Date epochToDate(long epoch, String TimeZone)
> long diffInSec(date a, date b)
> String convertToFormat ( Date a, String Format)
> Numerical Functions
> // Statistical functions
> double stdDev(Number[] numSeries)
> double range(Number[] numSeries)
> double median(Number[] numSeries)
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months
[JBoss JIRA] (TEIID-4627) High-level event handling
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4627?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4627:
---------------------------------------
Nearly there for the first iteration. As a simplification the events will only be processed via the evendistributor, rather than initiated by Teiid changes.
> High-level event handling
> -------------------------
>
> Key: TEIID-4627
> URL: https://issues.jboss.org/browse/TEIID-4627
> Project: Teiid
> Issue Type: Enhancement
> Components: Grammar, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> We should look into high-level plugability of event handling at a row level. This could even be handled at the language level with new trigger semantics for source tables: create trigger on tbl on cdc (insert|update...) - which could potentially even specify the topic mapping other details. There is complexity for multi-source models here though.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 5 months