[teiid-issues] [JBoss JIRA] (TEIID-2285) Enhance Loopback Translator to retrieve custom data

[Filip Elias (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12732490#comment-12732490 ] 

Filip Elias commented on TEIID-2285:
------------------------------------

I have discussed this with Pavel Macik (he will execute performance tests) and he prefers loopback translator with few changes. H2 database causes to much overhead. To have hard coded data is not a good solution too, because you would need them to be stored in memory, which would influence the test. (Pavel will perform tests on 100000 distinct rows.)

So Filip has modified loopback translator. He added two more properties to it:
IncrementRows - If it is enabled it will increment values in all columns. It works for all datatypes. Values in each row are predicable.
CharacterValuesSize - Defines length of string, varchar etc.

Also it is needed to disable some capabilites of loopback translator so that teiid engine can perform comparing, joining, filtering etc. of data generated by the translator.

We thing that these changes can be used in project. Please, look at the modified translator and if you like it we can create pull request. Thanks.

Here is the repository with modified loopback translator: https://github.com/nguyenfilip/teiid-1
branch: loopback-2285
                
> Enhance Loopback Translator to retrieve custom data
> ---------------------------------------------------
>
>                 Key: TEIID-2285
>                 URL: https://issues.jboss.org/browse/TEIID-2285
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>    Affects Versions: 8.2
>            Reporter: Filip Nguyen
>            Assignee: Filip Nguyen
>            Priority: Minor
>             Fix For: Open To Community
>
>
> Loopback Translator was identified as suitable way of testing Teiid engine performance. It would be nice if the Translator would mimic database behavior better in some aspects:
> * Possibility to define what data will be retrieved in the columns
> * Possibility of Unique data in column to mimic database generator

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira