September 2016 - teiid-issues - Jboss List Archives

[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: ---------------------------------------- I added the SUM function: SELECT sum(IntKey) FROM bqt1.SmallA GROUP BY IntKey , but it still throws invalid_query. > 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)

7 years, 9 months

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: --------------------------------------- This is a google (undocumented) limitation - the query is required to have an aggregate if group by is used. Unfortunately there isn't a simple workaround for this at the translator level. It would take a new capability to prevent the pushdown. There is also a (documented) limitation that aggregates can only reference a column and not an arbitrary expression - that will also need a new capability. > 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)

7 years, 9 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4444?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4444: --------------------------------------- There are two types of supported functions - system functions as denoted by the getSupportedFunctions list, and pushdown functions declared by the translator / metadata. I'm talking specifically about the system functions getSupportedFunctions list - it would be good to have a simpler way to add/remove a function from the list rather than re-declaring the entire list. > 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)

7 years, 9 months

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 reassigned TEIID-4444: ----------------------------------- Assignee: Ramesh Reddy > 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)

7 years, 9 months

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: ------------------------------------- About your comment about adding/removing the functions, IMO this should typically apply to "pushdown" functions, but their definitions are complex as they are defined by FunctionMethod classes, to be injected through the translator-override mechanism, unless we come up with some integration with DSL/DDL there, this seems not feasible. thoughts? > 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 > 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)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-4284: --------------------------------- Awesome. Thanks for the fix [~shawkins]. This can help alot. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

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

by Lucie Fabrikova (JIRA)

Lucie Fabrikova created TEIID-4467: -------------------------------------- Summary: 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)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4466) Inconsistent synchronization around odbc sync handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4466?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4466. ----------------------------------- Resolution: Done Switched to just a volatile variable. > Inconsistent synchronization around odbc sync handling > ------------------------------------------------------ > > Key: TEIID-4466 > URL: https://issues.jboss.org/browse/TEIID-4466 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0 > > > There is a narrow race condition when an odbc message is followed by sync - the isExecuting check is supposed to prevent the sync until the execution is complete, but is not synchronized. > The result can be an exception in the pg client: > java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 > at java.util.ArrayList.rangeCheck(ArrayList.java:653) > at java.util.ArrayList.get(ArrayList.java:429) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1825) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) > As the pendingExecuteQueue will have been cleared by the early response to sync. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4466) Inconsistent synchronization around odbc sync handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4466?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4466: ---------------------------------- Fix Version/s: 9.0.5 (was: 9.0) > Inconsistent synchronization around odbc sync handling > ------------------------------------------------------ > > Key: TEIID-4466 > URL: https://issues.jboss.org/browse/TEIID-4466 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > There is a narrow race condition when an odbc message is followed by sync - the isExecuting check is supposed to prevent the sync until the execution is complete, but is not synchronized. > The result can be an exception in the pg client: > java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 > at java.util.ArrayList.rangeCheck(ArrayList.java:653) > at java.util.ArrayList.get(ArrayList.java:429) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1825) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) > As the pendingExecuteQueue will have been cleared by the early response to sync. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4466) Inconsistent synchronization around odbc sync handling

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4466: ------------------------------------- Summary: Inconsistent synchronization around odbc sync handling Key: TEIID-4466 URL: https://issues.jboss.org/browse/TEIID-4466 Project: Teiid Issue Type: Bug Components: ODBC Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1, 9.0 There is a narrow race condition when an odbc message is followed by sync - the isExecuting check is supposed to prevent the sync until the execution is complete, but is not synchronized. The result can be an exception in the pg client: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck(ArrayList.java:653) at java.util.ArrayList.get(ArrayList.java:429) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1825) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) As the pendingExecuteQueue will have been cleared by the early response to sync. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2016