[JBoss JIRA] (TEIID-3023) records lost when query by hiernate
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3023?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3023.
---------------------------------
> records lost when query by hiernate
> -----------------------------------
>
> Key: TEIID-3023
> URL: https://issues.jboss.org/browse/TEIID-3023
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.3
> Environment: window7,eclipse Helios Service Release 2, Teiid v7.3.0
> Reporter: Lai Chao
> Priority: Minor
>
> Recently, I get an issue when retrieve data from vdb that some records lost in the list. Fox example, from source table we can get 12100 records, but from vdb query(projects with hibernate) can only get 10800+ records.
> Meanwhile, there's a set on maxSetSize = 1000, is there any affects?
> Please advise.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-3090) Unexpected exception for correct SQL query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3090?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3090.
---------------------------------
> Unexpected exception for correct SQL query
> ------------------------------------------
>
> Key: TEIID-3090
> URL: https://issues.jboss.org/browse/TEIID-3090
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: OS: Fedora 20
> hardware: x86_64
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Query ends with exception. Same query for MariaDB database returns correct result but Teiid throws an exception.
> Actual results:
> Query ends with exception - TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: Unexpected exception while translating results: Error
> Expected results:
> No exception
> Additional info:
> excption stack trace and server log in attachment
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-3182) Decimal number got converted to Integer
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3182?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3182.
---------------------------------
> Decimal number got converted to Integer
> ---------------------------------------
>
> Key: TEIID-3182
> URL: https://issues.jboss.org/browse/TEIID-3182
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.8
> Environment: Teiid 8.8.1 with hive driver (hortonworks 2.0)
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
>
> Teiid engines converts value 1000.0 to 1000 and it doesn't keep the original data type.
> My original SQL:
> select ("meat_sqft" / 1000.0) as "calcField2" from "HDP20_default"."store" group by ("meat_sqft" / 1000.0)
> and Teiid translated it to:
> SELECT v_0.c_0 FROM (SELECT (g_0.meat_sqft / 1000) AS c_0 FROM HDP20_default.store AS g_0) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 200001
> (g_0.meat_sqft / 1000) field returns Integer instead of decimal.
> However, if I use 1000.1 instead and it would work.
> Original SQL:
> select ("meat_sqft" / 1000.1) as "calcField2" from "HDP20_default"."store" group by ("meat_sqft" / 1000.1)
> And teiid translated it to:
> SELECT v_0.c_0 FROM (SELECT (convert(g_0.meat_sqft, bigdecimal) / 1000.1) AS c_0 FROM HDP20_default.store AS g_0) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 200001
> I believe both 1000.0 and 1000.1 should have consistent behavior.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-2687) Expose Translator override property definitions through Admin API
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2687?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2687.
---------------------------------
> Expose Translator override property definitions through Admin API
> -----------------------------------------------------------------
>
> Key: TEIID-2687
> URL: https://issues.jboss.org/browse/TEIID-2687
> Project: Teiid
> Issue Type: Enhancement
> Components: AdminApi
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Labels: alpha3
> Fix For: 8.6
>
>
> Currently in the admin api
> {code}
> public Collection<PropertyDefinition> getTemplatePropertyDefinitions(String templateName) throws AdminException;
> {code}
> only works with resource-adapters and data sources in terms of returning the properties that can be configured on them.
> This request is to extend the functionality to return the "overridable" properties for "translators", such as
> {code}
> public Collection<PropertyDefinition> getTemplatePropertyDefinitions(String templateName, boolean isTranslator) throws AdminException;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-3084) Unable to evaluate <fieldName>: No value was available
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3084?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3084.
---------------------------------
> Unable to evaluate <fieldName>: No value was available
> ------------------------------------------------------
>
> Key: TEIID-3084
> URL: https://issues.jboss.org/browse/TEIID-3084
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.9
> Reporter: Alex K.
> Assignee: Steven Hawkins
>
> When issuing following statement on Teiid 8.9.0 Alpha1
> {code:sql}
> select a from (
> SELECT sc.a FROM test_tables.test_a sc,
> table(exec SYSADMIN.logMsg(
> "level" => 'INFO',
> "context" => 'org.teiid.test',
> "msg" => 'Test Message: ' || sc.b
> )) f
> ) as x group by a
> {code}
> following exception is thrown:
> {code:sql}
> 12:46:48,419 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue9) aMFpKzpsXmof TEIID30019 Unexpected exception for request aMFpKzpsXmof.4: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate sc.b: No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:490) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:639) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:614) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:111) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:94) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:272) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:202) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.GroupingNode.sortPhase(GroupingNode.java:394) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:331) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.9.0.Alpha1.jar:8.9.0.Alpha1]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-2799) Import metadata from Object translator is not defining primary key
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2799?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2799.
---------------------------------
> Import metadata from Object translator is not defining primary key
> ------------------------------------------------------------------
>
> Key: TEIID-2799
> URL: https://issues.jboss.org/browse/TEIID-2799
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Minor
> Fix For: 8.7
>
>
> The infinispan implementation of the object translator getMetadata is not defining the primary key. If the resource-adapter has defined it, it should expose it. This key is important for push-down capability. The user could define this after the fact (i.e, in dynamic vdb or in designer), but from a usability stand point, it would be better if the translator exposed it.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-3085) Exception with unclear message
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3085?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3085.
---------------------------------
> Exception with unclear message
> ------------------------------
>
> Key: TEIID-3085
> URL: https://issues.jboss.org/browse/TEIID-3085
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Unexpected exception. Returned exception indicates that query failed but there is no reason in message.
> Actual results:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."timevalue", cast(g_0."bytenum" AS smallint), (SELECT g_1."floatnum" FROM "smalla" AS g_1 WHERE g_1."intkey" = g_0."intkey" AND g_1."intkey" = (SELECT g_2."intkey" FROM "smalla" AS g_2 WHERE g_2."stringnum" > '10' AND g_2."intkey" = g_1."intkey")) FROM "smalla" AS g_0]
> Expected results:
> Remote org.postgresql.util.PSQLException: ERROR: Interconnect Error: Unexpected Motion Node Id: 2. This means a motion node that wasn't setup is requesting interconnect resources.
> Additional info:
> Log and exception stack trace in attachment.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months
[JBoss JIRA] (TEIID-3088) Exception with unclear message
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3088?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3088.
---------------------------------
> Exception with unclear message
> ------------------------------
>
> Key: TEIID-3088
> URL: https://issues.jboss.org/browse/TEIID-3088
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.7
> Environment: OS: Fedora 20
> hardware: x86_64
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
> Attachments: exception-stack-trace, full-server.log, server.log
>
>
> Description of problem:
> Unexpected exception. Returned exception indicates that query failed but there is no reason in message.
> Actual results:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4502 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.stringkey = (SELECT g_1.stringkey FROM smalla AS g_1 WHERE g_1.intnum = g_0.intnum) ORDER BY c_0]
> Additional info:
> server log and exception stack trace in attachment
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
9 years, 8 months