[JBoss JIRA] (TEIID-3878) java.lang.Integer cannot be cast to java.math.BigDecimal
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3878?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3878.
---------------------------------
> java.lang.Integer cannot be cast to java.math.BigDecimal
> --------------------------------------------------------
>
> Key: TEIID-3878
> URL: https://issues.jboss.org/browse/TEIID-3878
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.11.3
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Priority: Critical
> Attachments: TEIID-3878.sql
>
>
> I'm using Teiid 8.11.3 with oracle translator.
> I have an aggregated query using teiid materialized views with the following simplified criteria:
> (CASE WHEN ( "table1"."field1" = 1 ) THEN "table2"."yearfield" ELSE null END IN (2014) )
> The above criteria is reproducing a ClassCastException Integer cannot be cast to BigDecimal
> if I change the criteria to the following, it passes without a problem:
> ("table2"."yearfield" IN (2014) )
> Here is the error stack:
> java.lang.ClassCastException: java.lang.Integer cannot be cast to java.math.BigDecimal
> at java.math.BigDecimal.compareTo(BigDecimal.java:219)
> at org.teiid.query.sql.symbol.Constant$2.compare(Constant.java:99)
> at org.teiid.query.eval.Evaluator.compare(Evaluator.java:581)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:322)
> at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:236)
> at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:225)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:219)
> at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353)
> at org.teiid.query.processor.relational.EnhancedSortMergeJoinStrategy.process(EnhancedSortMergeJoinStrategy.java:460)
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94)
> at org.teiid.query.processor.relational.GroupingNode.groupSortPhase(GroupingNode.java:490)
> at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:366)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:148)
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278)
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151)
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:457)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:339)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:267)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:306)
> at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:238)
> at sun.reflect.GeneratedMethodAccessor260.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:175)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260)
> at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:173)
> at com.sun.proxy.$Proxy31.executeRequest(Unknown Source)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:667)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:533)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1068)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:320)
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months
[JBoss JIRA] (TEIID-4153) OLAPExecutionFactory Exception Unwrapping Results
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4153?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4153.
---------------------------------
> OLAPExecutionFactory Exception Unwrapping Results
> -------------------------------------------------
>
> Key: TEIID-4153
> URL: https://issues.jboss.org/browse/TEIID-4153
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.13.3
> Reporter: Ted Jones
> Assignee: Steven Hawkins
> Attachments: query plan and stack trace 2.txt
>
>
> When executing an MDX query against SAP BW (a BEx query), the following exception occurs:
> 11:49:32,573 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=9WKT1UuAq4j/.0.3.0: org.teiid.translator.TranslatorException: Not a wrapper for: org.olap4j.OlapWrapper
> at org.teiid.translator.olap.OlapExecutionFactory.unwrap(OlapExecutionFactory.java:77)
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months
[JBoss JIRA] (TEIID-3877) Sort result set before BQT comparison
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3877?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3877.
---------------------------------
> Sort result set before BQT comparison
> -------------------------------------
>
> Key: TEIID-3877
> URL: https://issues.jboss.org/browse/TEIID-3877
> Project: Teiid
> Issue Type: Feature Request
> Components: Tools
> Environment: BQT 2.2.0
> JBoss DV 6.2
> Reporter: Jean-Pierre Matsumoto
> Assignee: Van Halbert
> Priority: Minor
>
> Currently it is not possible to ask to BQT to sort result set before it compares to reference. When an SQL query returns rows in a random order, the BQT test fails because of the different order of rows.
> I know I could use ORDER BY in the SQL but I don't like much this solution because it impacts the query plan.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months
[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3834.
---------------------------------
> Error during (re) adding connection factory using CLI
> -----------------------------------------------------
>
> Key: TEIID-3834
> URL: https://issues.jboss.org/browse/TEIID-3834
> Project: Teiid
> Issue Type: Sub-task
> Components: Server
> Affects Versions: 8.13
> Reporter: Kylin Soong
> Assignee: Ramesh Reddy
>
> enable datasource command
> {code}
> /subsystem=datasources/data-source=h2:enable
> {code}
> seems redundant, cause datasource add already enable it, so if execute setup.cli
> {code}
> ./bin/jboss-cli.sh --connect --file=setup.cli
> {code}
> will cause a eror
> {code}
> {
> "outcome" => "failed",
> "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered",
> "rolled-back" => true
> }
> 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([
> ("subsystem" => "datasources"),
> ("data-source" => "h2")
> ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered
> at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158)
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months
[JBoss JIRA] (TEIID-4415) OData4 contains(columnname, 'value') eq true filter fails
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4415?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4415.
---------------------------------
> OData4 contains(columnname,'value') eq true filter fails
> --------------------------------------------------------
>
> Key: TEIID-4415
> URL: https://issues.jboss.org/browse/TEIID-4415
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 9.0.2
> Environment: WildFly 10
> Teiid 9.0.2
> Reporter: J Price
> Assignee: Steven Hawkins
>
> I am receiving the following error message when using a contains filter on an odata4 endpoint:
> <error><code>null</code><message>TEIID31100 Parsing error: Encountered ") >= 1 [*]=[*] CONVERT(" at line 1, column 247.
> Was expecting: "and" | "or" | "," | ")" | "*" | "/" | "+" | "-" | "||" | "&&" ...</message></error>
> The URI to reproduce this is as folows:
> /odata4/Sandbox.1/Compatibility/USERLIST?$top=6&$filter=contains(FIRSTNAME,'peter') eq true and contains(LASTNAME,'peter') eq false
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months
[JBoss JIRA] (TEIID-4036) Accumulo translator: NullPointerException on runQuery invocation
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4036?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-4036.
---------------------------------
> Accumulo translator: NullPointerException on runQuery invocation
> ----------------------------------------------------------------
>
> Key: TEIID-4036
> URL: https://issues.jboss.org/browse/TEIID-4036
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.5
> Reporter: Jan Stastny
> Attachments: accumulo-vdb.xml
>
>
> Teiid query on accumulo fails with following exception:
> {code:plain}
> org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
> at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
> at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:706)
> at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64)
> at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:545)
> at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
> at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
> at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
> at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:268)
> at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:306)
> at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
> at com.sun.proxy.$Proxy6.read(Unknown Source)
> at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:405)
> at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:554)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1076)
> at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323)
> at org.jboss.bqt.framework.AbstractQuery.execute(AbstractQuery.java:208)
> at org.jboss.bqt.client.testcase.ProcessResults.executeTest(ProcessResults.java:280)
> at org.jboss.bqt.client.testcase.ProcessResults.runTestCase(ProcessResults.java:160)
> at org.jboss.bqt.client.TestClient.runScenario(TestClient.java:209)
> at org.jboss.bqt.client.TestClient.runTest(TestClient.java:132)
> at org.jboss.bqt.client.TestClient.runTest(TestClient.java:113)
> at org.jboss.qe.bqt.BQTHelper.startTest(BQTHelper.java:59)
> at org.jboss.dv.test.bqt.Utils.runScenarioTest(Utils.java:197)
> at org.jboss.dv.test.bqt.TestPassFour.test(TestPassFour.java:174)
> at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:80)
> at org.testng.internal.Invoker.invokeMethod(Invoker.java:714)
> at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
> at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
> at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
> at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
> at org.testng.TestRunner.privateRun(TestRunner.java:767)
> at org.testng.TestRunner.run(TestRunner.java:617)
> at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
> at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
> at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
> at org.testng.SuiteRunner.run(SuiteRunner.java:240)
> at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
> at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
> at org.testng.TestNG.runSuitesSequentially(TestNG.java:1198)
> at org.testng.TestNG.runSuitesLocally(TestNG.java:1123)
> at org.testng.TestNG.run(TestNG.java:1031)
> at org.apache.maven.surefire.testng.TestNGExecutor.run(TestNGExecutor.java:70)
> at org.apache.maven.surefire.testng.TestNGDirectoryTestSuite.execute(TestNGDirectoryTestSuite.java:108)
> at org.apache.maven.surefire.testng.TestNGProvider.invoke(TestNGProvider.java:111)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:164)
> at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:110)
> at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:172)
> at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcessWhenForked(SurefireStarter.java:104)
> at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:70)
> Caused by: org.teiid.core.TeiidException
> at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196)
> at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1084)
> at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:576)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:374)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.lang.NullPointerException
> at org.apache.accumulo.core.client.impl.Namespaces.getMap(Namespaces.java:98)
> at org.apache.accumulo.core.client.impl.Namespaces.getNameToIdMap(Namespaces.java:131)
> at org.apache.accumulo.core.client.impl.Tables._getTableId(Tables.java:183)
> at org.apache.accumulo.core.client.impl.Tables.getTableId(Tables.java:169)
> at org.apache.accumulo.core.client.impl.ConnectorImpl.getTableId(ConnectorImpl.java:80)
> at org.apache.accumulo.core.client.impl.ConnectorImpl.createScanner(ConnectorImpl.java:147)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.runQuery(AccumuloQueryExecution.java:99)
> at org.teiid.translator.accumulo.AccumuloQueryExecution.execute(AccumuloQueryExecution.java:84)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:359)
> at sun.reflect.GeneratedMethodAccessor418.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy159.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> ... 6 more
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months
[JBoss JIRA] (TEIID-4234) Gradle blueprint
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4234?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4234:
----------------------------------
Fix Version/s: (was: 9.1)
> Gradle blueprint
> ----------------
>
> Key: TEIID-4234
> URL: https://issues.jboss.org/browse/TEIID-4234
> Project: Teiid
> Issue Type: Feature Request
> Components: Tools
> Reporter: jay vyas
> Attachments: build.gradle
>
>
> As a app developer, I'd like to spin up a teiid/JDV application with all client-side dependencies
> without needing to use an IDE.
> Currently, most of the TEiid resources and videos are based on IDE features, bootstrapping teiid on the local machine.
> Ideally, we might host a simple Teiid server that can run in a dockerfile with sample data, along side a gradle runnable file.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months
[JBoss JIRA] (TEIID-150) Improve nested loop (in merge join) matching
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-150?page=com.atlassian.jira.plugin.... ]
Steven Hawkins updated TEIID-150:
---------------------------------
Fix Version/s: (was: 7.0)
> Improve nested loop (in merge join) matching
> ---------------------------------------------
>
> Key: TEIID-150
> URL: https://issues.jboss.org/browse/TEIID-150
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 9.x
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Minor
> Labels: performance
> Original Estimate: 1 day
> Remaining Estimate: 1 day
>
> Nested loop evaluation should be based upon available blocks rather than fully iterating the inner side. The simplest approach is to just match a single block from the left and right at a time.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
9 years, 5 months