April 2017 - teiid-issues - Jboss List Archives

[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: ------------------------------------------- Looking at the execution plan it shows that it is selecting explicit columns, not a select *. When executing the VDB, selecting * against both sources and selecting individual columns against both sources is very quick. The delay comes when deploying the VDB and accessing remotely > 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 > > 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4575) No such accessible property/method in the class after deploy vdb

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4575?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4575: ---------------------------------- Fix Version/s: (was: 9.2.2) > No such accessible property/method in the class after deploy vdb > ---------------------------------------------------------------- > > Key: TEIID-4575 > URL: https://issues.jboss.org/browse/TEIID-4575 > Project: Teiid > Issue Type: Bug > Components: Documentation, JDG Connector > Affects Versions: 9.2 > Reporter: Matej Kralik > Assignee: Van Halbert > Fix For: 9.3 > > Attachments: JDGproject.zip > > > When I want to deploy dynamic VDB with JDG materialization, the server shows me : TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book. > I looked at Book.java and ISBN is there. > The class is generated in the teiid designer. In the attachment is the project with dynamicVDB and generated JDG module. > Stacktrace: > {code:java} > 12:34:07,140 WARN [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue223) Connector worker process failed for atomic-request=e3xcwoJghvNm.0.69.131: org.teiid.translator.TranslatorException: TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book. > at org.teiid.translator.object.ObjectUpdateExecution.evaluate(ObjectUpdateExecution.java:524) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.translator.object.ObjectUpdateExecution.handleInsert(ObjectUpdateExecution.java:219) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.translator.object.ObjectUpdateExecution.executeUpdate(ObjectUpdateExecution.java:150) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.translator.object.ObjectUpdateExecution.execute(ObjectUpdateExecution.java:108) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source) [:1.8.0_91] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91] > at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at com.sun.proxy.$Proxy46.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:142) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.ProjectIntoNode.checkExitConditions(ProjectIntoNode.java:264) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.ProjectIntoNode.nextBatchDirect(ProjectIntoNode.java:164) [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.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:608) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.proc.ExecDynamicSqlInstruction$1.process(ExecDynamicSqlInstruction.java:218) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:389) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:298) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:270) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [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] > Caused by: javax.script.ScriptException: TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book. > at org.teiid.query.eval.TeiidScriptEngine$1.eval(TeiidScriptEngine.java:132) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.translator.object.ObjectUpdateExecution.evaluate(ObjectUpdateExecution.java:521) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8] > ... 47 more > 12:34:07,146 WARN [org.teiid.MATVIEWS] (Worker0_QueryProcessorQueue225) org.teiid.jdbc.TeiidSQLException: TEIID30504 BookCacheSource: TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book. > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 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: --------------------------------------- More than likely this is the same scenario as TEIID-3580 Are you issuing a select \* query directly to hive? If so see https://issues.apache.org/jira/browse/HIVE-11454 > 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 > > 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4852) Wrong OData results with multiple self relationships

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4852?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4852: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Wrong OData results with multiple self relationships > ---------------------------------------------------- > > Key: TEIID-4852 > URL: https://issues.jboss.org/browse/TEIID-4852 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.3, 8.12.x-6.4, 9.1.5, 9.2.2 > > > If an entity has multiple self relationships, only the first foreign key will be used no matter which navigation is queried. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

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

by Michael Echevarria (JIRA)

Michael Echevarria created TEIID-4858: ----------------------------------------- Summary: 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 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, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4754) Wrong result with bidirectional relationship

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4754?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4754: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Wrong result with bidirectional relationship > -------------------------------------------- > > Key: TEIID-4754 > URL: https://issues.jboss.org/browse/TEIID-4754 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2, 9.1.4, 8.12.x-6.4 > > > From the forum post, two tables that relate to each other: > EmployeeMasterEntity (PK EmployeeID, FK Departments) > OrganizationalUnitEntity (PK OrganizationalUnitID, FK Managers) > With data like: > EmployeeMasterEntity > EmployeeID Department > 1 10000001 > 2 10000002 > 3 10000001 > > OrganizationalUnitEntity > OrganizationaUnitID UnitManager > 10000001 1 > 10000002 2 > 10000003 2 > Will not return the correct results for a query such as: > http://localhost:8080/odata4/TestOdata.1/InterlemView/EmployeeMasterEntit... > This is due to using the wrong relationship for the navigation. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4853) Google translator does not allow update of empty String type cell

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4853?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4853. ----------------------------------- Resolution: Rejected See https://teiid.gitbooks.io/documents/content/reference/Google_Spreadsheet_... google does not allow us to properly differentiate between empty and null values in all circumstances, so the logic will throw an exception in ambiguous situations. > Google translator does not allow update of empty String type cell > ------------------------------------------------------------------ > > Key: TEIID-4853 > URL: https://issues.jboss.org/browse/TEIID-4853 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: gs-update-empty-cell.log > > > Google translator allows to be inserted null value into column of type String, but subsequent update of any cell in such row throws exception "Spreadsheet translator error: String values cannot be set to null". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4849) Google translator behaves unexpectedly with Double in WHERE clause of SELECT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4849?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-4849: ------------------------------------- Component/s: Misc. Connectors Fix Version/s: 10.0 Assignee: (was: Steven Hawkins) > Google translator behaves unexpectedly with Double in WHERE clause of SELECT > ---------------------------------------------------------------------------- > > Key: TEIID-4849 > URL: https://issues.jboss.org/browse/TEIID-4849 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.10.6_3 > Reporter: Lucie Fabrikova > Priority: Minor > Fix For: 10.0 > > > Query like "SELECT DoubleNum FROM SmallA WHERE DoubleNum > 5.0" gives unexpected results for following values in DoubleNum column: > * value like '15.1' is probably by google spreadsheet interpreted as date (in function row in sheet appears 15.1.2017), SELECT query returns no results > * value like '150.1': SELECT returns null -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3059) Support consuming SOAP based service that is secured by Kerberos authentication

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3059?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3059: ------------------------------------------------ Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1155299|https://bugzilla.redhat.com/show_bug.cgi?id=1155299] from ON_QA to CLOSED > Support consuming SOAP based service that is secured by Kerberos authentication > ------------------------------------------------------------------------------- > > Key: TEIID-3059 > URL: https://issues.jboss.org/browse/TEIID-3059 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: CR2, ER4 > Fix For: 8.7.1, 8.9 > > > CXF supports Kerberos based authentication in issuing a SOAP based web service call. This needs to be verified authentication scenario and further enhance code to support delegation of kerberos token. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4855) Google translator behaves unexpectedly for multi value INSERT with null

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4855?page=com.atlassian.jira.plugin... ] Lucie Fabrikova updated TEIID-4855: ----------------------------------- Affects Version/s: (was: 9.3) > Google translator behaves unexpectedly for multi value INSERT with null > ----------------------------------------------------------------------- > > Key: TEIID-4855 > URL: https://issues.jboss.org/browse/TEIID-4855 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > > Following query with multivalue insert generates unexpected results: > * INSERT INTO SmallA (Intkey, IntNum) VALUES (1,null),(2,20) > - row 1: Intkey = 1, Intnum and other columns are empty > - row 2: Intkey = 2, Intnum and other columns (StringNum, BooleanValue,...) have value set to 20 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2017