April 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4854: ---------------------------------------- If timestamp value is reformatted, query 'SELECT TimestampValue from SmallA' produces two different results depending on sheet content: 1. If there is no other row (only header and this one), exception is thrown 'Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp' 2. if there is present some other row with correctly formatted timestamp value, null is return for reformatted TimeStampValue > Google translator fails to update timestamp value reformatted after update > -------------------------------------------------------------------------- > > Key: TEIID-4854 > URL: https://issues.jboss.org/browse/TEIID-4854 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.3 > > Attachments: gs-reformatted-timestamp.log > > > Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp". > Google spreadsheet locale was UK, timezone was set to Berlin. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4871) Google translator missing support for transaction rollback

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4871?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4871. ----------------------------------- Resolution: Rejected > Google translator missing support for transaction rollback > ---------------------------------------------------------- > > Key: TEIID-4871 > URL: https://issues.jboss.org/browse/TEIID-4871 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > Rollback of transaction (or transactions at all?) seem to be not supported, I tried to set for google resource adapter: > <transaction-support>LocalTransaction</transaction-support> > but still sequence of queries like the one described in steps to reproduce doesn't reflect the rollback. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2820) Support Couchbase as a resource

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-2820?page=com.atlassian.jira.plugin... ] Kylin Soong edited comment on TEIID-2820 at 4/20/17 10:37 PM: -------------------------------------------------------------- > what you think of the changes and how you want to resolve the failing test cases. I have found the failure test all against array table's nested object attribute, but I am NOT consider nested object attribute as a update target, the current update need all demision IDX and documentID, all DX will find the posion of item in array, all attributes in set section will be formed as a JSON object, be used to repleace the current position value. > Also should there be an issue logged to support upsert? Yes, upsert should be supported, also the batch insert, I have created TEIID-4873. was (Author: kylin): Yes, upsert should be supported, also the batch insert, I would create a JIRA. > Support Couchbase as a resource > ------------------------------- > > Key: TEIID-2820 > URL: https://issues.jboss.org/browse/TEIID-2820 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Kim Palko > Assignee: Kylin Soong > Priority: Blocker > Labels: data_source > Fix For: 8.12.x, 9.3 > > > Support Couchbase as a data source in Teiid. This requires resource adapter and translater development -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4873) couchbase translator should support upsert and batch insert

by Kylin Soong (JIRA)

Kylin Soong created TEIID-4873: ---------------------------------- Summary: couchbase translator should support upsert and batch insert Key: TEIID-4873 URL: https://issues.jboss.org/browse/TEIID-4873 Project: Teiid Issue Type: Task Components: Misc. Connectors Affects Versions: 9.3 Reporter: Kylin Soong Assignee: Kylin Soong Fix For: 9.3 * As [1], "Inserting Values Using Prepared Statements" and "Performing Bulk Inserts" hints batch update are support * [2] is for upsert [1] https://developer.couchbase.com/documentation/server/4.5/n1ql/n1ql-langua... [2] https://developer.couchbase.com/documentation/server/4.5/n1ql/n1ql-langua... -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2820) Support Couchbase as a resource

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-2820?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-2820: ------------------------------------ Yes, upsert should be supported, also the batch insert, I would create a JIRA. > Support Couchbase as a resource > ------------------------------- > > Key: TEIID-2820 > URL: https://issues.jboss.org/browse/TEIID-2820 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Kim Palko > Assignee: Kylin Soong > Priority: Blocker > Labels: data_source > Fix For: 8.12.x, 9.3 > > > Support Couchbase as a data source in Teiid. This requires resource adapter and translater development -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4840) Create JDG Packaging of the translator, resource-adatper and scripts.

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4840?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4840: ------------------------------------ Since this is the same feature, I just assumed it should remain on the same version course so that there's no confusion between 8.x and 9.x. > Create JDG Packaging of the translator, resource-adatper and scripts. > --------------------------------------------------------------------- > > Key: TEIID-4840 > URL: https://issues.jboss.org/browse/TEIID-4840 > Project: Teiid > Issue Type: Task > Components: JDG Connector > Affects Versions: 9.3 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > > With the move of the infininspan code into its own JDG repo, it now needs to have its own ability to build a package that can be deployed. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4858) hive translator is extremely slow

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4858?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4858: --------------------------------------- Sorry for the delay in following up. Yes the source sql is in there - the difference it that the slow log has an "order by" clause. There does appear to be references to the order by operation not being well optimized on hive, so the simple solution would be to disable order by support on the hive translator with an override: {code} <translator name="hive-restricted" type="hive" /> <property name="supportsOrderBy" value="false"/> </translator> {code} And then reference the hive-restricted as the translator for your source. It would be good to know if there are some other considerations in play here as I wouldn't expect such a difference in performance. Do you see all sorts performing poorly, or perhaps is it related to the data type, or some other factor? > hive translator is extremely slow > --------------------------------- > > Key: TEIID-4858 > URL: https://issues.jboss.org/browse/TEIID-4858 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.9.6_3 > Environment: Tested against JDV 6.3.4 and the Cloudera quickstart 5.8 VM with the Cloudera sample data loaded into hive > Reporter: Michael Echevarria > Assignee: Steven Hawkins > Attachments: fast.log, slow.log > > > When querying a table through the hive translator the results take close to 30 seconds to return. > When querying a table through jdbc default results take under 1 second to return. > Both use the same underlying jboss server datasource. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2820) Support Couchbase as a resource

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2820?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2820: --------------------------------------- Also should there be an issue logged to support upsert? > Support Couchbase as a resource > ------------------------------- > > Key: TEIID-2820 > URL: https://issues.jboss.org/browse/TEIID-2820 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Kim Palko > Assignee: Kylin Soong > Priority: Blocker > Labels: data_source > Fix For: 8.12.x, 9.3 > > > Support Couchbase as a data source in Teiid. This requires resource adapter and translater development -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4863) Add a swarm fraction to run teiid embedded

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4863?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4863: ---------------------------------- Fix Version/s: 10.x > Add a swarm fraction to run teiid embedded > ------------------------------------------ > > Key: TEIID-4863 > URL: https://issues.jboss.org/browse/TEIID-4863 > Project: Teiid > Issue Type: Feature Request > Components: Embedded > Affects Versions: 10.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 10.x > > > WildFly Swarm can use simple pojo to integrate framework, which compatible with EmbeddedConfiguration, actually this is encouraged way. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin... ] Lucie Fabrikova edited comment on TEIID-4854 at 4/20/17 3:58 PM: ----------------------------------------------------------------- My spreadsheet had locale set to Unigted Kingdom and timezone set to Berlin, with timezone set also to United Kingdom, formatting was left correctly and no issue appeared. EDIT: there seems to be some undeterminism, I observed the bug even with timezone set e.g. to London. was (Author: lfabriko): My spreadsheet had locale set to Unigted Kingdom and timezone set to Berlin, with timezone set also to United Kingdom, formatting was left correctly and no issue appeared. > Google translator fails to update timestamp value reformatted after update > -------------------------------------------------------------------------- > > Key: TEIID-4854 > URL: https://issues.jboss.org/browse/TEIID-4854 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.3 > > Attachments: gs-reformatted-timestamp.log > > > Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp". > Google spreadsheet locale was UK, timezone was set to Berlin. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2017