April 2017 - teiid-issues - Jboss List Archives

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

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4873?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4873: ------------------------------------ Couchbase client don't have mechanism to support Prepared Statements, so for batch insert, I just made support bulk updates with multiple values. we may add a notes in document for this, now upsert is supported. > 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)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4867) Loosen up OData4 URL validation or parsing

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4867?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4867: ------------------------------------- [~dsteigne] and [~jolee] upgrade the Olingo library version to "4.2.0-teiid-8" for the fix for JDV 6.3 > Loosen up OData4 URL validation or parsing > ------------------------------------------ > > Key: TEIID-4867 > URL: https://issues.jboss.org/browse/TEIID-4867 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.8.6_3 > Environment: JDV 6.3.2 > Windows 7 > Reporter: Steve Tran > Assignee: Steven Hawkins > > I'm accessing my JDV table via OData4 through Salesforce's UI builder. The salesforce engine itself is creating the OData calls, and whenever a $filter is needed with multiple columns, it looks like salesforce pads the column name with a space in front and behind. That'll make the URL look like ...$filter={color:red}%20{color}ColumnA{color:red}%20{color}eq%20123%20and{color:red}%20{color}ColumnB{color:red}%20{color}eq... > The first space right after the $filter= throws off the JDV engine as it thinks it's a malformed URL - which I guess it is. The thing is when I tested it via the OData2 interface, it accepted it just fine. I'm not sure if the OData4 specifications explicitly state in terms of the URL, so it could be anybody's bug. Perhaps we could make JDV a little more forgiving and trim the spaces after un-URL-encoding the URI. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

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

by Michael Echevarria (JIRA)

[ https://issues.jboss.org/browse/TEIID-4858?page=com.atlassian.jira.plugin... ] Michael Echevarria commented on TEIID-4858: ------------------------------------------- For reference the number of records this was tested against was 12435 > 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, override1.png, override2.png, 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)

8 years, 8 months

1
0
0 / 0

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

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4873?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4873: ------------------------------------- Yes, check for BatchUpdates. There is ExecutionFactory property and then command to support it. > 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)

8 years, 8 months

1
0
0 / 0

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

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4873?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4873: ------------------------------------ A question for teiid bulk insert, does teiid support bulk insert like {note} INSERT INTO keyspace (KEY, VALUE) VALUES ( "1", { "value": "one" } ), VALUES ( "2", { "value": "two" } ), …, VALUES ( "n", { "value": "n" } ); {note} > 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)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4869) Fix endpoint url for the "odata4service-as-a-datasource" in the embedded quickstart

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4869?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-4869. -------------------------------- Resolution: Done > Fix endpoint url for the "odata4service-as-a-datasource" in the embedded quickstart > ------------------------------------------------------------------------------------ > > Key: TEIID-4869 > URL: https://issues.jboss.org/browse/TEIID-4869 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 9.2 > Environment: Additional info. > - JBDS 9.1 > - translator-odata4-9.2.0.Alpha1.jar > Reporter: Anu Saji > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.3 > > > The example quickstart using Odata4 Service from emedded example => > https://github.com/teiid/teiid-embedded-examples/tree/master/odata4servic... > throws NPE [1] > It currently uses the endpoint url that is using version => > <edmx:Edmx Version="1.0"> > when the required is > <edmx:Edmx Version="4.0"> > src code > ~~~ > ... > managedconnectionFactory.setEndPoint("http://services.odata.org/Northwind/Northwind.svc"); > ... > ~~~ > [1] > ~~~ > NFO: TEIID40118 VDB NorthwindVDB.1 added to the repository > Exception in thread "main" java.lang.NullPointerException > at org.teiid.translator.odata4.ODataMetadataProcessor.getMetadata(ODataMetadataProcessor.java:118) > at org.teiid.translator.odata4.ODataMetadataProcessor.process(ODataMetadataProcessor.java:102) > at org.teiid.translator.odata4.ODataExecutionFactory.getMetadata(ODataExecutionFactory.java:112) > at org.teiid.translator.odata4.ODataExecutionFactory.getMetadata(ODataExecutionFactory.java:58) > at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) > at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) > at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:811) > at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:761) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:702) > at org.teiid.example.TeiidEmbeddedOData4ServiceDataSource.main(TeiidEmbeddedOData4ServiceDataSource.java:50) > ~~~ -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4869) Fix endpoint url for the "odata4service-as-a-datasource" in the embedded quickstart

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4869?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4869: ------------------------------------ [~asaji], PR 49(https://github.com/teiid/teiid-embedded-examples/pull/49) fixed the defects, refer to the latest code run your scenario. > Fix endpoint url for the "odata4service-as-a-datasource" in the embedded quickstart > ------------------------------------------------------------------------------------ > > Key: TEIID-4869 > URL: https://issues.jboss.org/browse/TEIID-4869 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 9.2 > Environment: Additional info. > - JBDS 9.1 > - translator-odata4-9.2.0.Alpha1.jar > Reporter: Anu Saji > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.3 > > > The example quickstart using Odata4 Service from emedded example => > https://github.com/teiid/teiid-embedded-examples/tree/master/odata4servic... > throws NPE [1] > It currently uses the endpoint url that is using version => > <edmx:Edmx Version="1.0"> > when the required is > <edmx:Edmx Version="4.0"> > src code > ~~~ > ... > managedconnectionFactory.setEndPoint("http://services.odata.org/Northwind/Northwind.svc"); > ... > ~~~ > [1] > ~~~ > NFO: TEIID40118 VDB NorthwindVDB.1 added to the repository > Exception in thread "main" java.lang.NullPointerException > at org.teiid.translator.odata4.ODataMetadataProcessor.getMetadata(ODataMetadataProcessor.java:118) > at org.teiid.translator.odata4.ODataMetadataProcessor.process(ODataMetadataProcessor.java:102) > at org.teiid.translator.odata4.ODataExecutionFactory.getMetadata(ODataExecutionFactory.java:112) > at org.teiid.translator.odata4.ODataExecutionFactory.getMetadata(ODataExecutionFactory.java:58) > at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) > at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) > at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:811) > at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:761) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:702) > at org.teiid.example.TeiidEmbeddedOData4ServiceDataSource.main(TeiidEmbeddedOData4ServiceDataSource.java:50) > ~~~ -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 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 resolved TEIID-2820. -------------------------------- Resolution: Done * Basic INSERT/UPDATE/DELETE/SELECT are supported * document and example be added? > 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: 9.3, 8.12.x > > > 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)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4862) Create documents/examples for couchbase connector

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4862?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-4862. -------------------------------- Resolution: Done > Create documents/examples for couchbase connector > ------------------------------------------------- > > Key: TEIID-4862 > URL: https://issues.jboss.org/browse/TEIID-4862 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Affects Versions: 9.3 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.3 > > > DO we need re-construct the document, that separate translator from reference, deploy data source from admin, and combine them together named as connector? Most of OLAP/virtulization product has the Connector concept, which same as teiid's translator + reource adapter/data source, like prestodb as [1] > [1] https://prestodb.io/docs/current/connector -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4869) Fix endpoint url for the "odata4service-as-a-datasource" in the embedded quickstart

by Anu Saji (JIRA)

[ https://issues.jboss.org/browse/TEIID-4869?page=com.atlassian.jira.plugin... ] Anu Saji commented on TEIID-4869: --------------------------------- To access "AddressInfo" from below site ,that which is a "complex type" , what should be the syntax like http://services.odata.org/TripPinRESTierService/(S(aayfdtyw1m3sewhrmqiklc... This below SELECT statement works SELECT FirstName , LastName , Emails FROM tripin.People where UserName='scottketchum'",true) but fails with different options/combination of AddressInfo , Location , City, Address Kindly advise > Fix endpoint url for the "odata4service-as-a-datasource" in the embedded quickstart > ------------------------------------------------------------------------------------ > > Key: TEIID-4869 > URL: https://issues.jboss.org/browse/TEIID-4869 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 9.2 > Environment: Additional info. > - JBDS 9.1 > - translator-odata4-9.2.0.Alpha1.jar > Reporter: Anu Saji > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.3 > > > The example quickstart using Odata4 Service from emedded example => > https://github.com/teiid/teiid-embedded-examples/tree/master/odata4servic... > throws NPE [1] > It currently uses the endpoint url that is using version => > <edmx:Edmx Version="1.0"> > when the required is > <edmx:Edmx Version="4.0"> > src code > ~~~ > ... > managedconnectionFactory.setEndPoint("http://services.odata.org/Northwind/Northwind.svc"); > ... > ~~~ > [1] > ~~~ > NFO: TEIID40118 VDB NorthwindVDB.1 added to the repository > Exception in thread "main" java.lang.NullPointerException > at org.teiid.translator.odata4.ODataMetadataProcessor.getMetadata(ODataMetadataProcessor.java:118) > at org.teiid.translator.odata4.ODataMetadataProcessor.process(ODataMetadataProcessor.java:102) > at org.teiid.translator.odata4.ODataExecutionFactory.getMetadata(ODataExecutionFactory.java:112) > at org.teiid.translator.odata4.ODataExecutionFactory.getMetadata(ODataExecutionFactory.java:58) > at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96) > at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) > at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:811) > at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:761) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:702) > at org.teiid.example.TeiidEmbeddedOData4ServiceDataSource.main(TeiidEmbeddedOData4ServiceDataSource.java:50) > ~~~ -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2017