October 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4932) Support defining UDFs based upon a class and or function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4932?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4932. ----------------------------------- Resolution: Done Added a UDF repository type and documented the use with xml and ddl metadata. In general it's more convienent via ddl as there could be multiple import options that make more sense by associating with the import statement. > Support defining UDFs based upon a class and or function > -------------------------------------------------------- > > Key: TEIID-4932 > URL: https://issues.jboss.org/browse/TEIID-4932 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.2 > > > With the new ddl support, we should allow an import to work against a class to define UDFs. > We should also in general support inferring arguments for UDFs and UDFs that are defined by a method. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5425) Concurrency/timing issues observed with travis builds

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5425?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5425: --------------------------------------- #1, 2, 4 - are still issues. 1. Not easily reproduced. Implies we are not sufficiently locking/synchronizing in the odbc logic. 2. It's apparently possible for the loadcount to restart at 1. I haven't see seen why this is possible. 4. Seems to be more related to networking issues in the travis environment rather than a code problem. > Concurrency/timing issues observed with travis builds > ----------------------------------------------------- > > Key: TEIID-5425 > URL: https://issues.jboss.org/browse/TEIID-5425 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Several unit tests have been observed to fail during travis builds occasionally: > 1. TestODBCSocketTransport.testRegClass:757 Â» PSQL ResultSet not positioned prope... > 2. TestExternalMatViews.testLazyUpdate:930 expected:<2> but was:<1> (see https://api.travis-ci.org/v3/job/405801976/log.txt) > 3. [ERROR] TestLocalConnections.testWaitForLoadTimeout:475 > 4. From https://api.travis-ci.org/v3/job/415138409/log.txt > [ERROR] testReplication(org.teiid.systemmodel.TestReplication) Time elapsed: 35.21 s <<< FAILURE! > java.lang.AssertionError: expected:<0.9164140964242746> but was:<0.18750528722359294> > at org.teiid.systemmodel.TestReplication.testReplication(TestReplication.java:122) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5481) Evaluate JSONPATH as expression language for Json payload to table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5481: ---------------------------------- Fix Version/s: 11.x > Evaluate JSONPATH as expression language for Json payload to table > ------------------------------------------------------------------ > > Key: TEIID-5481 > URL: https://issues.jboss.org/browse/TEIID-5481 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 11.x > > > Currently in Teiid in order to turn a JSON document to a relational structure, JSONTOXML function is used then XPATH used on it to retrieve data using XMLTABLE. > Investigate the feasibility of using JSONPATH [1] directly on JSON document to build a JSONTABLE construct. > [1] https://code.google.com/archive/p/json-path/ -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5478) Add engine support for nth_value

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5478?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5478. ----------------------------------- Resolution: Done Updated the logic to pass in the frame information to the aggregate computation to get the value. This could be generalized to the others, such as lead/lag. > Add engine support for nth_value > -------------------------------- > > Key: TEIID-5478 > URL: https://issues.jboss.org/browse/TEIID-5478 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.2 > > > Due to TEIID-5475 engine support for nth_value was removed. It should be added back with frame clause support. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5485) JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments fails

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-5485?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-5485: --------------------------------- Fix Version/s: 8.12.16.6_4 > JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments fails > -------------------------------------------------------------------------------------------------------------- > > Key: TEIID-5485 > URL: https://issues.jboss.org/browse/TEIID-5485 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 11.1 > Environment: teiid-11.1.0 (from 01.09.2018) on WildFly Full 11.0.0.Final (WildFly Core 3.0.8.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 11.2, 11.0.3, 10.3.5, 8.12.16.6_4, 11.1.2 > > > JOIN of a table and sub-query containing DISTINCT and table function of a procedural call with arguments, like: > {code:sql} > SELECT t2.i > FROM ( > SELECT DISTINCT 1 a, b from test_tables_pg.test_x) t1, > table(CALL "views.pr"(arg => t1.a) > ) sub > JOIN test_tables_pg.test_y t2 ON true ;; > {code} > fails with the following stack trace: > {code:noformat} > 2018-09-25 17:47:15,024 ERROR [org.teiid.TRANSPORT] (NIO1) TEIID40113 Unhandled exception, aborting operation: org.teiid.transport.ObjectEncoder$FailedWriteException: org.teiid.core > .TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.Boolean". Please ensure that the column's modeled datatype matc > hes the expected data. > at org.teiid.transport.ObjectEncoder.write(ObjectEncoder.java:132) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite0(AbstractChannelHandlerContext.java:738) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:730) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:816) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:723) > at io.netty.channel.ChannelDuplexHandler.write(ChannelDuplexHandler.java:106) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite0(AbstractChannelHandlerContext.java:738) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:730) > at io.netty.channel.AbstractChannelHandlerContext.access$1900(AbstractChannelHandlerContext.java:38) > at io.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.write(AbstractChannelHandlerContext.java:1089) > at io.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.run(AbstractChannelHandlerContext.java:1078) > at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:163) > at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:403) > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:442) > at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.Boolean". Please ensure that the colum > n's modeled datatype matches the expected data. > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:874) > at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:315) > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459) > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430) > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178) > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348) > at org.teiid.net.socket.Message.writeExternal(Message.java:57) > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1459) > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1430) > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1178) > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:348) > at org.teiid.transport.ObjectEncoder.write(ObjectEncoder.java:112) > ... 15 more > Caused by: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.lang.Integer > at org.teiid.client.BatchSerializer$IntColumnSerializer.writeObject(BatchSerializer.java:559) > at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:530) > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:863) > ... 26 more > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5444) Upgrade to Olingo-4.5

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-5444?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-5444: --------------------------------- Fix Version/s: 8.12.16.6_4 > Upgrade to Olingo-4.5 > --------------------- > > Key: TEIID-5444 > URL: https://issues.jboss.org/browse/TEIID-5444 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 11.1, 8.12.16.6_4 > > > Upgrade the olingo library to latest 4.5 version -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5478) Add engine support for nth_value

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5478?page=com.atlassian.jira.plugin... ] Work on TEIID-5478 started by Steven Hawkins. --------------------------------------------- > Add engine support for nth_value > -------------------------------- > > Key: TEIID-5478 > URL: https://issues.jboss.org/browse/TEIID-5478 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.2 > > > Due to TEIID-5475 engine support for nth_value was removed. It should be added back with frame clause support. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 6 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 October 2018