August 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2355) BigQuery integration

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-2355?page=com.atlassian.jira.plugin... ] Kylin Soong reassigned TEIID-2355: ---------------------------------- Assignee: Kylin Soong > BigQuery integration > -------------------- > > Key: TEIID-2355 > URL: https://issues.jboss.org/browse/TEIID-2355 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Kylin Soong > Fix For: Open To Community > > > http://code.google.com/p/starschema-bigquery-jdbc/ looks promising for simple support of BigQuery. Some of the dependencies could already be in the google-api module. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 4 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3077?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3077: --------------------------------------- Just to double check this is an issue with the dynamic vdb import, such that the date/pdate/tdate types should be mapped to timestamp? > 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-2881) Add support to use DSL when querying remote JDG 6.2

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2881?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-2881: ------------------------------- Assignee: Steven Hawkins (was: Van Halbert) > Add support to use DSL when querying remote JDG 6.2 > --------------------------------------------------- > > Key: TEIID-2881 > URL: https://issues.jboss.org/browse/TEIID-2881 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Add support for querying remote JDG 6.2 using DSL. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2881) Add support to use DSL when querying remote JDG 6.2

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2881?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-2881: ------------------------------------ I think this jira has been completed. The other jira: TEIID-2700, will cover the CRUD related changes. > Add support to use DSL when querying remote JDG 6.2 > --------------------------------------------------- > > Key: TEIID-2881 > URL: https://issues.jboss.org/browse/TEIID-2881 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Add support for querying remote JDG 6.2 using DSL. -- 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... ] Van Halbert resolved TEIID-3076. -------------------------------- Resolution: Done Committed changes to the 2.0 version of quick starts > 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... ] Van Halbert updated TEIID-3076: ------------------------------- Git Pull Request: https://github.com/teiid/teiid-quickstarts/pull/63 > 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 stopped 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-3049) odbc still commits with disableLocalTxn

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3049?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3049: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1129278 > odbc still commits with disableLocalTxn > --------------------------------------- > > Key: TEIID-3049 > URL: https://issues.jboss.org/browse/TEIID-3049 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: ODBC > Affects Versions: 8.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > With TEIID-2945 disableLocalTxn is now valid against odbc, but it is using an asynch invocation to commit which is not aware of disableLocalTxn which results in an exception that a transaction for the given session cannot be found. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

10 years, 5 months

1
0
0 / 0

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

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3077?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3077: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1129171|https://bugzilla.redhat.com/show_bug.cgi?id=1129171] from NEW to ASSIGNED > 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-3077) SOLR: Type date should be converted into Timestamp

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3077?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3077: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1129171 > 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

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2014