December 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3270) Allow UDFs to call Teiid functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3270?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3270: ---------------------------------- Fix Version/s: 8.10 Tentatively scheduling for 8.10. Either through a metadata extension or by allowing the function metadata to have a body we can allow a function to be defined by a parameterized expression. > Allow UDFs to call Teiid functions > ---------------------------------- > > Key: TEIID-3270 > URL: https://issues.jboss.org/browse/TEIID-3270 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Sanjeev Gour > Assignee: Steven Hawkins > Fix For: 8.10 > > > Currently custom functions require the implementation on be in Java, there could be an alternative way to allow using Teiid expressions inside the custom functions. The related thread is here- > https://developer.jboss.org/thread/251179 -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3269) Oracle pushdown time formatting incorrect

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3269?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3269. ----------------------------------- Resolution: Done Marking as resolved. The pushdown will now be more restrictive. > Oracle pushdown time formatting incorrect > ----------------------------------------- > > Key: TEIID-3269 > URL: https://issues.jboss.org/browse/TEIID-3269 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.7.1, 8.10, 8.9.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.10, 8.9.1 > > > Oracle formatting cannot control the number of digits displayed in the same way as Java formatting, needs to AM instead of PM, and needs better handling for ERA. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3273) Exception while using biginteger column with SUM function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3273?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3273. ----------------------------------- Fix Version/s: 8.7.1 8.10 Resolution: Done Corrected setting the accumulator type. > Exception while using biginteger column with SUM function > --------------------------------------------------------- > > Key: TEIID-3273 > URL: https://issues.jboss.org/browse/TEIID-3273 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Environment: Teiid 8.7 and Windows > Reporter: Rakesh Balguri > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.10 > > > I have column which is of "BigInteger" type and when I am trying to execute an SQL which contains the SUM function I am getting the following exception. > The following is the SQL: > > SELECT SUM(age) FROM test > > My understanding is that the sum of all the BigInteger's is not fitting in the size of the BigInteger and Teiid is trying to convert it into a BigDecimal and end up in an exception. > How to fix this problem? Do we have a woraround for this? > > Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype biginteger for column 0 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data. > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:851) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] > at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:317) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1443) [rt.jar:1.7.0_03] > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1414) [rt.jar:1.7.0_03] > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1174) [rt.jar:1.7.0_03] > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:346) [rt.jar:1.7.0_03] > at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] > at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1443) [rt.jar:1.7.0_03] > at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1414) [rt.jar:1.7.0_03] > at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1174) [rt.jar:1.7.0_03] > at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:346) [rt.jar:1.7.0_03] > at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] > ... 25 more > Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.math.BigInteger > at org.teiid.client.BatchSerializer$BigIntegerColumnSerializer.writeObject(BatchSerializer.java:681) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] > at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:506) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] > at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:840) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] > ... 36 more > See the discussion in Teiid Forums for more information: https://developer.jboss.org/thread/251244 -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3272) JDBC Translator | Segregation of batch execution and commit mode

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3272?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3272: --------------------------------------- I may not have followed you completely on the forum posting. The current behavior is to start a local transaction (assuming there is not a higher level transaction already) and then commit when all batches have been processed - not a commit for each batch. When are you seeing a commit with each batch? Is that from a higher level breakdown of source queries? > The no of batches after which a commit is desired should be a configurable option. Can you elaborate on the scenarios when you want to have a non-atomic update? What would be your expectations when there is an exception - stop processing batches, best effort continue, etc.? > JDBC Translator | Segregation of batch execution and commit mode > ----------------------------------------------------------------- > > Key: TEIID-3272 > URL: https://issues.jboss.org/browse/TEIID-3272 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Shiveeta Mattoo > Assignee: Steven Hawkins > Labels: Batch-Commit, JDBC-Transator > > In JDBC Translator, the batch execution and commit are coupled together. Hence, we after every batch execution, a commit is executed. > This enhancement is for providing an ability to support the commit after a configurable 'x' no. of batches has completed, instead of an automatic commit after every batch. > The no of batches after which a commit is desired should be a configurable option. > -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3273) Exception while using biginteger column with SUM function

by Rakesh Balguri (JIRA)

Rakesh Balguri created TEIID-3273: ------------------------------------- Summary: Exception while using biginteger column with SUM function Key: TEIID-3273 URL: https://issues.jboss.org/browse/TEIID-3273 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7 Environment: Teiid 8.7 and Windows Reporter: Rakesh Balguri Assignee: Steven Hawkins I have column which is of "BigInteger" type and when I am trying to execute an SQL which contains the SUM function I am getting the following exception. The following is the SQL: SELECT SUM(age) FROM test My understanding is that the sum of all the BigInteger's is not fitting in the size of the BigInteger and Teiid is trying to convert it into a BigDecimal and end up in an exception. How to fix this problem? Do we have a woraround for this? Caused by: org.teiid.core.TeiidRuntimeException: TEIID20001 The modeled datatype biginteger for column 0 doesn't match the runtime type "java.math.BigDecimal". Please ensure that the column's modeled datatype matches the expected data. at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:851) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:317) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1443) [rt.jar:1.7.0_03] at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1414) [rt.jar:1.7.0_03] at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1174) [rt.jar:1.7.0_03] at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:346) [rt.jar:1.7.0_03] at org.teiid.net.socket.Message.writeExternal(Message.java:61) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1443) [rt.jar:1.7.0_03] at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1414) [rt.jar:1.7.0_03] at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1174) [rt.jar:1.7.0_03] at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:346) [rt.jar:1.7.0_03] at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:131) [teiid-runtime-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] ... 25 more Caused by: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.math.BigInteger at org.teiid.client.BatchSerializer$BigIntegerColumnSerializer.writeObject(BatchSerializer.java:681) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:506) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:840) [teiid-client-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT] ... 36 more See the discussion in Teiid Forums for more information: https://developer.jboss.org/thread/251244 -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3272) JDBC Translator | Segregation of batch execution and commit mode

by Shiveeta Mattoo (JIRA)

Shiveeta Mattoo created TEIID-3272: -------------------------------------- Summary: JDBC Translator | Segregation of batch execution and commit mode Key: TEIID-3272 URL: https://issues.jboss.org/browse/TEIID-3272 Project: Teiid Issue Type: Enhancement Components: JDBC Connector Reporter: Shiveeta Mattoo Assignee: Steven Hawkins In JDBC Translator, the batch execution and commit are coupled together. Hence, we after every batch execution, a commit is executed. This enhancement is for providing an ability to support the commit after a configurable 'x' no. of batches has completed, instead of an automatic commit after every batch. The no of batches after which a commit is desired should be a configurable option. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3271) JDBC Translator | Incorrect Update count reported on Batched Update Execution

by Shiveeta Mattoo (JIRA)

Shiveeta Mattoo created TEIID-3271: -------------------------------------- Summary: JDBC Translator | Incorrect Update count reported on Batched Update Execution Key: TEIID-3271 URL: https://issues.jboss.org/browse/TEIID-3271 Project: Teiid Issue Type: Bug Components: JDBC Connector Reporter: Shiveeta Mattoo Assignee: Steven Hawkins Issue is related to Batched updates scenario. Typically, the executeBatch() returns an array of integers, and each element of the array represents the update count for the respective update statement. However in case of Teiid JDBC Translator, over and above this, we are processing the array to return a sum of all the elements as in seen in JDBCUpdateExecution -> executeTranslatedCommand method int[] results = pstatement.executeBatch(); for (int i=0; i<results.length; i++) { updateCount += results[i]; } The bug is logged to fix this to meet the standard behaviour Refer thread https://developer.jboss.org/message/914596?et=watches.email.thread#914596 for details -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2816) HBase Connector/Translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2816?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2816: --------------------------------------- Sorry Kylin, I wasn't able to get this in for Alpha2. But I'll make sure that it gets in for Beta1. > HBase Connector/Translator > -------------------------- > > Key: TEIID-2816 > URL: https://issues.jboss.org/browse/TEIID-2816 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, JDBC Connector, JDBC Driver > Affects Versions: Open To Community > Reporter: devin pinkston > Assignee: Kylin Soong > Labels: HBase, Translator > Fix For: 8.10 > > > Develop a HBase translator/connector. Potentially using the Phoenix JDBC driver, supports most SQL and handles connections: > https://github.com/forcedotcom/phoenix -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3036) Update CXF to current version (3.0.0)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3036?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3036: --------------------------------------- That would be with Teiid 9 in somewhere around 6 months. > Update CXF to current version (3.0.0) > ------------------------------------- > > Key: TEIID-3036 > URL: https://issues.jboss.org/browse/TEIID-3036 > Project: Teiid > Issue Type: Feature Request > Components: Embedded > Affects Versions: 8.8 > Reporter: Gary Gregory > > In the same vein as TEIID-3030, we embed CXF and Teiid in our server. We use CXF 2.7.10 and are about to update to 3.0.0. At worse, we'll go to 2.7.11 as an interim step to 3.0.0. > Teiid embedded delivers CXF 2.6.6 for web services support. > It would be great if we could get Teiid to the latest and greatest from CXF so we can all live in the same space without being forced to deal with any incompatibilities or class loader hacks. > Thank you, > Gary -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3030) Update Saxon to current release (9.5.x)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3030?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3030: --------------------------------------- Unless there are bugs or other significant issues, I don't expect that we'll keep in lock step with saxon. > Update Saxon to current release (9.5.x) > --------------------------------------- > > Key: TEIID-3030 > URL: https://issues.jboss.org/browse/TEIID-3030 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.7 > Environment: Apache Maven 3.2.2 (45f7c06d68e745d05611f7fd14efb6594181933e; 2014-06-17T09:51:42-04:00) > Maven home: C:\Java\apache-maven-3.2.2 > Java version: 1.7.0_60, vendor: Oracle Corporation > Java home: C:\Program Files\Java\jdk1.7.0_60\jre > Default locale: en_US, platform encoding: Cp1252 > OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows" > Reporter: Gary Gregory > Assignee: Steven Hawkins > Fix For: 8.9 > > > Our product embeds a Teiid server and provides its own set of 3rd party jar files, one of which clashes with Teiid: we provide Saxon-HE 9.4.0.6 and Teiid provides 9.2.1.5. These two versions are NOT binary compatible. > This shows up using the web services connector as a class not found error because some classes have been repackaged between Saxon 9.2.x and 9.4.x. > If Teiid updates to the latest version (9.5), so can we, and avoid backporting our Saxon dependencies. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 12 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2014