[JBoss JIRA] (TEIID-3140) Add getVDBType() method to the VDB interface
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3140?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3140.
---------------------------------
> Add getVDBType() method to the VDB interface
> --------------------------------------------
>
> Key: TEIID-3140
> URL: https://issues.jboss.org/browse/TEIID-3140
> Project: Teiid
> Issue Type: Enhancement
> Components: AdminApi
> Reporter: Barry LaFond
> Assignee: Steven Hawkins
>
> Because Teiid supports mutliple VDB types, any tooling designed to interact (edit, deploy, undeploy, display etc...) with the runtime VDBs will need to be able to easilly distinguish what each VDB type is.
> Currently Teiid Designer utilizes PREVIEW and defeault VDBs with *vdb* file extensions and there are 2 types of dynamic VDBs, *xml* and *zip* files backed by DDL model metadata definitions.
> The current VDB interface currently doesn't provide a type.
> Request adding something like:
> {code}
> public enum VDBType {DEFAULT, PREVIEW, XML, DDL}
> /**
> * @return the vdb type
> */
> public VDBType getVDBType();
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3580:
---------------------------------------
There has been no movement on their community issue. If this issue still persists with later versions of Hive it looks like the only workaround that we could pursue is to always issue select * for simple queries and then filter the columns on our side.
> Hive 0.13.1 JDBC jars makes queries run slow
> --------------------------------------------
>
> Key: TEIID-3580
> URL: https://issues.jboss.org/browse/TEIID-3580
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7.3
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Attachments: threaddump-1437508266001.tdump
>
>
> When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return.
> The Hive JDBC jars for version 0.13.1 can be found here :
> https://github.com/vchintal/hive-jdbc-jars-archive
> Alternatively a ready-to-go modules can be downloaded from here for testing:
> https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/
> Use the following driver snippet when using the above mentioned module:
> <driver name="hive" module="org.apache.hadoop.hive:0.13.1">
> <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class>
> </driver>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3554) Audit log is missing details related to what role was applied and what info was allowed or denied
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3554?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3554.
---------------------------------
> Audit log is missing details related to what role was applied and what info was allowed or denied
> -------------------------------------------------------------------------------------------------
>
> Key: TEIID-3554
> URL: https://issues.jboss.org/browse/TEIID-3554
> Project: Teiid
> Issue Type: Quality Risk
> Components: Server
> Affects Versions: 8.7.1.6_2
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Attachments: portfolioroles_data.xlsx
>
>
> Using the dynamicvdb-dataroles quick start as the basis for triggering the audit log. Executing the view query: "Select * from StockPrice" . The query will only present the "price" column value when the user has the "prices" role. When performing queries with a user (name=teiidUser) that doesn't have the "prices" role versus one that does (name=portfolio), doesn't provide any discerning information in the audit log to indicate that a role was applied to the data.
> Attaching excel file of the audit log data.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3796.
---------------------------------
Closing do to lack of new updates.
> 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, 11 months