August 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3077) SOLR: Type date should be converted into Timestamp

by Filip Elias (JIRA)

Filip Elias created TEIID-3077: ---------------------------------- Summary: SOLR: Type date should be converted into Timestamp Key: TEIID-3077 URL: https://issues.jboss.org/browse/TEIID-3077 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: Misc. Connectors Affects Versions: 8.7 Reporter: Filip Elias Assignee: Steven Hawkins SOLR translator converts solr's date type into java.sql.Date, but SOLR's date format is rather timestamp[1]. When the solr's date is converted into java.sql.Date, the information about hours,minutes and seconds will be lost. [1] "TimestampValue": "1999-12-31T23:00:00Z", -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3076) Add materialized view to data-federation quick start

by Van Halbert (JIRA)

Van Halbert created TEIID-3076: ---------------------------------- Summary: Add materialized view to data-federation quick start Key: TEIID-3076 URL: https://issues.jboss.org/browse/TEIID-3076 Project: Teiid Issue Type: Enhancement Security Level: Public (Everyone can see) Components: Quick Starts Reporter: Van Halbert Assignee: Van Halbert Priority: Minor Adding the following materialized view to the portfolio VDB to materialized the stocks view to TTL of 2 minutes: CREATE view stockPricesMatView ( product_id integer, symbol string, price bigdecimal, company_name varchar(256) ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE', MATERIALIZED_TABLE 'Accounts.h2_stock_mat', "teiid_rel:MATVIEW_TTL" 120000, "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute accounts.native(''truncate table h2_stock_mat'');', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native('''')', "teiid_rel:ON_VDB_DROP_SCRIPT" 'DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''', "teiid_rel:MATERIALIZED_STAGE_TABLE" 'Accounts.h2_stock_mat', "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', "teiid_rel:MATVIEW_STATUS_TABLE" 'status', "teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE', "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION') AS SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME FROM Stocks.StockPrices AS S, Accounts.PRODUCT AS A WHERE S.symbol = A.SYMBOL; -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3076) Add materialized view to data-federation quick start

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3076?page=com.atlassian.jira.plugin... ] Work on TEIID-3076 started by Van Halbert. > Add materialized view to data-federation quick start > ---------------------------------------------------- > > Key: TEIID-3076 > URL: https://issues.jboss.org/browse/TEIID-3076 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Quick Starts > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > Adding the following materialized view to the portfolio VDB to materialized the stocks view to TTL of 2 minutes: > CREATE view stockPricesMatView > ( > product_id integer, > symbol string, > price bigdecimal, > company_name varchar(256) > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE', > MATERIALIZED_TABLE 'Accounts.h2_stock_mat', > "teiid_rel:MATVIEW_TTL" 120000, > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute accounts.native(''truncate table h2_stock_mat'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native('''')', > "teiid_rel:ON_VDB_DROP_SCRIPT" 'DELETE FROM Accounts.status WHERE Name=''stock'' AND schemaname = ''Stocks''', > "teiid_rel:MATERIALIZED_STAGE_TABLE" 'Accounts.h2_stock_mat', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'status', > "teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION') > AS SELECT A.ID, S.symbol, S.price, A.COMPANY_NAME > FROM Stocks.StockPrices AS S, Accounts.PRODUCT AS A > WHERE S.symbol = A.SYMBOL; -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3069) Quick Start Can't run against JDV

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3069?page=com.atlassian.jira.plugin... ] Van Halbert closed TEIID-3069. ------------------------------ Resolution: Rejected > Quick Start Can't run against JDV > --------------------------------- > > Key: TEIID-3069 > URL: https://issues.jboss.org/browse/TEIID-3069 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Quick Starts > Environment: JBoss Data Virtualization 6.0 > JBoss Data Virtualization 6.1 > Reporter: Kylin Soong > Assignee: Van Halbert > > Some Quick Start can't run well against Enterprise JDV, can we have a JDV version quick start? -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3075) OSGi bundle versions hardcoded

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3075?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-3075: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > OSGi bundle versions hardcoded > ------------------------------ > > Key: TEIID-3075 > URL: https://issues.jboss.org/browse/TEIID-3075 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Build/Kits > Affects Versions: 8.7.1 > Reporter: Julian Coleman > Assignee: Ramesh Reddy > Priority: Minor > > The file: > build/kits/karaf/teiid-karaf-features.xml > contains hard-coded versions of some dependencies. For example: > <bundle>wrap:mvn:org.apache.lucene/lucene-core/3.6.2</bundle> > <bundle>mvn:org.infinispan/infinispan-query/5.2.1.Final</bundle> > These should be replaced by the appropriate properties. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3075) OSGi bundle versions hardcoded

by Julian Coleman (JIRA)

Julian Coleman created TEIID-3075: ------------------------------------- Summary: OSGi bundle versions hardcoded Key: TEIID-3075 URL: https://issues.jboss.org/browse/TEIID-3075 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: Build/Kits Affects Versions: 8.7.1 Reporter: Julian Coleman Assignee: Steven Hawkins Priority: Minor The file: build/kits/karaf/teiid-karaf-features.xml contains hard-coded versions of some dependencies. For example: <bundle>wrap:mvn:org.apache.lucene/lucene-core/3.6.2</bundle> <bundle>mvn:org.infinispan/infinispan-query/5.2.1.Final</bundle> These should be replaced by the appropriate properties. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3069) Quick Start Can't run against JDV

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3069?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-3069: ------------------------------------ I have looked the https://issues.jboss.org/browse/JBEAP-60, not only Windows, Linux also has that kind of issue. I tested with JDV 6.1.0.DR2, it be solved in EAP 6.3 now. I think we can close this issue. > Quick Start Can't run against JDV > --------------------------------- > > Key: TEIID-3069 > URL: https://issues.jboss.org/browse/TEIID-3069 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Quick Starts > Environment: JBoss Data Virtualization 6.0 > JBoss Data Virtualization 6.1 > Reporter: Kylin Soong > Assignee: Van Halbert > > Some Quick Start can't run well against Enterprise JDV, can we have a JDV version quick start? -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3074) NPE When using External Materialization management is use

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3074?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3074: ------------------------------------- In debug I see close() is coming before next() some times thus the error > NPE When using External Materialization management is use > --------------------------------------------------------- > > Key: TEIID-3074 > URL: https://issues.jboss.org/browse/TEIID-3074 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.5 > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Attachments: debug_plan.txt, solr-integration-with-matview-vdb.xml > > > When I was issuing query that has externalized materialization with management option to true, I am seeing NPE. Tried to see why NPE is occurring was not able to figure out (yet) > {code} > 14:37:50,269 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8477) 0z97J5OWq7x9 Connector worker process failed for atomic-request=0z97J5OWq7x9.7.1.4220: java.lang.NullPointerException > at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:338) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:385) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:203) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_65] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_65] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_65] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_65] > {code} -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3067) External Materialization Management Issues

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3067?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3067: ------------------------------------- I think I saw unwanted behavior when I did not specify the TTL, this needs to verified once more or may be related with TEIID-3074. Will resolve once I verify it. > External Materialization Management Issues > ------------------------------------------ > > Key: TEIID-3067 > URL: https://issues.jboss.org/browse/TEIID-3067 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.5 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.7.1, 8.9 > > > Couple issues > 1) Based on https://docs.jboss.org/author/display/TEIID/External+Materialization document, the property teiid_rel:MATVIEW_STAGE_TABLE needs to be optional, however it is been coded as required. > 2) If an exception occurs during the loadMatview, the status table is set to "FailedLoad" however the exception is not logged to know the source of the issue. This needs to logged. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3074) NPE When using External Materialization management is use

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3074?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-3074: -------------------------------- Attachment: debug_plan.txt solr-integration-with-matview-vdb.xml > NPE When using External Materialization management is use > --------------------------------------------------------- > > Key: TEIID-3074 > URL: https://issues.jboss.org/browse/TEIID-3074 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.5 > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Attachments: debug_plan.txt, solr-integration-with-matview-vdb.xml > > > When I was issuing query that has externalized materialization with management option to true, I am seeing NPE. Tried to see why NPE is occurring was not able to figure out (yet) > {code} > 14:37:50,269 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8477) 0z97J5OWq7x9 Connector worker process failed for atomic-request=0z97J5OWq7x9.7.1.4220: java.lang.NullPointerException > at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:338) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:385) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:203) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:301) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_65] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.9.0.Alpha1-SNAPSHOT.jar:8.9.0.Alpha1-SNAPSHOT] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_65] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_65] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_65] > {code} -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2014