May 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3492) Provide a mechanism for users to modify the salesforce api version

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3492: ------------------------------------- Summary: Provide a mechanism for users to modify the salesforce api version Key: TEIID-3492 URL: https://issues.jboss.org/browse/TEIID-3492 Project: Teiid Issue Type: Feature Request Components: Salesforce Connector Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.12 We should provide a mechanism to easily target a different salesforce api version. We are currently defaulting to v22, which is quite old. The version change must be controlled as the metadata and the sf jars can be incompatible - if you for example build a model from v22, then you must stay on v22, and then recreate the model once you want to move to a later version. Currently the update procedure would be to copy/modify the salesforce translator module and have it point to newer wsc and partner api jars (which are java api compatible from what I have seen) and then change the any salesforce resource adapters to use the new api url. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3151) Add Support for SAP HANA Sources

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-3151?page=com.atlassian.jira.plugin... ] Ted Jones commented on TEIID-3151: ---------------------------------- Yes.. I still have some more work/testing to do there. I will correct ASAP. Thanks > Add Support for SAP HANA Sources > -------------------------------- > > Key: TEIID-3151 > URL: https://issues.jboss.org/browse/TEIID-3151 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.11 > > > Need to add support SAP HANA. SAP provides a JDBC and ODBC driver for it. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3151) Add Support for SAP HANA Sources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3151?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3151: --------------------------------------- Also TestHanaConvertModifier has been marked as ignored as nearly all tests there are failing. Did you not mean for this to be pulled yet? I also couldn't find a reference covering the various conversion functions - for example to_biginteger(val, 'biginteger') > Add Support for SAP HANA Sources > -------------------------------- > > Key: TEIID-3151 > URL: https://issues.jboss.org/browse/TEIID-3151 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.11 > > > Need to add support SAP HANA. SAP provides a JDBC and ODBC driver for it. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3481) Wrong syntax of cache hints in the documentation

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3481?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3481: ------------------------------------------------ David Le Sage <dlesage(a)redhat.com> changed the Status of [bug 1222520|https://bugzilla.redhat.com/show_bug.cgi?id=1222520] from NEW to ASSIGNED > Wrong syntax of cache hints in the documentation > ------------------------------------------------- > > Key: TEIID-3481 > URL: https://issues.jboss.org/browse/TEIID-3481 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 8.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > The syntax for cache hint is as follows: > (1) cache[([pref_mem] [ttl:n] [updatable])] [scope:(session|user|vdb)] > So if user wants to use cache for specific scope (e.g. session) according to declared syntax it should be: > (2) cache scope:session > But using (2) teiid ignores the scope. What teiid accepts is: > cache(scope:session) > So I suggest to update (1) to: > cache[([pref_mem] [ttl:n] [updatable] [scope:(session|user|vdb)]*)]* -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3426) Salesforce importer does not set cardinalities

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3426?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3426: --------------------------------------- It looks like through the rest api there is an option to ask for an explian plan for a given query that includes a cardinality estimate. I'll see if that's appropriate. > Salesforce importer does not set cardinalities > ---------------------------------------------- > > Key: TEIID-3426 > URL: https://issues.jboss.org/browse/TEIID-3426 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Reporter: Burak Serdar > Assignee: Steven Hawkins > Fix For: 8.11 > > > The salesforce importer does not set cardinalities for salesforce objects it imports. That is causing problems with joins involving more than two tables, and when there are no criteria on a large table. If the large table is joined later, it retrieves all the rows of that table and joins them with the result of the previous joins. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3491) Add support for REGEXP_REPLACE

by Tom Arnold (JIRA)

[ https://issues.jboss.org/browse/TEIID-3491?page=com.atlassian.jira.plugin... ] Tom Arnold commented on TEIID-3491: ----------------------------------- I'm intending to do this one; just wanted to log this to make sure I didn't miss it existing somewhere. > Add support for REGEXP_REPLACE > ------------------------------ > > Key: TEIID-3491 > URL: https://issues.jboss.org/browse/TEIID-3491 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Add support for REGEXP_REPLACE function like in Postgres. > http://www.postgresql.org/docs/9.3/static/functions-string.html > Pushdown version might be tricky. > * MySQL - No support. > * Postgres - Good. > * Oracle - Good, but "g" flag to replace all matches is set by positional params instead. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3491) Add support for REGEXP_REPLACE

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3491: --------------------------------- Summary: Add support for REGEXP_REPLACE Key: TEIID-3491 URL: https://issues.jboss.org/browse/TEIID-3491 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Tom Arnold Assignee: Steven Hawkins Add support for REGEXP_REPLACE function like in Postgres. http://www.postgresql.org/docs/9.3/static/functions-string.html Pushdown version might be tricky. * MySQL - No support. * Postgres - Good. * Oracle - Good, but "g" flag to replace all matches is set by positional params instead. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3482) Multi-source joins should still be partitioned even if not fully pushed

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3482?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3482. ----------------------------------- Resolution: Won't Fix There are too many issues here with inferring intentions. It's much better to rely on the explicit path or to pursue a higher level multi-tenant feature. > Multi-source joins should still be partitioned even if not fully pushed > ----------------------------------------------------------------------- > > Key: TEIID-3482 > URL: https://issues.jboss.org/browse/TEIID-3482 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > A deficiency in join planning with multi-source is that partitioning only occurs if the join is pushed. If not pushed then we'll union the results and process a join across all of the results. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3270) Allow UDFs to call Teiid functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3270?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3270. ----------------------------------- Resolution: Done Added support and initial documentation, but did not restrict what can be used in the definition of the function. > Allow UDFs to call Teiid functions > ---------------------------------- > > Key: TEIID-3270 > URL: https://issues.jboss.org/browse/TEIID-3270 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Sanjeev Gour > Assignee: Steven Hawkins > Fix For: 8.11 > > > Currently custom functions require the implementation on be in Java, there could be an alternative way to allow using Teiid expressions inside the custom functions. The related thread is here- > https://developer.jboss.org/thread/251179 -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3151) Add Support for SAP HANA Sources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3151?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3151: --------------------------------------- I went ahead and merged the pull request, but wanted to double check is the concat modifier needed? It looks like https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/a380977519101494... they follow ansi where if either value is null the result is null > Add Support for SAP HANA Sources > -------------------------------- > > Key: TEIID-3151 > URL: https://issues.jboss.org/browse/TEIID-3151 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.11 > > > Need to add support SAP HANA. SAP provides a JDBC and ODBC driver for it. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

8 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2015