December 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4635) Mongo translator - NAMEINSOURCE option is ignored

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4635?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4635. --------------------------------- Resolution: Duplicate Issue yes, this is intentional choice from initial coding. Duplicate of TEIID-4217 > Mongo translator - NAMEINSOURCE option is ignored > ------------------------------------------------- > > Key: TEIID-4635 > URL: https://issues.jboss.org/browse/TEIID-4635 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Mongo translator ignores NAMEINSOURCE table/column option. > For table \[1\], no data is returned. For column \[2\], all values in column are NULL. > {code:sql|title=\[1\] Sample DDL - table} > CREATE FOREIGN TABLE MyNewName ( > id integer PRIMARY KEY, > name varchar(25) > ) OPTIONS(UPDATABLE 'TRUE', NAMEINSOURCE 'RealCollectionName'); > {code} > {code:sql|title=\[2\] Sample DDL - column} > CREATE FOREIGN TABLE MyCollection ( > id integer PRIMARY KEY, > myColName varchar(25) OPTIONS(NAMEINSOURCE 'realName') > ) OPTIONS(UPDATABLE 'TRUE'); > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4636) In the SWARM readme's, need to indicate the URL to connect

by Van Halbert (JIRA)

Van Halbert created TEIID-4636: ---------------------------------- Summary: In the SWARM readme's, need to indicate the URL to connect Key: TEIID-4636 URL: https://issues.jboss.org/browse/TEIID-4636 Project: Teiid Issue Type: Enhancement Components: Quick Starts Affects Versions: 9.2 Reporter: Van Halbert Assignee: Van Halbert Priority: Minor The quickstarts needs to include the information (i.e, URL, username, password, etc.) needed to connect to the swarm example. Per Kylin: By default 0.0.0.0 be bound as IP, 31000 as port. To bind a specific IP use system properties --- -Dswarm.bind.address=127.0.0.1 --- Some Fractions use a system properties to change the port number, but teiid not support it at moment. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4633) Odata $expand over Oracle tables generates bad query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4633?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4633: --------------------------------------- The logic is trying to fetch the values as an array/row value, but oracle does not directly allow that in the select clause. We'll need to refine the array type handling pushdown for oracle. > Odata $expand over Oracle tables generates bad query > ---------------------------------------------------- > > Key: TEIID-4633 > URL: https://issues.jboss.org/browse/TEIID-4633 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, OData > Affects Versions: 9.1.1 > Reporter: Sergio Samayoa > Assignee: Steven Hawkins > Priority: Critical > > Query generated to obtain referenced records ($expand many to one) is generated with parentheses, > Generated query for Oracle*: > SELECT g_0."CATEGORY_ID", (g_0."CATEGORY_ID", g_0."NAME", g_0."LAST_UPDATE") FROM "SAKILA"."CATEGORY" g_0 > Generated query for MySQL is: > SELECT g_0.category_id, g_0.name, g_0.last_update FROM Sakila.category AS g_0 > * Note the parentheses enclosing all columns but PK, this raises "ORA-00907: missing right parenthesis". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4634) TEIID30003 - wrong order of arguments

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4634?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4634. ----------------------------------- Fix Version/s: 9.2 Resolution: Done Thanks Juraj for catching this. > TEIID30003 - wrong order of arguments > ------------------------------------- > > Key: TEIID-4634 > URL: https://issues.jboss.org/browse/TEIID-4634 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.1 > Reporter: Juraj Duráni > Assignee: Juraj Duráni > Priority: Trivial > Fix For: 9.2 > > > TEIID30003 text: > {quote} > Without required support property \{0\}, pushdown will not be enabled for \{1\} on translator \{2\}. > {quote} > However, in code, it's called: > {code:java} > private static void setSupports(Object connectorID, BasicSourceCapabilities tgtCaps, Capability cap, boolean supports, Capability... required) { > ... > for (Capability capability : required) { > ... > LogManager.logWarning(LogConstants.CTX_CONNECTOR, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30003, cap, capability, connectorID)); > ... > } > ... > } > {code} > I.e. required capability is second ('1') attribute, not first ('0'). -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4634) TEIID30003 - wrong order of arguments

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4634?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4634: ---------------------------------- Component/s: Query Engine > TEIID30003 - wrong order of arguments > ------------------------------------- > > Key: TEIID-4634 > URL: https://issues.jboss.org/browse/TEIID-4634 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.1 > Reporter: Juraj Duráni > Assignee: Juraj Duráni > Priority: Trivial > > TEIID30003 text: > {quote} > Without required support property \{0\}, pushdown will not be enabled for \{1\} on translator \{2\}. > {quote} > However, in code, it's called: > {code:java} > private static void setSupports(Object connectorID, BasicSourceCapabilities tgtCaps, Capability cap, boolean supports, Capability... required) { > ... > for (Capability capability : required) { > ... > LogManager.logWarning(LogConstants.CTX_CONNECTOR, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30003, cap, capability, connectorID)); > ... > } > ... > } > {code} > I.e. required capability is second ('1') attribute, not first ('0'). -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4635) Mongo translator - NAMEINSOURCE option is ignored

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4635?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4635: --------------------------------------- [~rareddy] was this an intentional design choice? > Mongo translator - NAMEINSOURCE option is ignored > ------------------------------------------------- > > Key: TEIID-4635 > URL: https://issues.jboss.org/browse/TEIID-4635 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Mongo translator ignores NAMEINSOURCE table/column option. > For table \[1\], no data is returned. For column \[2\], all values in column are NULL. > {code:sql|title=\[1\] Sample DDL - table} > CREATE FOREIGN TABLE MyNewName ( > id integer PRIMARY KEY, > name varchar(25) > ) OPTIONS(UPDATABLE 'TRUE', NAMEINSOURCE 'RealCollectionName'); > {code} > {code:sql|title=\[2\] Sample DDL - column} > CREATE FOREIGN TABLE MyCollection ( > id integer PRIMARY KEY, > myColName varchar(25) OPTIONS(NAMEINSOURCE 'realName') > ) OPTIONS(UPDATABLE 'TRUE'); > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4635) Mongo translator - NAMEINSOURCE option is ignored

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4635: ----------------------------------- Summary: Mongo translator - NAMEINSOURCE option is ignored Key: TEIID-4635 URL: https://issues.jboss.org/browse/TEIID-4635 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.8.6_3 Reporter: Juraj Duráni Assignee: Steven Hawkins Mongo translator ignores NAMEINSOURCE table/column option. For table \[1\], no data is returned. For column \[2\], all values in column are NULL. {code:sql|title=\[1\] Sample DDL - table} CREATE FOREIGN TABLE MyNewName ( id integer PRIMARY KEY, name varchar(25) ) OPTIONS(UPDATABLE 'TRUE', NAMEINSOURCE 'RealCollectionName'); {code} {code:sql|title=\[2\] Sample DDL - column} CREATE FOREIGN TABLE MyCollection ( id integer PRIMARY KEY, myColName varchar(25) OPTIONS(NAMEINSOURCE 'realName') ) OPTIONS(UPDATABLE 'TRUE'); {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4634) TEIID30003 - wrong order of arguments

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4634: ----------------------------------- Summary: TEIID30003 - wrong order of arguments Key: TEIID-4634 URL: https://issues.jboss.org/browse/TEIID-4634 Project: Teiid Issue Type: Bug Affects Versions: 9.1 Reporter: Juraj Duráni Assignee: Juraj Duráni Priority: Trivial TEIID30003 text: {quote} Without required support property \{0\}, pushdown will not be enabled for \{1\} on translator \{2\}. {quote} However, in code, it's called: {code:java} private static void setSupports(Object connectorID, BasicSourceCapabilities tgtCaps, Capability cap, boolean supports, Capability... required) { ... for (Capability capability : required) { ... LogManager.logWarning(LogConstants.CTX_CONNECTOR, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30003, cap, capability, connectorID)); ... } ... } {code} I.e. required capability is second ('1') attribute, not first ('0'). -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4633) Odata $expand over Oracle tables generates bad query

by Sergio Samayoa (JIRA)

Sergio Samayoa created TEIID-4633: ------------------------------------- Summary: Odata $expand over Oracle tables generates bad query Key: TEIID-4633 URL: https://issues.jboss.org/browse/TEIID-4633 Project: Teiid Issue Type: Bug Components: JDBC Connector, OData Affects Versions: 9.1.1 Reporter: Sergio Samayoa Assignee: Steven Hawkins Priority: Critical Query generated to obtain referenced records ($expand many to one) is generated with parentheses, Generated query for Oracle*: SELECT g_0."CATEGORY_ID", (g_0."CATEGORY_ID", g_0."NAME", g_0."LAST_UPDATE") FROM "SAKILA"."CATEGORY" g_0 Generated query for MySQL is: SELECT g_0.category_id, g_0.name, g_0.last_update FROM Sakila.category AS g_0 * Note the parentheses enclosing all columns but PK, this raises "ORA-00907: missing right parenthesis". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4598) NPE when analytic Source function for Greenplum doesn't get pushdown

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4598?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4598. ----------------------------------- Resolution: Done Updating the logic to throw a better exception if a must pushdown function is not pushed. > NPE when analytic Source function for Greenplum doesn't get pushdown > -------------------------------------------------------------------- > > Key: TEIID-4598 > URL: https://issues.jboss.org/browse/TEIID-4598 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Anu Saji > Assignee: Steven Hawkins > Fix For: 9.2, 9.1.2 > > Attachments: jdv_error(1).txt > > > In customers exact words > when executing the following > ~~~ > USER COMMAND: > SELECT GPDBDEV.kr_cust_team_target.team, LAG(ALL convert(GPDBDEV.kr_cust_team_target.target_amount, string)) OVER (PARTITION BY GPDBDEV.kr_cust_team_target.team ORDER BY GPDBDEV.kr_cust_team_target."year", GPDBDEV.kr_cust_team_target."month") FROM GPDBDEV.kr_cust_team_target > ~~~ > Gives NPE > 11:59:38,611 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue3) TEIID30019 Unexpected exception for request BWIVpfi0IyEK.0: java.lang.NullPointerException > at org.teiid.query.function.FunctionDescriptor.newInstance(FunctionDescriptor.java:91) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.function.aggregate.UserDefined.<init>(UserDefined.java:44) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.GroupingNode.initAccumulator(GroupingNode.java:291) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.WindowFunctionProjectNode.initializeAccumulators(WindowFunctionProjectNode.java:414) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.WindowFunctionProjectNode.buildResults(WindowFunctionProjectNode.java:339) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.WindowFunctionProjectNode.nextBatchDirect(WindowFunctionProjectNode.java:232) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_91] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_91] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 1 month

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2016