[JBoss JIRA] (TEIID-3146) Billing mechanism based on the query's complexity
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-3146?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-3146.
-----------------------------------
Resolution: Out of Date
Marking older issues as out of date.
> Billing mechanism based on the query's complexity
> -------------------------------------------------
>
> Key: TEIID-3146
> URL: https://issues.redhat.com/browse/TEIID-3146
> Project: Teiid
> Issue Type: Feature Request
> Reporter: João Viragine
> Priority: Minor
> Fix For: Open To Community
>
>
> It would be nice if we had a billing mechanism based on the query's complexity.
> Teeid exposes information about the queries issued, the amount of records returned, the time elapsed and the query plan.
> It could also expose the amount of data (in bytes) returned by each query.
> We could combine the above data plus the query complexity to create a score for a billing calculation.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 5 months
[JBoss JIRA] (TEIID-3746) Add ETL functionality to Teiid
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-3746?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-3746.
-----------------------------------
Resolution: Out of Date
Marking older issues as out of date.
> Add ETL functionality to Teiid
> ------------------------------
>
> Key: TEIID-3746
> URL: https://issues.redhat.com/browse/TEIID-3746
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Jerome Fenal
> Priority: Major
> Fix For: Open To Community
>
>
> Teeid can offer schema discovery, schema creation, data massaging from one format to another, and handle writes.
> ETL is all about that:
> - Extract
> - Tranform
> - Load
> in batch mode.
> With the dawn of batch mode in JEE7, it could be interesting to add ETL functionality, possibly in the form of a continuous datamover, or a batch datamover, which could also be used in a complete database migration scenario.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 5 months
[JBoss JIRA] (TEIID-5908) Issue with "timestamp with timezone" redshift data type
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-5908?page=com.atlassian.jira.plugi... ]
Steven Hawkins updated TEIID-5908:
----------------------------------
Fix Version/s: 16.0
(was: Backlog)
> Issue with "timestamp with timezone" redshift data type
> -------------------------------------------------------
>
> Key: TEIID-5908
> URL: https://issues.redhat.com/browse/TEIID-5908
> Project: Teiid
> Issue Type: Bug
> Reporter: Chandra Akkinepalli
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 16.0
>
>
> Our data source is redshift and we are using redshift translator in JDV.
> The source table has a couple of fields with data type "timestamp with timezone". This is field is mapped to Teiid source model with a data type timestamp. For some reason we are receiving following error when running a query on the table with this field in VDB.
> *"SQL Error [30504] [50000]: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 SRC_RS_HYDRA: 22003 Unexpected exception while translating results: [Amazon][JDBC](10140) Error converting value to Timestamp"*
> The fields which have source data type of "timestamp without timezone" mapped to teiid data type of timestamp work just fine.
> Please let me know if you have any questions.
> Thanks,
> Chandra
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 5 months
[JBoss JIRA] (TEIID-6012) Can we read csv file without using texttable and xmltable function
by Steven Hawkins (Jira)
[ https://issues.redhat.com/browse/TEIID-6012?page=com.atlassian.jira.plugi... ]
Steven Hawkins resolved TEIID-6012.
-----------------------------------
Resolution: Explained
You use something like TEXTTABLE or XMLTABLE to convey how to convert a given file into a tabular representation. Since this is a common function it was promoted to the engine rather than handled by a translator as csv / xml is obtained from a variety of sources. Once you have the sql create you expected output, you can create a view, and optionally materialize that, then access it as if it were any other table/view.
At this time there are no plans to add a TEXT translator. If you want further encapsulation of the text processing there are other drivers and projects that can be utilized and then accessed as a source.
> Can we read csv file without using texttable and xmltable function
> ------------------------------------------------------------------
>
> Key: TEIID-6012
> URL: https://issues.redhat.com/browse/TEIID-6012
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Nayan Bija
> Assignee: Steven Hawkins
> Priority: Major
>
>
> We need to read CSV file data from the GCP storage.
> so we are following steps mentioned in the ticket TEIID-5940
> It is mentioned in the third step, that you will have to use TEXTTABLE or XMLTABLE functions to consume CSV or XML.
>
> So I just have a question without using this function can we write a query. just like we write for other databases like MYSQL, SQLServer, BigQuery, etc
>
> Also, want to know whether Amazon S3 is a free or paid translator?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
5 years, 5 months