March 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2814) HIVE: quote is removed for TIMESTAMP field in where clause

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2814?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2814: ------------------------------------------------ Filip Nguyen <fnguyen(a)redhat.com> changed the Status of [bug 1058084|https://bugzilla.redhat.com/show_bug.cgi?id=1058084] from ON_QA to VERIFIED > HIVE: quote is removed for TIMESTAMP field in where clause > ----------------------------------------------------------- > > Key: TEIID-2814 > URL: https://issues.jboss.org/browse/TEIID-2814 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: HIVE and Teiid 8.6 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > Fix For: 8.4.2, 8.7 > > > I am running teiid 8.6 against HIVE. And I found out that quote was removed for TIMESTAMP field in where clause. And it caused java.sql.SQLException: Error while processing statement: FAILED: ParseException line 1:88 missing EOF > Original SQL: > select "the_date", > "store_sales" > from "hive2"."sales_seq" > where ("the_date" > '1970-05-16 00:10:04') > Teiid generated SQL: > SELECT g_0.the_date, g_0.store_sales FROM sales_seq g_0 WHERE g_0.the_date > 1970-05-16 00:10:04.0 > Exception: > Caused by: java.sql.SQLException: Error while processing statement: FAILED: > ParseException line 1:88 missing EOF at '00' near '16' -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2905) Allow selector to be used with fixed width

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2905: ------------------------------------- Summary: Allow selector to be used with fixed width Key: TEIID-2905 URL: https://issues.jboss.org/browse/TEIID-2905 Project: Teiid Issue Type: Feature Request Components: Query Engine Reporter: Van Halbert Assignee: Steven Hawkins Fix For: 8.7 To allow for fixed width files containing multiple record types, the selector functionality should apply to fixed width as well. At least initially this will be restricted to only the overall selector as positional selector column references won't be possible. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2904) Expose "import" and "extension-metadata" Translator Properties through Admin API

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-2904: ----------------------------------- Summary: Expose "import" and "extension-metadata" Translator Properties through Admin API Key: TEIID-2904 URL: https://issues.jboss.org/browse/TEIID-2904 Project: Teiid Issue Type: Enhancement Components: AdminApi Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.7 Currently only "override" translator properties are exposed through Admin API. Teiid should also expose * import properties * extension metadata proeprties for tooling purposes. Right now Teiid Connection importer in Designer, a user has to manually enter these values. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2900) ASSERTION FAILED with UNION

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2900?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2900. ----------------------------------- Labels: assertionfailedexception (was: 8.7 assertionfailedexception union) Fix Version/s: 8.7 Resolution: Done Rewrote the truncateTo method to be clearer and to account for the rows that have been removed in the batchBuffer. > ASSERTION FAILED with UNION > --------------------------- > > Key: TEIID-2900 > URL: https://issues.jboss.org/browse/TEIID-2900 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: assertionfailedexception > Fix For: 8.7 > > Attachments: TestTranslator.zip > > > This is reproducible in Teiid 8.7 beta2 from the downloads page, and in 8.7 beta3 built from GIT master. > foo has >1000 rows. bar has 28 rows. Playing with the limit, it's possible to get the query to work. > {code} > <model name="foo"> > <source name="foo" translator-name="custom" connection-jndi-name="java:/FooDS"/> > </model> > <model name="bar"> > <source name="bar" translator-name="custom" connection-jndi-name="java:/BarDS"/> > </model> > {code} > {code:sql} > select * from ( > (select identifier from foo.items) > union all > (select identifier from bar.items) > ) x > order by identifier desc > limit 1000; > {code} > {code} > 11:15:32,992 DEBUG [org.teiid.COMMAND_LOG] (New I/O worker #1) Nqu3TY8Cd+7P START USER COMMAND: startTime=2014-03-18 11:15:32.992 requestID=Nqu3TY8Cd+7P.0 txID=null sessionID=Nqu3TY8Cd+7P applicationName=JDBCprincipal=user@teiid-security vdbName=Foo vdbVersion=1 sql=select * from ( > (select identifier from foo.items) > union all > (select identifier from bar.items) > ) x > order by identifier desc > limit 1000 > 11:15:33,106 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) Nqu3TY8Cd+7P START DATA SRC COMMAND: startTime=2014-03-18 11:15:33.106 requestID=Nqu3TY8Cd+7P.0 sourceCommandID=4 executionID=0 txID=null modelName=foo translatorName=foo sessionID=Nqu3TY8Cd+7P principal=user@teiid-security sql=SELECT foo.items.identifier FROM foo.items ORDER BY foo.items.identifier DESC LIMIT 1000 > 11:15:33,106 DEBUG [org.teiid.COMMAND_LOG] (Worker2_QueryProcessorQueue2) Nqu3TY8Cd+7P START DATA SRC COMMAND: startTime=2014-03-18 11:15:33.106 requestID=Nqu3TY8Cd+7P.0 sourceCommandID=6 executionID=1 txID=null modelName=bar translatorName=foo sessionID=Nqu3TY8Cd+7P principal=user@teiid-security sql=SELECT bar.items.identifier FROM bar.items ORDER BY bar.items.identifier DESC LIMIT 1000 > 11:15:33,154 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue3) Nqu3TY8Cd+7P END SRC COMMAND: endTime=2014-03-18 11:15:33.154 requestID=Nqu3TY8Cd+7P.0 sourceCommandID=6 executionID=1 txID=null modelName=bar translatorName=foo sessionID=Nqu3TY8Cd+7P principal=user@teiid-security finalRowCount=28 > 11:15:33,553 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue4) Nqu3TY8Cd+7P END SRC COMMAND: endTime=2014-03-18 11:15:33.553 requestID=Nqu3TY8Cd+7P.0 sourceCommandID=4 executionID=0 txID=null modelName=foo translatorName=foo sessionID=Nqu3TY8Cd+7P principal=user@teiid-security finalRowCount=1000 > 11:15:33,567 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue4) Nqu3TY8Cd+7P ERROR USER COMMAND: endTime=2014-03-18 11:15:33.567 requestID=Nqu3TY8Cd+7P.0 txID=null sessionID=Nqu3TY8Cd+7P principal=user@teiid-security vdbName=Foo vdbVersion=1 finalRowCount=null > 11:15:33,568 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue4) Nqu3TY8Cd+7P TEIID30019 Unexpected exception for request Nqu3TY8Cd+7P.0: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null > at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100) [teiid-common-core-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92) [teiid-common-core-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.common.buffer.TupleBuffer.getBatch(TupleBuffer.java:287) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.common.buffer.TupleBuffer.truncateTo(TupleBuffer.java:425) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:117) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.query.processor.relational.SortNode.getBuffer(SortNode.java:205) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.query.processor.relational.LimitNode.getBuffer(LimitNode.java:211) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:250) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:289) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:149) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.7.0.Beta2.jar:8.7.0.Beta2] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_02] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_02] > at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_02] > {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2903?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2903. ----------------------------------- Fix Version/s: 8.7 Resolution: Done Corrected the metadata retrieval to include the columns. > Dynamic VDB with Google Spreadsheet source - no metadata > --------------------------------------------------------- > > Key: TEIID-2903 > URL: https://issues.jboss.org/browse/TEIID-2903 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Steven Hawkins > Fix For: 8.7 > > > Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: > 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel > According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." > No metadata is returned. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2903?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2903: --------------------------------------- Yes, there is an issue here. We are getting the column metadata, but not returning it for use by the getMetadata logic. > Dynamic VDB with Google Spreadsheet source - no metadata > --------------------------------------------------------- > > Key: TEIID-2903 > URL: https://issues.jboss.org/browse/TEIID-2903 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Steven Hawkins > > Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: > 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel > According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." > No metadata is returned. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2770) Imported vdbs have their roles added to the actual instance of the importing vdb

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2770?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2770: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1062245|https://bugzilla.redhat.com/show_bug.cgi?id=1062245] from ON_QA to VERIFIED > Imported vdbs have their roles added to the actual instance of the importing vdb > -------------------------------------------------------------------------------- > > Key: TEIID-2770 > URL: https://issues.jboss.org/browse/TEIID-2770 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6, 8.4.2 > > > Imported roles should be stored on a new instance of the role map on the merged vdb instance, not on the original vdb. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Mark Drilling (JIRA)

[ https://issues.jboss.org/browse/TEIID-2903?page=com.atlassian.jira.plugin... ] Mark Drilling commented on TEIID-2903: -------------------------------------- Yes I had created a test sheet with 2 columns. The dynamic VDB does not return metadata, but if I manually model in designer I can preview the data. > Dynamic VDB with Google Spreadsheet source - no metadata > --------------------------------------------------------- > > Key: TEIID-2903 > URL: https://issues.jboss.org/browse/TEIID-2903 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Steven Hawkins > > Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: > 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel > According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." > No metadata is returned. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2903?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2903: --------------------------------------- Do you have any worksheets with actual columns? > Dynamic VDB with Google Spreadsheet source - no metadata > --------------------------------------------------------- > > Key: TEIID-2903 > URL: https://issues.jboss.org/browse/TEIID-2903 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Steven Hawkins > > Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: > 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel > According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." > No metadata is returned. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Mark Drilling (JIRA)

Mark Drilling created TEIID-2903: ------------------------------------ Summary: Dynamic VDB with Google Spreadsheet source - no metadata Key: TEIID-2903 URL: https://issues.jboss.org/browse/TEIID-2903 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.4 Reporter: Mark Drilling Assignee: Steven Hawkins Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." No metadata is returned. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2014