January 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3788) Enable setting on JDG translator for controlling timezone setting for Date and Timestamp columns

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3788?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3788: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1275333|https://bugzilla.redhat.com/show_bug.cgi?id=1275333] from NEW to CLOSED > Enable setting on JDG translator for controlling timezone setting for Date and Timestamp columns > ------------------------------------------------------------------------------------------------ > > Key: TEIID-3788 > URL: https://issues.jboss.org/browse/TEIID-3788 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > > Timezone of DV server has influence on Date and Timestamp columns in some data sources -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3470) NPE in ConnectorWorkItem when using source hints

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3470?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3470. --------------------------------- > NPE in ConnectorWorkItem when using source hints > ------------------------------------------------ > > Key: TEIID-3470 > URL: https://issues.jboss.org/browse/TEIID-3470 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.5 > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11, 8.7.4 > > > When using a source general source hint in a query that uses multple sources, I get an NPE: > java.lang.NullPointerException > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.<init>(ConnectorWorkItem.java:141) > at org.teiid.dqp.internal.datamgr.ConnectorManager.registerRequest(ConnectorManager.java:203) > at org.teiid.dqp.internal.process.DataTierManagerImpl.registerRequest(DataTierManagerImpl.java:966) > at org.teiid.query.tempdata.TempTableDataManager.registerRequest(TempTableDataManager.java:179) > at org.teiid.query.processor.relational.AccessNode.registerRequest(AccessNode.java:475) > at org.teiid.query.processor.relational.AccessNode.open(AccessNode.java:248) > at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95) > 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.JoinStrategy.openLeft(JoinStrategy.java:95) > at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:145) > at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95) > at org.teiid.query.processor.relational.JoinNode.open(JoinNode.java:145) > at org.teiid.query.processor.relational.JoinStrategy.openLeft(JoinStrategy.java:95) > 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.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: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:298) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:483) > at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:175) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > 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.$Proxy14.executeRequest(Unknown Source) > at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) > at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3778) Mark hbase/phoenix as supporting limit

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3778?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3778. --------------------------------- > Mark hbase/phoenix as supporting limit > -------------------------------------- > > Key: TEIID-3778 > URL: https://issues.jboss.org/browse/TEIID-3778 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.11 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > The support for row limit should be added. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3742) out of range values not checked in sum aggregate

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3742?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3742. --------------------------------- > out of range values not checked in sum aggregate > ------------------------------------------------ > > Key: TEIID-3742 > URL: https://issues.jboss.org/browse/TEIID-3742 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > The sum aggregate may overflow, so there should be an explicit check. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3622) HBase translator - INSERT could rewrite the data

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3622?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3622. --------------------------------- > HBase translator - INSERT could rewrite the data > ------------------------------------------------ > > Key: TEIID-3622 > URL: https://issues.jboss.org/browse/TEIID-3622 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12 > > > The HBase translator translates INSERT as UPSERT, which is an "alias" for both INSERT and UPDATE statement. It means, if user issues same INSERT statement twice, no exception is thrown [1]. I expect that [2] could rewrite the data. > *Additional note*: I was not able to verify my assumption because of https://issues.jboss.org/browse/TEIID-3619 > [1] > INSERT INTO smalla (intkey) VALUES (55) is translated as UPSERT INTO smalla (intkey) VALUES (55) > http://phoenix.apache.org/language/index.html#upsert_values > [2] > INSERT INTO smalla (intkey, name) VALUES (1, 'name1') > INSERT INTO smalla (intkey, name) VALUES (1, 'name2') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3310) Nesting aliases that match the engine recontext logic can lead to naming conflicts

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3310?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3310. --------------------------------- > Nesting aliases that match the engine recontext logic can lead to naming conflicts > ---------------------------------------------------------------------------------- > > Key: TEIID-3310 > URL: https://issues.jboss.org/browse/TEIID-3310 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > A query such as: > select (select e4 from pm1.g1 X__1), pm1.g1.e2 from pm1.g1, /*+ makeind */ (select e1 from pm2.g1) AS X__1, (select distinct e2, e3 from pm3.g1) X__2 where pm1.g1.e3 = X__1.e1 and pm1.g1.e2 = year(X__2.e3) > Will fail to process correctly as the X__1 and X__2 aliases are already in use, which will cause an AssertionError during processing attempting to reference X__1.e1. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3716) Error joining file data sources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3716?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3716. --------------------------------- > Error joining file data sources > ------------------------------- > > Key: TEIID-3716 > URL: https://issues.jboss.org/browse/TEIID-3716 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.12 > > > I have defined a file data source in the VDB and I am running a query that joins a CSV file to another relation (a relational table or a subquery like in the following example). > Two different exceptions are thrown if a INNER or LEFT OUTER JOIN is used: > {code:sql} > SELECT > csv_table.* > FROM > (call f1.getFiles('csvFile.csv')) f, > TEXTTABLE(to_chars(f.file,'UTF-8') > COLUMNS > "a" STRING , > "b" STRING > DELIMITER ',' > QUOTE '''' > SKIP 1 > ) csv_table > LEFT JOIN (SELECT '1' as a, '2' as b) as t ON csv_table.a = t.a; > {code} > {code:sql} > 16:30:25,220 ERROR [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue278) 49Wb3t6yP73K TEIID30019 Unexpected exception for request 49Wb3t6yP73K.16: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate f.file: No value was available > at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:501) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:705) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:680) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:93) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.SourceState.prefetch(SourceState.java:211) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.JoinNode.prefetch(JoinNode.java:247) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:239) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:102) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:462) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:344) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67] > {code} > If INNER JOIN is used: > {code:sql} > SELECT > csv_table.* > FROM > (call f1.getFiles('csvFile.csv')) f, > TEXTTABLE(to_chars(f.file,'UTF-8') > COLUMNS > "a" STRING , > "b" STRING > DELIMITER ',' > QUOTE '''' > SKIP 1 > ) csv_table > JOIN (SELECT '1' as a, '2' as b) as t ON csv_table.a = t.a; > {code} > the following exception is thrown: > {code:sql} > 16:32:18,260 ERROR [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue281) 49Wb3t6yP73K TEIID30019 Unexpected exception for request 49Wb3t6yP73K.18: java.lang.AssertionError: Cannot use a depenedent join when the join involves a correlated nested table. > at org.teiid.query.optimizer.relational.rules.RuleImplementJoinStrategy.execute(RuleImplementJoinStrategy.java:88) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:792) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:223) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:434) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.Request.processRequest(Request.java:461) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:632) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:333) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:271) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.0.Beta3.jar:8.12.0.Beta3] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67] > {code} > It seems that the structure of the CSV file is not relevant since this issue can be reproduced even providing a file that does not exist. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3762) OData V2: $value on property is not supported

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3762?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3762: ---------------------------------- Fix Version/s: 8.13 > OData V2: $value on property is not supported > --------------------------------------------- > > Key: TEIID-3762 > URL: https://issues.jboss.org/browse/TEIID-3762 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.12.1, 8.13 > > > A raw property value can be retrieved using the $value segment, like > {code} > http://localhost:8080/odata/vdb/table/property/$value > {code} > This should be suported, or should throw a proper error -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3783) Error when limit/sort is pushed above a window function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3783?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3783. --------------------------------- > Error when limit/sort is pushed above a window function > ------------------------------------------------------- > > Key: TEIID-3783 > URL: https://issues.jboss.org/browse/TEIID-3783 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13 > > > TEIID-3568 introduced a regression by pushing a sort over a project node, but not accounting for aliases. This can be reproduced with a query such as: > select column_a, column_b from (select sum(column_a) over (partition by key_column) as column_a, key_column from a ) a left outer join ( select sum(column_b) over (partition by key_column) as column_b, key_column from b) b on a.key_column = b.key_column order by column_a desc limit 10 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3362) Additional language constructs for arrays

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3362?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3362. --------------------------------- > Additional language constructs for arrays > ----------------------------------------- > > Key: TEIID-3362 > URL: https://issues.jboss.org/browse/TEIID-3362 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > Additional handling for arrays, such as an unnest function (columns to rows), a 2 dimensional form or arraytable, array concat etc. would be beneficial. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2016