[JBoss JIRA] (TEIID-3361) Add source query details to the command log
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3361:
-------------------------------------
Summary: Add source query details to the command log
Key: TEIID-3361
URL: https://issues.jboss.org/browse/TEIID-3361
Project: Teiid
Issue Type: Enhancement
Components: Misc. Connectors
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.11
The command log for convenience only contains the Teiid sql form of the source query. It would be good to have the translators also add their actual form of the source query when possible to the command log just to have a single place to track things down.
Currently this info is logged to the CONNECTOR context inconsistently in each translator.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-3360) Provide an option to virtualize source exceptions
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3360:
-------------------------------------
Summary: Provide an option to virtualize source exceptions
Key: TEIID-3360
URL: https://issues.jboss.org/browse/TEIID-3360
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.11, Open To Community
Currently we'll pass the source exception along with the Teiid exception. And from source sql exceptions we'll also rely the sql state/code. When connecting to databases of different types it would be best to return a common set of codes.
There is exception mapping logic in Hibernate that we could reuse, but this could apply to the non-jdbc sources such that a predictable code will seen by Teiid clients.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-3359) Allow more control over odata layer caching
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3359:
-------------------------------------
Summary: Allow more control over odata layer caching
Key: TEIID-3359
URL: https://issues.jboss.org/browse/TEIID-3359
Project: Teiid
Issue Type: Enhancement
Components: OData
Affects Versions: 8.7
Reporter: Steven Hawkins
Fix For: 8.11
The caching is always performed at a user level and for each query. Consumers may need to localize the caching affect only to paging results and scope only to that interaction, rather than for all users.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-3358) Issues with entity set names
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3358:
-------------------------------------
Summary: Issues with entity set names
Key: TEIID-3358
URL: https://issues.jboss.org/browse/TEIID-3358
Project: Teiid
Issue Type: Bug
Components: OData
Affects Versions: 8.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.11
The entity set name used for sql generation should be the fully qualified name. If there is for example two table with the same names in schemas visible to odata, but one of the tables does not have a key, then an ambiguous name exception will be thrown if an odata url is used with only the base table name.
It also appears that the URI link in the results metadata uses the non-qualified table name, which will have issues in the scenario above.
We may also need to document or add an additional check for ambiguity as the OData4j findEdmEntitySet logic will return the first matching entity, which is generally against our approach to resolving.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-3357) Add the final processor plan to the command log
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3357:
-------------------------------------
Summary: Add the final processor plan to the command log
Key: TEIID-3357
URL: https://issues.jboss.org/browse/TEIID-3357
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Affects Versions: 8.11
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.11
We should add the plan output not just once planning has completed, but when processing has completed as well so that the node statistics have been populated.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-1741) Record level audit trail in teiid log files
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1741?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1741.
-----------------------------------
Assignee: Steven Hawkins
Fix Version/s: (was: Open To Community)
Resolution: Done
Added a sandbox translator as another demonstration of what can be done with the delegating translator.
https://github.com/teiid/teiid/blob/master/connectors/sandbox/translator-...
It is only an example. From the request here it looks like additional considerations are - not all results would need to be logged (only columns considered auditable - although that can be a somewhat problematic concept for a more complex pushdown query), what information to include from the execution context, etc.
> Record level audit trail in teiid log files
> -------------------------------------------
>
> Key: TEIID-1741
> URL: https://issues.jboss.org/browse/TEIID-1741
> Project: Teiid
> Issue Type: Feature Request
> Components: Connector API, Query Engine
> Reporter: Monika Ahuja
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> In order to track the audit trail for patient identified information access, we would like to track the executed queries, results as well as the timestamps for each user's query and its result. Essentially we need a report providing the list of Medical Record Numbers accessed by each user id and I think we can use the Logs to track that (unless you suggest a better way).
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-3355) Improve recommendations so that they translate to configuring server
by Thomas Hauser (JIRA)
[ https://issues.jboss.org/browse/TEIID-3355?page=com.atlassian.jira.plugin... ]
Thomas Hauser commented on TEIID-3355:
--------------------------------------
It would be great to have this information, since if we also have an API / recommend that the user use the tool first, the values can be tweaked during installation. This reduces post-install configuration and streamlines the experience, whether in a production setting or not.
> Improve recommendations so that they translate to configuring server
> --------------------------------------------------------------------
>
> Key: TEIID-3355
> URL: https://issues.jboss.org/browse/TEIID-3355
> Project: Teiid
> Issue Type: Enhancement
> Components: Sizing Application
> Reporter: Van Halbert
> Assignee: Kylin Soong
>
> Improve the answers so that any configuration recommendations are provided. This might include (not all encompassing):
> - teiid max threads
> - teiid max plans
> - data source connection max pool size
> ??
> The goal here being that this information can be directly translated for configuring the server that we're recommending.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-3356) Minor text issues with the sizing tool
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3356?page=com.atlassian.jira.plugin... ]
Van Halbert reassigned TEIID-3356:
----------------------------------
Assignee: Kylin Soong (was: Steven Hawkins)
> Minor text issues with the sizing tool
> --------------------------------------
>
> Key: TEIID-3356
> URL: https://issues.jboss.org/browse/TEIID-3356
> Project: Teiid
> Issue Type: Bug
> Components: Sizing Application
> Affects Versions: 8.9.1
> Reporter: Thomas Hauser
> Assignee: Kylin Soong
> Priority: Minor
>
> There are a few minor issues with some of the text in the tool.
> I'll enumerate them below:
> CPU Core Estimation:
> 2. What is the average row could from each physical source?
> The word "could" is probably meant to be "count". Whatever the solution, it's not meant to be "could" :D
> 2nd Paragraph of the "Red Hat Enterprise Linux is Recommended" section at the end, 2nd sentence:
> Red Hat Ente on other modern processor architectures.
> This is a sentence fragment and looks like a cut-off or something.
> I didn't see any others, sweet tool!
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years
[JBoss JIRA] (TEIID-3356) Minor text issues with the sizing tool
by Thomas Hauser (JIRA)
Thomas Hauser created TEIID-3356:
------------------------------------
Summary: Minor text issues with the sizing tool
Key: TEIID-3356
URL: https://issues.jboss.org/browse/TEIID-3356
Project: Teiid
Issue Type: Bug
Components: Sizing Application
Affects Versions: 8.9.1
Reporter: Thomas Hauser
Assignee: Steven Hawkins
Priority: Minor
There are a few minor issues with some of the text in the tool.
I'll enumerate them below:
CPU Core Estimation:
2. What is the average row could from each physical source?
The word "could" is probably meant to be "count". Whatever the solution, it's not meant to be "could" :D
2nd Paragraph of the "Red Hat Enterprise Linux is Recommended" section at the end, 2nd sentence:
Red Hat Ente on other modern processor architectures.
This is a sentence fragment and looks like a cut-off or something.
I didn't see any others, sweet tool!
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years