July 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4903) Create a new server quickstart for the new infinispan hotrod connector/translator

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4903?page=com.atlassian.jira.plugin... ] Van Halbert closed TEIID-4903. ------------------------------ > Create a new server quickstart for the new infinispan hotrod connector/translator > --------------------------------------------------------------------------------- > > Key: TEIID-4903 > URL: https://issues.jboss.org/browse/TEIID-4903 > Project: Teiid > Issue Type: Task > Components: Infinispan, Quick Starts > Affects Versions: 9.3.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.12.x-6.4, 9.3.2 > > > Create a new server quickstart for the new infinispan hotrod connector/translator. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[JBoss JIRA] (TEIID-4924) Prepare to push teiis-spring-boot to maven central

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4924?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4924: ------------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > Prepare to push teiis-spring-boot to maven central > -------------------------------------------------- > > Key: TEIID-4924 > URL: https://issues.jboss.org/browse/TEIID-4924 > Project: Teiid > Issue Type: Sub-task > Reporter: Kylin Soong > Assignee: Ramesh Reddy > Fix For: 10.0 > > > Prepare to push teiis-spring-boot to maven central. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[JBoss JIRA] (TEIID-4811) Certify and Add Support for Cloudera (CDH) version 5.8

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4811?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4811. ----------------------------------- Resolution: Rejected Rejecting the current version of this issue. It can be reopened and retargetted to community if needed. > Certify and Add Support for Cloudera (CDH) version 5.8 > ------------------------------------------------------ > > Key: TEIID-4811 > URL: https://issues.jboss.org/browse/TEIID-4811 > Project: Teiid > Issue Type: Feature Request > Reporter: Anu Saji > Assignee: Steven Hawkins > > Request to add Support for Cloudera (CDH) version 5.8 with JDV 6.3 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[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

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2017