[JBoss JIRA] (TEIID-4051) Swagger metadata includes internal java constructs
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-4051?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-4051.
-----------------------------------
Resolution: Out of Date
Bulk resolving older issues as out of date.
> Swagger metadata includes internal java constructs
> --------------------------------------------------
>
> Key: TEIID-4051
> URL: https://issues.redhat.com/browse/TEIID-4051
> Project: Teiid
> Issue Type: Quality Risk
> Components: Server
> Affects Versions: 8.12.x
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: Backlog
>
>
> From IntegrationTestRestWarGeneration the swagger metadata includes definitions for Statement, ResultSet, StreamingOutput, etc.:
> ...
> InputStream:
> type: "object"
> Statement:
> type: "object"
> properties:
> queryTimeout:
> type: "integer"
> format: "int32"
> closed:
> type: "boolean"
> default: false
> resultSet:
> $ref: "#/definitions/ResultSet"
> ...
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 7 months
[JBoss JIRA] (TEIID-3454) Dependent Join optimizations for Netezza and Hive
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-3454?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-3454.
-----------------------------------
Resolution: Out of Date
Bulk resolving older issues as out of date.
> Dependent Join optimizations for Netezza and Hive
> -------------------------------------------------
>
> Key: TEIID-3454
> URL: https://issues.redhat.com/browse/TEIID-3454
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 8.10
> Reporter: John Muller
> Priority: Major
> Fix For: Backlog
>
>
> Currently, dependent joins create 1 or more IN clauses. Many MPP / NoSQL systems can have drastically better performance by creating temp tables that match key distributions. Two examples I know of would be Netezza and Hive.
> In Netezza, if the incoming dependent join (small dimension; here "Customer" using Northwind data model concepts) has a key that will be joined to to a big fact table that is DISTRIBUTED ON or ORGANIZED BY 'ed then creating a temp table that matches this distribution will result in ~100x query performance. Sometimes, if the dimension is small enough, this doesn't make a big difference as Netezza will perform a broadcast join, but it's never a bad idea to create the temp table.
> Similarly, Hive DDL has both partitions and buckets (pre-sorted).
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 7 months
[JBoss JIRA] (TEIID-2703) Refactor value retrieval to class based
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-2703?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-2703.
-----------------------------------
Resolution: Out of Date
Bulk resolving older issues as out of date.
> Refactor value retrieval to class based
> ---------------------------------------
>
> Key: TEIID-2703
> URL: https://issues.redhat.com/browse/TEIID-2703
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: Backlog
>
>
> Similar to Hibernate, we need to introduce encapsulated value retrieval methods. The current approach (which is legacy back to the mmx days) typically uses a switch block with other checks, which can largely be avoided and should improve performance.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 7 months
[JBoss JIRA] (TEIID-4363) ParseHub - support for web documents
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-4363?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-4363.
-----------------------------------
Resolution: Out of Date
Bulk resolving older issues as out of date.
> ParseHub - support for web documents
> ------------------------------------
>
> Key: TEIID-4363
> URL: https://issues.redhat.com/browse/TEIID-4363
> Project: Teiid
> Issue Type: Feature Request
> Components: Misc. Connectors
> Reporter: Kim Palko
> Priority: Major
> Fix For: Backlog, Open To Community
>
>
> ParseHub is a new web browser extension that you can use to turn any dynamic and poorly structured website into an API, without writing code. ParseHub is a scraping tool that is designed to work on websites with JavaScript and Ajax; it is similar to web scraping tools such as Import.io and Kimono Labs.
> The ParseHub tool will identify relationships between elements, extract all of the data and provide it in a spreadsheet or easily accessible API for you. Both scrapers and data are cloud hosted. All you have to do is to download the ParseHub browser extension and start extracting the data you want. Watch this 60 second video of ParseHub.
> https://www.parsehub.com/
> http://scraping.pro/turn-any-interactive-website-into-api-with-parsehub/
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 7 months