[JBoss JIRA] (TEIID-2232) Update Hive translator for newer version of Hive Driver
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIID-2232:
-----------------------------------
Summary: Update Hive translator for newer version of Hive Driver
Key: TEIID-2232
URL: https://issues.jboss.org/browse/TEIID-2232
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors
Affects Versions: 8.1
Reporter: Ramesh Reddy
Originally Hive translator designed for 0.7 version of the Hive JDBC driver, the current version is "30 April, 2012: release 0.9.0 available".
Another important update we should do is take advantage of their direct map-reduce job submission through Hive as native command feature.
--
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
13 years, 1 month
[JBoss JIRA] Created: (TEIID-1131) Document/expand sequence support
by Steve Hawkins (JIRA)
Document/expand sequence support
--------------------------------
Key: TEIID-1131
URL: https://jira.jboss.org/browse/TEIID-1131
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector, Query Engine
Affects Versions: 7.0
Reporter: Steve Hawkins
Assignee: Steve Hawkins
Fix For: 7.1
Currently sequence workaround logic only exists for oracle and is undocumented. We should look at expanding sequence support - even for dynamic vdbs, see SQuriel's handling of system queries for retrieving sequence metadata.
At least allowing the workaround logic to work for all sources that support sequences (Postgres, DB2, etc.) would be good.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 1 month
[JBoss JIRA] (TEIID-2309) Add support for "conformed" tables in Teiid
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2309?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-2309:
--------------------------------
Assignee: Ramesh Reddy (was: Ken Johnson)
Complexity: High
Component/s: Query Engine
Affects: Documentation (Ref Guide, User Guide, etc.),Release Notes
> Add support for "conformed" tables in Teiid
> -------------------------------------------
>
> Key: TEIID-2309
> URL: https://issues.jboss.org/browse/TEIID-2309
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Debbie Steigner
> Assignee: Ramesh Reddy
>
> Teiid would support tables from different data sources being marked as "conformed", meaning they are the same (or perhaps a different name). When optimising a query, it would take the conformity into account and choose the appropriate copy of the table (presumably one in the same database as other tables in the query, if available). I would not regard it as a problem if Teiid *required* the dimensions to be strictly the same as opposed to permitting subsets, though as with so many areas, it would be up to the user to ensure this was really true: I would not expect the engine to do anything to verify that the tables really were conformed.
> Usecase:
> In Data Warehousing, it is relatively common to have multiple copies of the same dimensions spread over multiple Data Warehouses or Marts, or in the same Data Warehouse when associated with different Fact Tables. If these copies are either identical or strict subsets of an idealised dimension (and, by extension, share *exactly* the same naming and structure), then they may be said to be "conformed". It is expected that the dimension includes at least the values required to support the facts in the database in which it occurs or the Fact Table to which it is paired.
> Example:
>
> Source S1:
>
> BIGBIGBIG (millions of rows)
> bigkey
> ccy
> other_stuff
>
> CURRENCY (100s of rows) let's call it S1_CCY if we need to distinguish
> ccy
> ccy_name
>
>
> Source S2:
>
> BIGGER (millions of rows)
> biggerkey
> bigkey
> ccy
> more_stuff
>
> CURRENCY (100s of rows) similarly, S2_CCY
> ccy
> ccy_name
>
>
> When executing:
>
> SELECT B.*
> FROM BIGBIGBIG B,
> CURRENCY CCY
> WHERE B.ccy = CCY.ccy
> AND CCY.ccy_name LIKE "%DOLLAR%"
>
> Then it is clearly advantageous to use the copy of CURRENCY in S1 and re-write the query using S1_CCY. In this situation, federation is eliminated completely.
>
--
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
13 years, 1 month
[JBoss JIRA] (TEIID-2309) Add support for "conformed" tables in Teiid
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2309?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-2309:
--------------------------------
Assignee: (was: Ramesh Reddy)
> Add support for "conformed" tables in Teiid
> -------------------------------------------
>
> Key: TEIID-2309
> URL: https://issues.jboss.org/browse/TEIID-2309
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Debbie Steigner
>
> Teiid would support tables from different data sources being marked as "conformed", meaning they are the same (or perhaps a different name). When optimising a query, it would take the conformity into account and choose the appropriate copy of the table (presumably one in the same database as other tables in the query, if available). I would not regard it as a problem if Teiid *required* the dimensions to be strictly the same as opposed to permitting subsets, though as with so many areas, it would be up to the user to ensure this was really true: I would not expect the engine to do anything to verify that the tables really were conformed.
> Usecase:
> In Data Warehousing, it is relatively common to have multiple copies of the same dimensions spread over multiple Data Warehouses or Marts, or in the same Data Warehouse when associated with different Fact Tables. If these copies are either identical or strict subsets of an idealised dimension (and, by extension, share *exactly* the same naming and structure), then they may be said to be "conformed". It is expected that the dimension includes at least the values required to support the facts in the database in which it occurs or the Fact Table to which it is paired.
> Example:
>
> Source S1:
>
> BIGBIGBIG (millions of rows)
> bigkey
> ccy
> other_stuff
>
> CURRENCY (100s of rows) let's call it S1_CCY if we need to distinguish
> ccy
> ccy_name
>
>
> Source S2:
>
> BIGGER (millions of rows)
> biggerkey
> bigkey
> ccy
> more_stuff
>
> CURRENCY (100s of rows) similarly, S2_CCY
> ccy
> ccy_name
>
>
> When executing:
>
> SELECT B.*
> FROM BIGBIGBIG B,
> CURRENCY CCY
> WHERE B.ccy = CCY.ccy
> AND CCY.ccy_name LIKE "%DOLLAR%"
>
> Then it is clearly advantageous to use the copy of CURRENCY in S1 and re-write the query using S1_CCY. In this situation, federation is eliminated completely.
>
--
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
13 years, 1 month
[JBoss JIRA] (TEIID-2309) Add support for "conformed" tables in Teiid
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2309?page=com.atlassian.jira.plugin... ]
Ramesh Reddy moved PRODMGT-276 to TEIID-2309:
---------------------------------------------
Project: Teiid (was: Product Management)
Key: TEIID-2309 (was: PRODMGT-276)
Workflow: jira (was: JBoss Platforms RFE Workflow v2)
> Add support for "conformed" tables in Teiid
> -------------------------------------------
>
> Key: TEIID-2309
> URL: https://issues.jboss.org/browse/TEIID-2309
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Debbie Steigner
> Assignee: Ken Johnson
>
> Teiid would support tables from different data sources being marked as "conformed", meaning they are the same (or perhaps a different name). When optimising a query, it would take the conformity into account and choose the appropriate copy of the table (presumably one in the same database as other tables in the query, if available). I would not regard it as a problem if Teiid *required* the dimensions to be strictly the same as opposed to permitting subsets, though as with so many areas, it would be up to the user to ensure this was really true: I would not expect the engine to do anything to verify that the tables really were conformed.
> Usecase:
> In Data Warehousing, it is relatively common to have multiple copies of the same dimensions spread over multiple Data Warehouses or Marts, or in the same Data Warehouse when associated with different Fact Tables. If these copies are either identical or strict subsets of an idealised dimension (and, by extension, share *exactly* the same naming and structure), then they may be said to be "conformed". It is expected that the dimension includes at least the values required to support the facts in the database in which it occurs or the Fact Table to which it is paired.
> Example:
>
> Source S1:
>
> BIGBIGBIG (millions of rows)
> bigkey
> ccy
> other_stuff
>
> CURRENCY (100s of rows) let's call it S1_CCY if we need to distinguish
> ccy
> ccy_name
>
>
> Source S2:
>
> BIGGER (millions of rows)
> biggerkey
> bigkey
> ccy
> more_stuff
>
> CURRENCY (100s of rows) similarly, S2_CCY
> ccy
> ccy_name
>
>
> When executing:
>
> SELECT B.*
> FROM BIGBIGBIG B,
> CURRENCY CCY
> WHERE B.ccy = CCY.ccy
> AND CCY.ccy_name LIKE "%DOLLAR%"
>
> Then it is clearly advantageous to use the copy of CURRENCY in S1 and re-write the query using S1_CCY. In this situation, federation is eliminated completely.
>
--
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
13 years, 1 month