[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-4977:
------------------------------------
Quikstarts have been updated to support JDG 76.1 and removed the quickstarts that supported JDG 6.
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan, Quick Starts
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.12.x-6.4, 9.3.2
>
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4989) Impala - Select * fails with reserved words in query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4989?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4989:
---------------------------------------
This happens when using the default import, but not with the useDatabaseMetaData option correct?
> Impala - Select * fails with reserved words in query
> ----------------------------------------------------
>
> Key: TEIID-4989
> URL: https://issues.jboss.org/browse/TEIID-4989
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Affects Versions: 9.1.3
> Environment: Ubuntu linux 6+ x64
> Reporter: Don Krapohl
> Assignee: Steven Hawkins
> Priority: Minor
>
> Impala translator can handle reserved words in queries by quoting but doing select * the query fails in an unhelpful way. Example:
> --succeeds
> select calendar_type,
> start_date,
> calendar_year,
> quarter_structure,
> date_key,
> 'month',
> week,
> day_of_month
> from warehouse.dim_advertiser_calendar;
> fails due to reserved word "month" as a column in the virtual table:
> select * from warehouse.dim_advertiser_calendar;
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4988) Oracle - table alias is not used in whole query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4988?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4988:
---------------------------------------
Please provide a vdb if possible.
> Oracle - table alias is not used in whole query
> -----------------------------------------------
>
> Key: TEIID-4988
> URL: https://issues.jboss.org/browse/TEIID-4988
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x-6.4
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> When I run query like \[1\] Teiid translates it to query which does not use one of table aliases in whole query. Oracle (11g 11.2.0.2.0) seems to be sensitive to aliasing table and then not using it. Query fails. Source specific query (problematic one) \[2\].
> Sample query which fails if running directly against Oracle database \[3\]
> {code:sql|title=\[1\] Query}
> select
> s_name,
> s_address
> from
> tpch1.soaeds.supplier,
> tpch1.soaeds.nation
> where
> s_supplierkey in (
> select
> ps_supplierkey
> from
> tpch2.soaeds.partsupp
> where
> ps_partkey in (
> select
> p_partkey
> from
> tpch2.soaeds.part
> where
> p_name like 'powder%'
> )
> and ps_availqty > (
> select
> 0.5 * sum(l_quantity)
> from
> tpch2.soaeds.lineitem
> where
> l_partkey = ps_partkey
> and l_supplierkey = ps_supplierkey
> and l_shipdate >= '1994-01-01'
> and l_shipdate < TIMESTAMPADD(SQL_TSI_YEAR,'1', '1994-01-01')
> )
> )
> and s_nationkey = n_nationkey
> and n_name = 'BRAZIL'
> order by
> s_name;
> {code}
> {code:sql|title=\[2\] Source-specific query}
> SELECT g_0."PS_SUPPLIERKEY" AS c_0 FROM "SOAEDS"."PARTSUPP" g_0 WHERE g_0."PS_PARTKEY" IN (SELECT g_1."P_PARTKEY" FROM "SOAEDS"."PART" g_1 WHERE g_1."P_NAME" LIKE 'powder%') AND g_0."PS_AVAILQTY" > (SELECT (0.5 * SUM(g_2."L_QUANTITY")) FROM "SOAEDS"."LINEITEM" g_2 WHERE g_2."L_PARTKEY" = "SOAEDS"."PARTSUPP"."PS_PARTKEY" AND g_2."L_SUPPLIERKEY" = "SOAEDS"."PARTSUPP"."PS_SUPPLIERKEY" AND g_2."L_SHIPDATE" >= to_date('1994-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND g_2."L_SHIPDATE" < ?) ORDER BY c_0
> {code}
> {code:sql|title=\[3\] Oracle query}
> SELECT smalla.intkey FROM smalla a
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4989) Impala - Select * fails with reserved words in query
by Don Krapohl (JIRA)
Don Krapohl created TEIID-4989:
----------------------------------
Summary: Impala - Select * fails with reserved words in query
Key: TEIID-4989
URL: https://issues.jboss.org/browse/TEIID-4989
Project: Teiid
Issue Type: Enhancement
Components: JDBC Connector
Affects Versions: 9.1.3
Environment: Ubuntu linux 6+ x64
Reporter: Don Krapohl
Assignee: Steven Hawkins
Priority: Minor
Impala translator can handle reserved words in queries by quoting but doing select * the query fails in an unhelpful way. Example:
--succeeds
select calendar_type,
start_date,
calendar_year,
quarter_structure,
date_key,
'month',
week,
day_of_month
from warehouse.dim_advertiser_calendar;
fails due to reserved word "month" as a column in the virtual table:
select * from warehouse.dim_advertiser_calendar;
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4988) Oracle - table alias is not used in whole query
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-4988?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-4988:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1469946
Bugzilla Update: Perform
> Oracle - table alias is not used in whole query
> -----------------------------------------------
>
> Key: TEIID-4988
> URL: https://issues.jboss.org/browse/TEIID-4988
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.12.x-6.4
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> When I run query like \[1\] Teiid translates it to query which does not use one of table aliases in whole query. Oracle (11g 11.2.0.2.0) seems to be sensitive to aliasing table and then not using it. Query fails. Source specific query (problematic one) \[2\].
> Sample query which fails if running directly against Oracle database \[3\]
> {code:sql|title=\[1\] Query}
> select
> s_name,
> s_address
> from
> tpch1.soaeds.supplier,
> tpch1.soaeds.nation
> where
> s_supplierkey in (
> select
> ps_supplierkey
> from
> tpch2.soaeds.partsupp
> where
> ps_partkey in (
> select
> p_partkey
> from
> tpch2.soaeds.part
> where
> p_name like 'powder%'
> )
> and ps_availqty > (
> select
> 0.5 * sum(l_quantity)
> from
> tpch2.soaeds.lineitem
> where
> l_partkey = ps_partkey
> and l_supplierkey = ps_supplierkey
> and l_shipdate >= '1994-01-01'
> and l_shipdate < TIMESTAMPADD(SQL_TSI_YEAR,'1', '1994-01-01')
> )
> )
> and s_nationkey = n_nationkey
> and n_name = 'BRAZIL'
> order by
> s_name;
> {code}
> {code:sql|title=\[2\] Source-specific query}
> SELECT g_0."PS_SUPPLIERKEY" AS c_0 FROM "SOAEDS"."PARTSUPP" g_0 WHERE g_0."PS_PARTKEY" IN (SELECT g_1."P_PARTKEY" FROM "SOAEDS"."PART" g_1 WHERE g_1."P_NAME" LIKE 'powder%') AND g_0."PS_AVAILQTY" > (SELECT (0.5 * SUM(g_2."L_QUANTITY")) FROM "SOAEDS"."LINEITEM" g_2 WHERE g_2."L_PARTKEY" = "SOAEDS"."PARTSUPP"."PS_PARTKEY" AND g_2."L_SUPPLIERKEY" = "SOAEDS"."PARTSUPP"."PS_SUPPLIERKEY" AND g_2."L_SHIPDATE" >= to_date('1994-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND g_2."L_SHIPDATE" < ?) ORDER BY c_0
> {code}
> {code:sql|title=\[3\] Oracle query}
> SELECT smalla.intkey FROM smalla a
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4988) Oracle - table alias is not used in whole query
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-4988:
-----------------------------------
Summary: Oracle - table alias is not used in whole query
Key: TEIID-4988
URL: https://issues.jboss.org/browse/TEIID-4988
Project: Teiid
Issue Type: Bug
Affects Versions: 8.12.x-6.4
Reporter: Juraj Duráni
Assignee: Steven Hawkins
When I run query like \[1\] Teiid translates it to query which does not use one of table aliases in whole query. Oracle (11g 11.2.0.2.0) seems to be sensitive to aliasing table and then not using it. Query fails. Source specific query (problematic one) \[2\].
Sample query which fails if running directly against Oracle database \[3\]
{code:sql|title=\[1\] Query}
select
s_name,
s_address
from
tpch1.soaeds.supplier,
tpch1.soaeds.nation
where
s_supplierkey in (
select
ps_supplierkey
from
tpch2.soaeds.partsupp
where
ps_partkey in (
select
p_partkey
from
tpch2.soaeds.part
where
p_name like 'powder%'
)
and ps_availqty > (
select
0.5 * sum(l_quantity)
from
tpch2.soaeds.lineitem
where
l_partkey = ps_partkey
and l_supplierkey = ps_supplierkey
and l_shipdate >= '1994-01-01'
and l_shipdate < TIMESTAMPADD(SQL_TSI_YEAR,'1', '1994-01-01')
)
)
and s_nationkey = n_nationkey
and n_name = 'BRAZIL'
order by
s_name;
{code}
{code:sql|title=\[2\] Source-specific query}
SELECT g_0."PS_SUPPLIERKEY" AS c_0 FROM "SOAEDS"."PARTSUPP" g_0 WHERE g_0."PS_PARTKEY" IN (SELECT g_1."P_PARTKEY" FROM "SOAEDS"."PART" g_1 WHERE g_1."P_NAME" LIKE 'powder%') AND g_0."PS_AVAILQTY" > (SELECT (0.5 * SUM(g_2."L_QUANTITY")) FROM "SOAEDS"."LINEITEM" g_2 WHERE g_2."L_PARTKEY" = "SOAEDS"."PARTSUPP"."PS_PARTKEY" AND g_2."L_SUPPLIERKEY" = "SOAEDS"."PARTSUPP"."PS_SUPPLIERKEY" AND g_2."L_SHIPDATE" >= to_date('1994-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND g_2."L_SHIPDATE" < ?) ORDER BY c_0
{code}
{code:sql|title=\[3\] Oracle query}
SELECT smalla.intkey FROM smalla a
{code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4977) Support materialization as the 8.12.x version did
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4977?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4977:
-------------------------------------
Cool, the next step is when the dynamic cache creation is available in Infinispan, make this as simple as current internal materialization, where one would need to flip the flag, with no other configuration.
> Support materialization as the 8.12.x version did
> -------------------------------------------------
>
> Key: TEIID-4977
> URL: https://issues.jboss.org/browse/TEIID-4977
> Project: Teiid
> Issue Type: Feature Request
> Components: Infinispan, Quick Starts
> Affects Versions: 8.12.x-6.4
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Priority: Critical
> Fix For: 8.12.x-6.4, 9.3.2
>
> Attachments: ispn-vdb.xml, jdg-mat-cache-vdb.xml
>
>
> Need to enable the materialization process to load the cache "offline" and not impact access to current cache and data. This would be similar to how the 8.12.x version was implemented and similar to how RDBMS materialization is done.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months