[JBoss JIRA] (TEIID-4995) Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4995?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4995.
-----------------------------------
Fix Version/s: 10.0
Resolution: Done
Added a formatStrings translator property.
> Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator
> --------------------------------------------------------------------------------
>
> Key: TEIID-4995
> URL: https://issues.jboss.org/browse/TEIID-4995
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 8.7.12.6_2, 8.12.11.6_3, 9.2.4
> Environment: Excel translator
> Integer values in string columns
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Fix For: 10.0
>
>
> For integer values in a string column, values are displayed as a decimal value (for example, a value "5" is displayed as "5.0"). It looks like org.apache.poi.ss.usermodel.DataFormatter [1] by default attempts to format values in the same manner as Excel would display it [2], and would result in the integer value "5" being displayed as "5". In the case of string columns, this would avoid the user needing to modify source data to compensate as indicated as workarounds in TEIID-3947.
> [1] https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter....
> [2] The default number format will mimic the Excel General format: "#" for whole numbers and "#.##########" for decimal numbers.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4994) For materialization, use "Ignore return values" option to improve performance
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4994?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4994:
----------------------------------
Fix Version/s: 10.0
> For materialization, use "Ignore return values" option to improve performance
> -----------------------------------------------------------------------------
>
> Key: TEIID-4994
> URL: https://issues.jboss.org/browse/TEIID-4994
> Project: Teiid
> Issue Type: Enhancement
> Components: Infinispan
> Affects Versions: 8.12.x-6.4, 9.3.2
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
> Fix For: 10.0
>
>
> For a performance improvement, change to use Flag.IGNORE_RETURN_VALUES
> Cache noPreviousValueCache = cache.getAdvancedCache().withFlags(Flag.IGNORE_RETURN_VALUES);
> noPreviousValueCache.put(k, v);
> or can use ConfigurationBuilder settings:
> ConfigurationBuilder cb = new ConfigurationBuilder();
> cb.unsafe().unreliableReturnValues(true);
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-5001) TextTable usage in UNION/UNION ALL queries with JOINs fails with "No value was available" or NPE errors
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5001?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5001:
------------------------------------
[~shawkins] thx a lot for the quick fix!
> TextTable usage in UNION/UNION ALL queries with JOINs fails with "No value was available" or NPE errors
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIID-5001
> URL: https://issues.jboss.org/browse/TEIID-5001
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 9.3
> Environment: teiid-9.3.0.Final on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 10.0, 9.2.5, 9.3.2
>
> Attachments: emptydateranges.csv
>
>
> Running the following query:
> {code:sql}
> SELECT id FROM
> (SELECT d.id FROM (
> SELECT 'l1' as domain
> ) dim_md_domains_to_load, table(CALL testcase.proc_web_avg_visit_duration_empty("domain" => domain)) x
> JOIN testcase.dim_md_date_ranges d ON true
> UNION
> SELECT id FROM testcase.dim_md_date_ranges
> ) z
> {code}
> when using the following procedure:
> {code:sql}
> CREATE VIRTUAL PROCEDURE proc_web_avg_visit_duration_empty(
> domain string
> ) RETURNS (i integer) AS
> BEGIN
> select 1;
> END
> {code}
> leads to the following error message:
> {code}
> 2017-07-19 19:57:12,608 ERROR [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue15) FOgTHY5kk50l TEIID30019 Unexpected exception for request FOgTHY5kk50l.1: org.teiid.core.TeiidCo
> mponentException: TEIID30328 Unable to evaluate dim_md_domains_to_load.domain: No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:514)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:766)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
> at org.teiid.query.processor.proc.ProcedurePlan.evaluateExpression(ProcedurePlan.java:857)
> at org.teiid.query.processor.proc.ProcedurePlan.open(ProcedurePlan.java:225)
> at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:82)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95)
> at org.teiid.query.processor.relational.NestedTableJoinStrategy.openLeft(NestedTableJoinStrategy.java:74)
> at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:145)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:123)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.DupRemoveNode.open(DupRemoveNode.java:53)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:146)
> at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:136)
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:231)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
> 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:477)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> 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:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
> and when using the following procedure:
> {code:sql}
> CREATE VIRTUAL PROCEDURE proc_web_avg_visit_duration_empty(
> domain string
> ) RETURNS (i integer) AS
> BEGIN
> END
> {code}
> leads to the following error message:
> {code}
> 2017-07-19 19:51:09,898 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue6) W9VMA4B+d8Gd TEIID30019 Unexpected exception for request W9VMA4B+d8Gd.1: java.lang.NullPointerEx
> ception
> at org.teiid.query.processor.proc.Program.instructionsRequireTransaction(Program.java:307)
> at org.teiid.query.processor.proc.Program.requiresTransaction(Program.java:301)
> at org.teiid.query.processor.proc.ProcedurePlan.requiresTransaction(ProcedurePlan.java:881)
> at org.teiid.query.processor.relational.PlanExecutionNode.requiresTransaction(PlanExecutionNode.java:184)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:283)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:269)
> at org.teiid.dqp.internal.process.Request.getTransactionContext(Request.java:374)
> at org.teiid.dqp.internal.process.Request.createProcessor(Request.java:350)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:485)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:657)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:338)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> 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:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-5001) TextTable usage in UNION/UNION ALL queries with JOINs fails with "No value was available" or NPE errors
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5001?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5001.
-----------------------------------
Fix Version/s: 10.0
9.2.5
9.3.2
Resolution: Done
Updated the check for correlated references to look at each source. Also backported the npe fix to 9.2.x.
> TextTable usage in UNION/UNION ALL queries with JOINs fails with "No value was available" or NPE errors
> -------------------------------------------------------------------------------------------------------
>
> Key: TEIID-5001
> URL: https://issues.jboss.org/browse/TEIID-5001
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 9.3
> Environment: teiid-9.3.0.Final on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 10.0, 9.2.5, 9.3.2
>
> Attachments: emptydateranges.csv
>
>
> Running the following query:
> {code:sql}
> SELECT id FROM
> (SELECT d.id FROM (
> SELECT 'l1' as domain
> ) dim_md_domains_to_load, table(CALL testcase.proc_web_avg_visit_duration_empty("domain" => domain)) x
> JOIN testcase.dim_md_date_ranges d ON true
> UNION
> SELECT id FROM testcase.dim_md_date_ranges
> ) z
> {code}
> when using the following procedure:
> {code:sql}
> CREATE VIRTUAL PROCEDURE proc_web_avg_visit_duration_empty(
> domain string
> ) RETURNS (i integer) AS
> BEGIN
> select 1;
> END
> {code}
> leads to the following error message:
> {code}
> 2017-07-19 19:57:12,608 ERROR [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue15) FOgTHY5kk50l TEIID30019 Unexpected exception for request FOgTHY5kk50l.1: org.teiid.core.TeiidCo
> mponentException: TEIID30328 Unable to evaluate dim_md_domains_to_load.domain: No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:514)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:766)
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:726)
> at org.teiid.query.processor.proc.ProcedurePlan.evaluateExpression(ProcedurePlan.java:857)
> at org.teiid.query.processor.proc.ProcedurePlan.open(ProcedurePlan.java:225)
> at org.teiid.query.processor.relational.PlanExecutionNode.open(PlanExecutionNode.java:82)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95)
> at org.teiid.query.processor.relational.NestedTableJoinStrategy.openLeft(NestedTableJoinStrategy.java:74)
> at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:145)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.UnionAllNode.open(UnionAllNode.java:123)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.DupRemoveNode.open(DupRemoveNode.java:53)
> at org.teiid.query.processor.relational.RelationalNode.open(RelationalNode.java:254)
> at org.teiid.query.processor.relational.LimitNode.open(LimitNode.java:146)
> at org.teiid.query.processor.relational.RelationalPlan.open(RelationalPlan.java:136)
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:231)
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
> 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:477)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:349)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> 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:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
> and when using the following procedure:
> {code:sql}
> CREATE VIRTUAL PROCEDURE proc_web_avg_visit_duration_empty(
> domain string
> ) RETURNS (i integer) AS
> BEGIN
> END
> {code}
> leads to the following error message:
> {code}
> 2017-07-19 19:51:09,898 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue6) W9VMA4B+d8Gd TEIID30019 Unexpected exception for request W9VMA4B+d8Gd.1: java.lang.NullPointerEx
> ception
> at org.teiid.query.processor.proc.Program.instructionsRequireTransaction(Program.java:307)
> at org.teiid.query.processor.proc.Program.requiresTransaction(Program.java:301)
> at org.teiid.query.processor.proc.ProcedurePlan.requiresTransaction(ProcedurePlan.java:881)
> at org.teiid.query.processor.relational.PlanExecutionNode.requiresTransaction(PlanExecutionNode.java:184)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:283)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:291)
> at org.teiid.query.processor.relational.RelationalPlan.requiresTransaction(RelationalPlan.java:269)
> at org.teiid.dqp.internal.process.Request.getTransactionContext(Request.java:374)
> at org.teiid.dqp.internal.process.Request.createProcessor(Request.java:350)
> at org.teiid.dqp.internal.process.Request.processRequest(Request.java:485)
> at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:657)
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:338)
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:275)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> 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:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months
[JBoss JIRA] (TEIID-4924) Push Teiid artifacts to maven central
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4924?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4924:
-------------------------------------
A new profile called "final-release" has been added to the Teiid pom.xml, this profile needs to uses the PGP signing and Javadoc requirements by Maven Central. Before this profile can be run, please set up a PGP key for yourself using directions here [1], then add following code snippet in your private settings.xml file
{code}
<servers>
<server>
<id>oss.sonatype.org</id>
<username>{sona-type-user-name}</username>
<password>{sona-type-password}</password>
</server>
</servers>
<profiles>
<profile>
<id>teiid</id>
<properties>
<gpg.homedir>/home/rareddy/.gnupg</gpg.homedir>
<gpg.keyname>{pgp-key-name-generated}</gpg.keyname>
<gpg.passphrase>{key-password}</gpg.passphrase>
<gpg.executable>gpg</gpg.executable>
</properties>
</profile>
</profiles>
<activeProfiles>
<activeProfile>teiid</activeProfile>
</activeProfiles>
{code}
[1] http://central.sonatype.org/pages/working-with-pgp-signatures.html
> Push Teiid artifacts to maven central
> -------------------------------------
>
> Key: TEIID-4924
> URL: https://issues.jboss.org/browse/TEIID-4924
> Project: Teiid
> Issue Type: Sub-task
> Reporter: Kylin Soong
> Assignee: Ramesh Reddy
> Fix For: 10.0
>
>
> Prepare to push teiis-spring-boot to maven central.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 8 months