[JBoss JIRA] Created: (TEIID-1560) Add support for user defined / pushdown aggregate functions
by Steven Hawkins (JIRA)
Add support for user defined / pushdown aggregate functions
-----------------------------------------------------------
Key: TEIID-1560
URL: https://issues.jboss.org/browse/TEIID-1560
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.0
Add support for user defined aggregate functions. This would also affect the function model metadata. Our aggregate handling logic will need to be generalized to make this possible. Starting with the parser we've got special handling for built-in aggregates.
for user defined aggregate handling just a static method will not work as the function needs to retain state across each group. Could require that the implementing class extends AggregateFunction.
Could also allow user defined aggregates to take an order by clause.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 5 months
[JBoss JIRA] (TEIID-1982) When packaging the rhq admin console jar for the jboss kit, add the teiid-client.jar contents to it
by Van Halbert (JIRA)
Van Halbert created TEIID-1982:
----------------------------------
Summary: When packaging the rhq admin console jar for the jboss kit, add the teiid-client.jar contents to it
Key: TEIID-1982
URL: https://issues.jboss.org/browse/TEIID-1982
Project: Teiid
Issue Type: Task
Components: Build/Kits
Affects Versions: 7.4.1, 7.7.1, 8.0
Reporter: Van Halbert
Assignee: Van Halbert
This is a fix being pushed up stream. When the admin console rhq jar is being packaged into the jboss kit, it needs the teiid-client.jar added to it.
Here's the pom.xml changes being submitted as an example:
<mkdir dir="target/work/rhqrepackage" />
<!-- repackage the jon console jar to include the teiid client jar -->
<jar destfile="target/work/rhqrepackage/rhq-teiid-plugin-SOA-${project.version}.jar">
<zipfileset src="target/work/teiid/resources/runtime/deploy/admin-console.war/plugins/rhq-teiid-plugin-SOA-${project.version}.jar" excludes="META-INF/**.RSA,META-INF/**.SF"/>
<zipfileset src="target/work/teiid/client/teiid-client.jar" excludes="META-INF/**.RSA,META-INF/**.SF"/>
</jar>
<copy file="target/work/rhqrepackage/rhq-teiid-plugin-SOA-${project.version}.jar"
tofile="target/work/teiid/resources/runtime/deploy/admin-console.war/plugins/rhq-teiid-plugin-SOA-${project.version}.jar" overwrite="true" />
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 5 months
[JBoss JIRA] (TEIID-1899) Getting Assertion when running running Inner Merge Join
by Van Halbert (JIRA)
Van Halbert created TEIID-1899:
----------------------------------
Summary: Getting Assertion when running running Inner Merge Join
Key: TEIID-1899
URL: https://issues.jboss.org/browse/TEIID-1899
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Reporter: Van Halbert
Assignee: Steven Hawkins
When running the following query, it causing an ASSERTION (see attached log):
SELECT COUNT(*) AS CNT FROM (SELECT ORDERS.O_ORDERKEY, ORDERS.O_ORDERDATE, ORDERS.O_CLERK, CUSTOMER.C_CUSTKEY, CUSTOMER.C_NAME, CUSTOMER.C_ACCTBAL
FROM TPCR01_PostgreSQLVirt.ORDERS, TPCR01_OracleVirt.CUSTOMER WHERE (CUSTOMER.C_CUSTKEY = ORDERS.O_CUSTKEY) AND
(ORDERS.O_ORDERDATE < '1992-01-05 00:00:00') AND (CUSTOMER.C_ACCTBAL < 9514.5)) AS T
Note: this doesn't fail when SELECT COUNT(*) is added
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 5 months
[JBoss JIRA] (TEIID-1960) Client recieving java.lang.IndexOutOfBoundsException in
by Tim Bruce (JIRA)
Tim Bruce created TEIID-1960:
--------------------------------
Summary: Client recieving java.lang.IndexOutOfBoundsException in
Key: TEIID-1960
URL: https://issues.jboss.org/browse/TEIID-1960
Project: Teiid
Issue Type: Bug
Environment: JBoss 5.1.0.GA Teiid Engine 7.6.0.Final 64-bit Java 1.7.0
Reporter: Tim Bruce
Assignee: Steven Hawkins
01 Mar 2012 21:37:21,891 GMT ERROR [org.teiid.TRANSPORT] (Worker225_QueryProcessorQueue13539) Unhandled exception, closing client instance
java.lang.IndexOutOfBoundsException: Index: 3, Size: 3
at java.util.ArrayList.rangeCheck(ArrayList.java:615)
at java.util.ArrayList.get(ArrayList.java:393)
at org.teiid.client.BatchSerializer.writeIsNullData(BatchSerializer.java:226)
at org.teiid.client.BatchSerializer$ColumnSerializer.writeColumn(BatchSerializer.java:262)
at org.teiid.client.BatchSerializer.writeBatch(BatchSerializer.java:542)
at org.teiid.client.ResultsMessage.writeExternal(ResultsMessage.java:277)
at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1463)
at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1434)
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1194)
at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:363)
at org.teiid.net.socket.Message.writeExternal(Message.java:56)
at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1463)
at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1434)
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1194)
at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:363)
at org.teiid.transport.ObjectEncoder.handleDownstream(ObjectEncoder.java:115)
at org.jboss.netty.channel.Channels.write(Channels.java:611)
at org.jboss.netty.channel.Channels.write(Channels.java:578)
at org.jboss.netty.channel.AbstractChannel.write(AbstractChannel.java:258)
at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:94)
at org.teiid.transport.SocketClientInstance.send(SocketClientInstance.java:82)
at org.teiid.transport.ServerWorkItem.sendResult(ServerWorkItem.java:127)
at org.teiid.transport.ServerWorkItem$1.onCompletion(ServerWorkItem.java:99)
at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)
at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)
at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)
at org.teiid.dqp.internal.process.RequestWorkItem.sendResultsIfNeeded(RequestWorkItem.java:674)
at org.teiid.dqp.internal.process.RequestWorkItem$1.flushBatchDirect(RequestWorkItem.java:528)
at org.teiid.query.processor.BatchCollector.flushBatch(BatchCollector.java:174)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149)
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:370)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1121)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614)
at java.lang.Thread.run(Thread.java:769)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 5 months