September 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3625) JDG translator has disabled capabilities for GT and LT

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3625?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3625: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1252914|https://bugzilla.redhat.com/show_bug.cgi?id=1252914] from ON_QA to ASSIGNED > JDG translator has disabled capabilities for GT and LT > ------------------------------------------------------ > > Key: TEIID-3625 > URL: https://issues.jboss.org/browse/TEIID-3625 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Filip Elias > Assignee: Steven Hawkins > Fix For: 8.12 > > > Operations GT and LT are not pushed down to JDG. Indexes are enabled for all columns. Operations GE and LE are pushed down correctly. > Example: > The first query is pushed down correctly. The second query doesn't push the "greater than" operator to the source. > Query: > {code}select intkey from smalla where intNum >= 5 order by intkey{code} > PROCESSOR PLAN: > {code} > AccessNode(0) output=[c.intKey AS IntKey] SELECT g_0.intKey FROM SmallAs.smallARemotecache AS g_0 WHERE g_0.intNum >= 5 ORDER BY g_0.intKey > {code} > Query: > {code}select intkey from smalla where intNum > 5 order by intkey{code} > Plan: > {code} > SortNode(0) output=[c.intKey AS IntKey] [SORT] [IntKey] > ProjectNode(1) output=[c.intKey AS IntKey] [c.intKey AS IntKey] > SelectNode(2) output=[c.intKey] c.intNum > 5 > AccessNode(3) output=[c.intNum, c.intKey] SELECT g_0.intNum, g_0.intKey FROM SmallAs.smallARemotecache AS g_0 > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Barry LaFond commented on TEIID-3671: ------------------------------------- [~kairuppala.prashanthi(a)wipro.com] can you attach the virtual model or at least add the SQL statements (transformations) for your virtual model? > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Prashanthi Kairuppala (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Prashanthi Kairuppala updated TEIID-3671: ----------------------------------------- Component/s: OData > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Prashanthi Kairuppala > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3671) filter on child table not working

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] Steven Hawkins moved TEIIDDES-2634 to TEIID-3671: ------------------------------------------------- Project: Teiid (was: Teiid Designer) Key: TEIID-3671 (was: TEIIDDES-2634) > filter on child table not working > --------------------------------- > > Key: TEIID-3671 > URL: https://issues.jboss.org/browse/TEIID-3671 > Project: Teiid > Issue Type: Bug > Reporter: Prashanthi Kairuppala > Priority: Critical > Attachments: parent_childTables.PNG > > > > Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13. > > Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22' > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3623) HBase translator - boolean and biginteger values are not translated correctly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3623?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3623: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1252385|https://bugzilla.redhat.com/show_bug.cgi?id=1252385] from ON_QA to VERIFIED > HBase translator - boolean and biginteger values are not translated correctly > ----------------------------------------------------------------------------- > > Key: TEIID-3623 > URL: https://issues.jboss.org/browse/TEIID-3623 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12 > > Attachments: insert_biginteger.log, inser_boolean.log > > > *1. Boolean values:* The Teiid translates the value true/false as 1/0, but HBase does not support integer representation of boolean values [1]. > *2. BigInteger values ( <= -2):* Teiid's bigInteger data type is wider than HBase's bigint (as wide as long) type, so it make sense to define column in HBase as e.g. _decimal(30,0)_ and map it to Teiid's biginteger type. > From Teiid's point of view: There is no problem if inserted value is greater than or equal to -1. But if the value is less than -1, then a ClassCastException is thrown [2]. Phoenix driver require something like "UPSERT INTO smalla (intkey, bigintegervalue) VALUES (1, -10 *.0*)" > [1] > *Query:* insert into hbase.smalla (intkey, booleanvalue) values (55, true) > *Column definition:* > - source: booleanvalue boolean > - VDB: BooleanValue boolean OPTIONS (nameinsource 'booleanvalue', NATIVE_TYPE 'boolean') > *Stack trace:* > insert_boolean.log > [2] > *Query:* insert into hbase.smalla (intkey, bigintegervalue) values (55, -10) > *Column definition:* > - source: bigintegervalue decimal(20,0) > - VDB: BigIntegerValue biginteger OPTIONS (nameinsource 'bigintegervalue', NATIVE_TYPE 'decimal') > *Stack trace:* > insert_biginteger.log -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3622) HBase translator - INSERT could rewrite the data

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3622?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3622: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1252340|https://bugzilla.redhat.com/show_bug.cgi?id=1252340] from ON_QA to VERIFIED > HBase translator - INSERT could rewrite the data > ------------------------------------------------ > > Key: TEIID-3622 > URL: https://issues.jboss.org/browse/TEIID-3622 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > The HBase translator translates INSERT as UPSERT, which is an "alias" for both INSERT and UPDATE statement. It means, if user issues same INSERT statement twice, no exception is thrown [1]. I expect that [2] could rewrite the data. > *Additional note*: I was not able to verify my assumption because of https://issues.jboss.org/browse/TEIID-3619 > [1] > INSERT INTO smalla (intkey) VALUES (55) is translated as UPSERT INTO smalla (intkey) VALUES (55) > http://phoenix.apache.org/language/index.html#upsert_values > [2] > INSERT INTO smalla (intkey, name) VALUES (1, 'name1') > INSERT INTO smalla (intkey, name) VALUES (1, 'name2') -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3620) HBase translator - date, time, timestamp values are not translated correctly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3620?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3620: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1252312|https://bugzilla.redhat.com/show_bug.cgi?id=1252312] from ON_QA to VERIFIED > HBase translator - date, time, timestamp values are not translated correctly > ---------------------------------------------------------------------------- > > Key: TEIID-3620 > URL: https://issues.jboss.org/browse/TEIID-3620 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12 > > Attachments: insert.log, select.log, update.log > > > Using date/time/timestamp value in SQL query causes an exception [1] - {ts '...'}/{d '...'}/{t '...'} is not supported by Phoenix Driver.The issue is present in all types of statements (select, insert, update). -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3616) HBase translator - NPE if date value is 'null'

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3616?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3616: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1252005|https://bugzilla.redhat.com/show_bug.cgi?id=1252005] from ON_QA to VERIFIED > HBase translator - NPE if date value is 'null' > ---------------------------------------------- > > Key: TEIID-3616 > URL: https://issues.jboss.org/browse/TEIID-3616 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.12 > > Attachments: log > > > If the source table in HBase contains a 'NULL' date value, Teiid throws an NPE. I did not encounter any NPE using org.apache.phoenix.jdbc.PhoenixDriver [1]. Other data types seem to be OK too. > I have tried integer, char, varchar, float, double, tinyint, smallint, bigint, decimal, varbinary, boolean, time, date, timestamp. > [1] > Connection con = new org.apache.phoenix.jdbc.PhoenixDriver().connect("jdbc:phoenix:localhost", new Properties()) > ResultSet rs = con.createStatement().executeQuery("select datevalue from smalla"); > while(rs.next()){ > System.out.println(rs.getDate(1)); > } -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3622) HBase translator - INSERT could rewrite the data

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3622?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3622: ------------------------------------------------ David Le Sage <dlesage(a)redhat.com> changed the Status of [bug 1252340|https://bugzilla.redhat.com/show_bug.cgi?id=1252340] from ASSIGNED to ON_QA > HBase translator - INSERT could rewrite the data > ------------------------------------------------ > > Key: TEIID-3622 > URL: https://issues.jboss.org/browse/TEIID-3622 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > The HBase translator translates INSERT as UPSERT, which is an "alias" for both INSERT and UPDATE statement. It means, if user issues same INSERT statement twice, no exception is thrown [1]. I expect that [2] could rewrite the data. > *Additional note*: I was not able to verify my assumption because of https://issues.jboss.org/browse/TEIID-3619 > [1] > INSERT INTO smalla (intkey) VALUES (55) is translated as UPSERT INTO smalla (intkey) VALUES (55) > http://phoenix.apache.org/language/index.html#upsert_values > [2] > INSERT INTO smalla (intkey, name) VALUES (1, 'name1') > INSERT INTO smalla (intkey, name) VALUES (1, 'name2') -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3541) Remove the Teiid embedded kit

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3541?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3541: --------------------------------------- Van are you talking about translator development, or something else? > Remove the Teiid embedded kit > ----------------------------- > > Key: TEIID-3541 > URL: https://issues.jboss.org/browse/TEIID-3541 > Project: Teiid > Issue Type: Task > Components: Embedded > Reporter: Ramesh Reddy > Assignee: Kylin Soong > Fix For: 8.12 > > > There is no reason to keep a separate embedded kit supplied by Teiid. The scripts that are building the kit needs to be removed from build. > All the required jar files for the "embedded" examples will be available from the "teiid-embedded-examples". Here we need to focus on documentation, but that is separate effort -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 4 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2015