[JBoss JIRA] (TEIID-3934) Additional must pushdown support
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3934:
-------------------------------------
Summary: Additional must pushdown support
Key: TEIID-3934
URL: https://issues.jboss.org/browse/TEIID-3934
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0
TEIID-3227 effectively addressed subexpressions within aggregate functions. This should be more generally expanded..
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3927) Teiid Analytical Capabilities
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3927?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3927:
----------------------------------
Description:
For the 9.x series goals include:
* Support for row counts beyond 2 billion TEIID-3601
* Increased parallelism within the plan, which includes parallelization of source queries via partitioning beyond multi-source
* Increased windowing function support
* Improvements to the micro-batching / continuous query model
was:
>From DV 7(teiid 9.x) F2F notes, Analytical Capabilities be referred in 2 approach:
h2. Do our own
* Support for row counts beyond 2 billion (done)
* Increased parallism within the plan, which includes parallelization of source queries via partitioning beyond multi-source
* Increased windowing function support
h2. Alignment with a larger platform
TEIID-3928
> Teiid Analytical Capabilities
> -----------------------------
>
> Key: TEIID-3927
> URL: https://issues.jboss.org/browse/TEIID-3927
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> For the 9.x series goals include:
> * Support for row counts beyond 2 billion TEIID-3601
> * Increased parallelism within the plan, which includes parallelization of source queries via partitioning beyond multi-source
> * Increased windowing function support
> * Improvements to the micro-batching / continuous query model
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3928) Usage with analytical platforms
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3928?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3928:
----------------------------------
Description: We should promote analytical platforms, such as Spark/Hive/PrestoDB, with usages of Teiid/DV as a data loader (we support a wider variety of sources can have views that perform incoming transformation/filtering logic) and for top level integration (since we provide more robust client support, transaction support, and broader federation). This effort will include documentation, additional integration code, and sample code. (was: Copy from Teiid 9.x DV7 F2F Notes
{note}
We should promote with analytical platforms, such as Spark/Hive/PrestoDB, are usages of Teiid/DV as a data loader (we support a wider variety of sources can have views that perform incoming transformation/filtering logic) and for top level integration (since we provide more robust client support, transaction support, and broader federation). Those usages present a cooperative pairing with an analytical platform - however we know that over time these projects will continue to creep into the virtualization space as users need more robust odbc/jdbc, write/oltp workload support, etc.
As an organization we may align with the Spark platform / ecosystem. If that is the case, then we will give heavy preference to Spark integration.
{note}
h2. Task we need do
Spend time on Spark integration, Write document, Add integration code, sample code.)
Summary: Usage with analytical platforms (was: Alignment with a larger platform)
> Usage with analytical platforms
> -------------------------------
>
> Key: TEIID-3928
> URL: https://issues.jboss.org/browse/TEIID-3928
> Project: Teiid
> Issue Type: Sub-task
> Affects Versions: 9.x
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> We should promote analytical platforms, such as Spark/Hive/PrestoDB, with usages of Teiid/DV as a data loader (we support a wider variety of sources can have views that perform incoming transformation/filtering logic) and for top level integration (since we provide more robust client support, transaction support, and broader federation). This effort will include documentation, additional integration code, and sample code.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3918) HIVE translator does not support direct query procedure
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3918?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3918.
-----------------------------------
Fix Version/s: 9.0
Resolution: Done
Removed the override that disabled direct procedures.
> HIVE translator does not support direct query procedure
> -------------------------------------------------------
>
> Key: TEIID-3918
> URL: https://issues.jboss.org/browse/TEIID-3918
> Project: Teiid
> Issue Type: Feature Request
> Reporter: jie tao
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> I used EXEC native (sqlstring) to let my query be executed directly on my Hive without Teiid's modification of my query. This works with MySQL. For HIVE I got:
> "org.teiid.jdbc.TeiidSQLException: TEIID30504 Hive13: TEIID24000 This EXEC native('select a.game, a.lang, get_json_object(a.json, \"$.product\") from test.event_log a') command not supported.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3918) HIVE translator does not support direct query procedure
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3918?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3918:
----------------------------------
Component/s: JDBC Connector
> HIVE translator does not support direct query procedure
> -------------------------------------------------------
>
> Key: TEIID-3918
> URL: https://issues.jboss.org/browse/TEIID-3918
> Project: Teiid
> Issue Type: Feature Request
> Components: JDBC Connector
> Reporter: jie tao
> Assignee: Steven Hawkins
> Fix For: 9.0
>
>
> I used EXEC native (sqlstring) to let my query be executed directly on my Hive without Teiid's modification of my query. This works with MySQL. For HIVE I got:
> "org.teiid.jdbc.TeiidSQLException: TEIID30504 Hive13: TEIID24000 This EXEC native('select a.game, a.lang, get_json_object(a.json, \"$.product\") from test.event_log a') command not supported.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3559) Refactor Object and Infinispan translator / connectors
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3559?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3559.
-----------------------------------
Fix Version/s: 9.0
8.12.5
Resolution: Done
Pull in Van's changes.
> Refactor Object and Infinispan translator / connectors
> ------------------------------------------------------
>
> Key: TEIID-3559
> URL: https://issues.jboss.org/browse/TEIID-3559
> Project: Teiid
> Issue Type: Task
> Components: Misc. Connectors
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Optional
> Fix For: 9.0, 8.12.5
>
>
> Now that JDG has reworked its remote-cache and changed (reduced) what dependencies its exposed, there's now more common code between the object/infinispan-cache translator/connector and the infinispan-cache-dsl translator/connector. I think refactoring can eliminate issues with support and ensure common behavior across all the code.
> Where is common code seen:
> - searching (i.e., DSLSearch)
> - updates (InfinispanUpdateExecution)
> - ClassRegistry
> (for starters)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3725) In the JDG translators, enable named cache swapping so that materialization can be supported
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3725?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3725:
------------------------------------
I've need to add the documentation for this.
> In the JDG translators, enable named cache swapping so that materialization can be supported
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3725
> URL: https://issues.jboss.org/browse/TEIID-3725
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Van Halbert
> Assignee: Van Halbert
> Fix For: 9.0, 8.12.5
>
>
> The JDG translators, that in order to support materialization, will need to enable the named cache that's referenced by the connection, to be swapped. This is due to JDG doesn't currently support renaming a cache (i.e., like table rename in JDBC). And because of that, it limits how the cache can be refreshed (don't want to clear it before re-loading).
> Ideas are:
> 1. configure translator with the 2 cache names to use (a) initial cache to read from and (b) the staging cache to use
> perform materialize load
> call SYSADMIN.setProperty to trigger the swapping of the cache names
> 2 ???
> Note: because there's no persistence in Teiid so that any cache name changes will outlive a server restart, when a restart occurs, the translator will read from the cache identified as the initial cache to read from.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months