September 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3329) Rationalize older spatial support with the new

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3329?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3329: --------------------------------------- Unfortunately there isn't a good way to do that. The blob has WKB format, so we would need to expose utility methods from the engine to convert to GeoJSON. > Rationalize older spatial support with the new > ---------------------------------------------- > > Key: TEIID-3329 > URL: https://issues.jboss.org/browse/TEIID-3329 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Reporter: Steven Hawkins > Fix For: 9.1 > > > MongoDB and Oracle had existing spatial support that should be updated to account for the new support if possible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3329) Rationalize older spatial support with the new

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3329?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3329: ------------------------------------- [~shawkins] I can change the Function signature in the MongoDB to accept the GeometryType, but what I am not understanding is how can I convert the blob inside it to the JSON? Is there a particular format these Blob contents under? > Rationalize older spatial support with the new > ---------------------------------------------- > > Key: TEIID-3329 > URL: https://issues.jboss.org/browse/TEIID-3329 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Reporter: Steven Hawkins > Fix For: 9.1 > > > MongoDB and Oracle had existing spatial support that should be updated to account for the new support if possible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4398) Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4398?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4398: -------------------------------- Fix Version/s: 9.2 > Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format > ----------------------------------------------------------------------------- > > Key: TEIID-4398 > URL: https://issues.jboss.org/browse/TEIID-4398 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.2 > > > Write a command line utility and provide in "bin" directory to convert the Designer based .vdb file with index metadata into -vdb.xml file and/or newer DDL format. > This can be used to migrate the older VDBs mach easier to newer formats without use of Designer tooling. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4213) Cassandra translator: enable pushdown of aggregate functions

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4213?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4213. --------------------------------- Fix Version/s: (was: Open To Community) Resolution: Done Added the needed capabilities methods. I did not add anything special to handle AVG being returning whole part. > Cassandra translator: enable pushdown of aggregate functions > ------------------------------------------------------------ > > Key: TEIID-4213 > URL: https://issues.jboss.org/browse/TEIID-4213 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Priority: Minor > Fix For: 9.1 > > > Cassandra supports basic aggregate functions: > MIN(),MAX(),SUM() and AVG() > Currently Teiid doesn't push such queries. > NOTE:In case of AVG() there is difference between the values returned from Teiid vs. Cassandra for an integer column. Cassandra returns only whole part of the number as integer, Teiid returns bigdecimal. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4444) Add a built-in delegating translator that allows overriding all supports

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4444?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4444. --------------------------------- Fix Version/s: (was: Open To Community) Resolution: Done Labels: CR1 (was: ) Per conversation the translator is implemented will be available under "delegator" name > Add a built-in delegating translator that allows overriding all supports > ------------------------------------------------------------------------ > > Key: TEIID-4444 > URL: https://issues.jboss.org/browse/TEIID-4444 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 9.1 > > > To assist in toggling specific capabilities without a patch, we should provide a built-in delegating translator that can selective toggle capabilities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4444) Add a built-in delegating translator that allows overriding all supports

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4444?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4444: ------------------------------------- Ok, Will be adding {code} @TranslatorProperty(display = "Add Supported Functions(CSV)", description = "Add comma separated names to system functions", advanced = true) public void addSupportedFunctions(String functionNames) { if (supportedFunctions == null) { supportedFunctions = new ArrayList<String>(); supportedFunctions.addAll(this.delegate.getSupportedFunctions()); } StringTokenizer st = new StringTokenizer(functionNames, ","); while(st.hasMoreTokens()) { supportedFunctions.add(st.nextToken().trim()); } } @TranslatorProperty(display = "Remove Supported Functions(CSV)", description = "Remove comma separated names from system functions", advanced = true) public void removeSupportedFunctions(String functionNames) { if (supportedFunctions == null) { supportedFunctions = new ArrayList<String>(); supportedFunctions.addAll(this.delegate.getSupportedFunctions()); } StringTokenizer st = new StringTokenizer(functionNames, ","); while(st.hasMoreTokens()) { supportedFunctions.remove(st.nextToken().trim()); } } {code} > Add a built-in delegating translator that allows overriding all supports > ------------------------------------------------------------------------ > > Key: TEIID-4444 > URL: https://issues.jboss.org/browse/TEIID-4444 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: Open To Community, 9.1 > > > To assist in toggling specific capabilities without a patch, we should provide a built-in delegating translator that can selective toggle capabilities. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4468) Google translator evaluates 0 as not NULL for operator <>

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4468?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4468: --------------------------------------- > If this is expected behavior, shouldn't it be in the documentation? It's not expected from Teiid's perspective. It looks like a bug / quality issue with google spreadsheets - the documentation states null comparisons should use is null / is not null, which implies null should not match equality or not equality. We'll have to workaround that from our side. And it affects all types from what I have seen. > Google translator evaluates 0 as not NULL for operator <> > ---------------------------------------------------------- > > Key: TEIID-4468 > URL: https://issues.jboss.org/browse/TEIID-4468 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Priority: Minor > > Query ""SELECT stringNum FROM bqt1.SmallA <> 0" returns also values NULL (empty cell in spreadsheet). > I.e., NULL is treated as different from 0. > If this is expected behavior, shouldn't it be in the documentation? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4468) Google translator evaluates 0 as not NULL for operator <>

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4468: -------------------------------------- Summary: Google translator evaluates 0 as not NULL for operator <> Key: TEIID-4468 URL: https://issues.jboss.org/browse/TEIID-4468 Project: Teiid Issue Type: Bug Affects Versions: 8.12 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Priority: Minor Query ""SELECT stringNum FROM bqt1.SmallA <> 0" returns also values NULL (empty cell in spreadsheet). I.e., NULL is treated as different from 0. If this is expected behavior, shouldn't it be in the documentation? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4467) Google translator throws exception invalid_query for GROUP BY

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4467?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4467: ---------------------------------------- Np, I see that query like "SELECT sum(IntNum) FROM bqt1.SmallA GROUP BY IntKey" works... > Google translator throws exception invalid_query for GROUP BY > -------------------------------------------------------------- > > Key: TEIID-4467 > URL: https://issues.jboss.org/browse/TEIID-4467 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheet-vdb.xml, server.log > > > Google translator produces following exception for a query: "SELECT IntKey FROM bqt1.SmallA GROUP BY IntKey": > 16:27:26,955 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30019 Unexpected exception for request vn+N1XY8Atf5.6: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: [invalid_query] > at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDataProtocolAPI.java:196) > ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4467) Google translator throws exception invalid_query for GROUP BY

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4467?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4467: --------------------------------------- [~lfabriko] Sorry I should have been more specific. Google expects a non-trivial aggregate value (one that is being computed against a column not in the grouping). > Google translator throws exception invalid_query for GROUP BY > -------------------------------------------------------------- > > Key: TEIID-4467 > URL: https://issues.jboss.org/browse/TEIID-4467 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheet-vdb.xml, server.log > > > Google translator produces following exception for a query: "SELECT IntKey FROM bqt1.SmallA GROUP BY IntKey": > 16:27:26,955 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30019 Unexpected exception for request vn+N1XY8Atf5.6: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: [invalid_query] > at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDataProtocolAPI.java:196) > ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2016