October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-3796: ------------------------------------ Query with Teiid slow may caused by GC, have you ever tried a larger heap(-Xms4096m -Xmx4096m)? > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Bug > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > Postgresql Version: server 9.2.7 > Postgresql DB JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar > The table definition: > {code} > | Type | Modifiers > ------------+-----------------------------+------------------------------------------------------------ > | integer | not null > | integer | > | integer | not null > | timestamp without time zone | not null > | integer | not null > | text | > | text | > | bigint | > | bigint | not null > | integer | > {code} > I set driver connection parameter to disableLocalTxn=true;FetchSize=10; > 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. > 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, > when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Xian Liu (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Xian Liu updated TEIID-3796: ---------------------------- Description: There is a table about 1000K+ record Postgresql Version: server 9.2.7 Postgresql DB JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar The table definition: {code} | Type | Modifiers ------------+-----------------------------+------------------------------------------------------------ | integer | not null | integer | | integer | not null | timestamp without time zone | not null | integer | not null | text | | text | | bigint | | bigint | not null | integer | {code} I set driver connection parameter to disableLocalTxn=true;FetchSize=10; 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. was: There is a table about 1000K+ record Postgresql Version: server 9.2.7 JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar The table definition: {code} | Type | Modifiers ------------+-----------------------------+------------------------------------------------------------ | integer | not null | integer | | integer | not null | timestamp without time zone | not null | integer | not null | text | | text | | bigint | | bigint | not null | integer | {code} I set driver connection parameter to disableLocalTxn=true;FetchSize=10; 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Feature Request > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > Postgresql Version: server 9.2.7 > Postgresql DB JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar > The table definition: > {code} > | Type | Modifiers > ------------+-----------------------------+------------------------------------------------------------ > | integer | not null > | integer | > | integer | not null > | timestamp without time zone | not null > | integer | not null > | text | > | text | > | bigint | > | bigint | not null > | integer | > {code} > I set driver connection parameter to disableLocalTxn=true;FetchSize=10; > 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. > 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, > when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Xian Liu (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Xian Liu updated TEIID-3796: ---------------------------- Issue Type: Bug (was: Feature Request) > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Bug > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > Postgresql Version: server 9.2.7 > Postgresql DB JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar > The table definition: > {code} > | Type | Modifiers > ------------+-----------------------------+------------------------------------------------------------ > | integer | not null > | integer | > | integer | not null > | timestamp without time zone | not null > | integer | not null > | text | > | text | > | bigint | > | bigint | not null > | integer | > {code} > I set driver connection parameter to disableLocalTxn=true;FetchSize=10; > 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. > 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, > when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Xian Liu (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Xian Liu updated TEIID-3796: ---------------------------- Description: There is a table about 1000K+ record Postgresql Version: server 9.2.7 JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar The table definition: {code} | Type | Modifiers ------------+-----------------------------+------------------------------------------------------------ | integer | not null | integer | | integer | not null | timestamp without time zone | not null | integer | not null | text | | text | | bigint | | bigint | not null | integer | {code} I set driver connection parameter to disableLocalTxn=true;FetchSize=10; 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. was: There is a table about 1000K+ record Postgresql Version: server 9.2.7 JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar The table definition: {code} | Type | Modifiers ------------+-----------------------------+------------------------------------------------------------ | integer | not null | integer | | integer | not null | timestamp without time zone | not null | integer | not null | text | | text | | bigint | | bigint | not null | integer | {code} I set driver connection parameter to disableLocalTxn=true;FetchSize=10, 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Feature Request > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > Postgresql Version: server 9.2.7 > JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar > The table definition: > {code} > | Type | Modifiers > ------------+-----------------------------+------------------------------------------------------------ > | integer | not null > | integer | > | integer | not null > | timestamp without time zone | not null > | integer | not null > | text | > | text | > | bigint | > | bigint | not null > | integer | > {code} > I set driver connection parameter to disableLocalTxn=true;FetchSize=10; > 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. > 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, > when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Xian Liu (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Xian Liu updated TEIID-3796: ---------------------------- Description: There is a table about 1000K+ record Postgresql Version: server 9.2.7 JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar The table definition: {code} | Type | Modifiers ------------+-----------------------------+------------------------------------------------------------ | integer | not null | integer | | integer | not null | timestamp without time zone | not null | integer | not null | text | | text | | bigint | | bigint | not null | integer | {code} I set driver connection parameter to disableLocalTxn=true;FetchSize=10, 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. was: There is a table about 1000K+ record The table definition: {code} | Type | Modifiers ------------+-----------------------------+------------------------------------------------------------ | integer | not null | integer | | integer | not null | timestamp without time zone | not null | integer | not null | text | | text | | bigint | | bigint | not null | integer | {code} When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Feature Request > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > Postgresql Version: server 9.2.7 > JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar > The table definition: > {code} > | Type | Modifiers > ------------+-----------------------------+------------------------------------------------------------ > | integer | not null > | integer | > | integer | not null > | timestamp without time zone | not null > | integer | not null > | text | > | text | > | bigint | > | bigint | not null > | integer | > {code} > I set driver connection parameter to disableLocalTxn=true;FetchSize=10, > 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. > 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, > when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Xian Liu (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Xian Liu updated TEIID-3796: ---------------------------- Description: There is a table about 1000K+ record The table definition: {code} | Type | Modifiers ------------+-----------------------------+------------------------------------------------------------ | integer | not null | integer | | integer | not null | timestamp without time zone | not null | integer | not null | text | | text | | bigint | | bigint | not null | integer | {code} When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. was: There is a table about 1000K+ record The table definition: {code} {code} When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Feature Request > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > The table definition: > {code} > | Type | Modifiers > ------------+-----------------------------+------------------------------------------------------------ > | integer | not null > | integer | > | integer | not null > | timestamp without time zone | not null > | integer | not null > | text | > | text | > | bigint | > | bigint | not null > | integer | > {code} > When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. > But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Xian Liu (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Xian Liu updated TEIID-3796: ---------------------------- Description: There is a table about 1000K+ record The table definition: {code} {code} When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. was: There is a table about 1000K+ record When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Feature Request > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > The table definition: > {code} > {code} > When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. > But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Xian Liu (JIRA)

Xian Liu created TEIID-3796: ------------------------------- Summary: It is much more slow to get the table record through TEIID from postgresql DB Key: TEIID-3796 URL: https://issues.jboss.org/browse/TEIID-3796 Project: Teiid Issue Type: Feature Request Reporter: Xian Liu Assignee: Steven Hawkins There is a table about 1000K+ record When I make it available in Teiid, and set driver connection parameter to disableLocalTxn=true;FetchSize=10; It will quickly get the data stream. But when I make this in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+, the client can not get the data stream, what's reason, when I try to directly connect postgresql, it is much more faster. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3698) non-selectable columns will cause OData failures

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3698?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3698: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1262827|https://bugzilla.redhat.com/show_bug.cgi?id=1262827] from ON_QA to VERIFIED > non-selectable columns will cause OData failures > ------------------------------------------------ > > Key: TEIID-3698 > URL: https://issues.jboss.org/browse/TEIID-3698 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 8.12, 8.7.5 > > > An odata table/view with a non-selectable column will return an error if it is returned as an odata entity without the $select option to exclude the non-selectable column. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

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

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3671: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1259736|https://bugzilla.redhat.com/show_bug.cgi?id=1259736] from MODIFIED to VERIFIED > 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 > Assignee: Johnathon Lee > Priority: Critical > Fix For: 8.12, 8.11.4, 8.7.5 > > 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.4.11#64026)

8 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2015