January 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2817) XML Modeling Lab 7 and runtime errors on DV 6.0 Beta

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2817?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2817. ----------------------------------- Assignee: Steven Hawkins Resolution: Done The issue here is that we expected designer to use the old style positional metadata for input set bindings if the input keyword was used. Instead input was used here as a named binding and that resulted in the runtime error. I've addressed on the teiid side by assuming that named bindings can be either input or inputs. > XML Modeling Lab 7 and runtime errors on DV 6.0 Beta > ---------------------------------------------------- > > Key: TEIID-2817 > URL: https://issues.jboss.org/browse/TEIID-2817 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Gary Lamperillo > Assignee: Steven Hawkins > Fix For: 8.7 > > Attachments: Financial_VDB.vdb > > > The XML schema is imported and the modeling is completed per the Lab on XML modeling. At runtime, during VDB execution, the sql scrap pad has the sql entered - select * from CustomerHoldingsXML.CustomersDocument > At this point the following error is displayed: > TEIID30328 Unable to evaluate "INPUT".AccountID: No value was available > The VDB will be attached per Steven Hawkins request. -- 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, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2817) XML Modeling Lab 7 and runtime errors on DV 6.0 Beta

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2817?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2817: ---------------------------------- Fix Version/s: 8.7 Workaround Description: Use INPUTS instead of INPUT Workaround: Workaround Exists Component/s: Query Engine For backwards compatibility Teiid is still allowing INPUT to be used as the qualify - however it is not appropriately then substituting the appropriate symbol reference. > XML Modeling Lab 7 and runtime errors on DV 6.0 Beta > ---------------------------------------------------- > > Key: TEIID-2817 > URL: https://issues.jboss.org/browse/TEIID-2817 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Gary Lamperillo > Fix For: 8.7 > > Attachments: Financial_VDB.vdb > > > The XML schema is imported and the modeling is completed per the Lab on XML modeling. At runtime, during VDB execution, the sql scrap pad has the sql entered - select * from CustomerHoldingsXML.CustomersDocument > At this point the following error is displayed: > TEIID30328 Unable to evaluate "INPUT".AccountID: No value was available > The VDB will be attached per Steven Hawkins request. -- 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, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2817) XML Modeling Lab 7 and runtime errors on DV 6.0 Beta

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2817?page=com.atlassian.jira.plugin... ] Steven Hawkins moved TEIIDDES-2035 to TEIID-2817: ------------------------------------------------- Project: Teiid (was: Teiid Designer) Key: TEIID-2817 (was: TEIIDDES-2035) Affects Version/s: 8.4 (was: 8.3.1) > XML Modeling Lab 7 and runtime errors on DV 6.0 Beta > ---------------------------------------------------- > > Key: TEIID-2817 > URL: https://issues.jboss.org/browse/TEIID-2817 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.4 > Reporter: Gary Lamperillo > Attachments: Financial_VDB.vdb > > > The XML schema is imported and the modeling is completed per the Lab on XML modeling. At runtime, during VDB execution, the sql scrap pad has the sql entered - select * from CustomerHoldingsXML.CustomersDocument > At this point the following error is displayed: > TEIID30328 Unable to evaluate "INPUT".AccountID: No value was available > The VDB will be attached per Steven Hawkins request. -- 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, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1632?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1632: --------------------------------------- > Just an observation from my first use, I'm not a fan of it. It's all a matter of perspective. One could equally assert that littering your procedure or java code with System.outs is not a great idea. At worst you have to go back and remove them and/or convert them into proper logging statements. Perhaps your requirement is for a simpler way to control logging or to have a default logger (org.teiid.console or whatever name makes sense) configured that is already routed to the console: CALL logMsg(msg=>'foo' context=>'org.teiid.console') > Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic > ----------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1632 > URL: https://issues.jboss.org/browse/TEIID-1632 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 7.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 7.4.1, 7.5 > > > Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic -- 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, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2816) HBase Connector/Translator

by devin pinkston (JIRA)

devin pinkston created TEIID-2816: ------------------------------------- Summary: HBase Connector/Translator Key: TEIID-2816 URL: https://issues.jboss.org/browse/TEIID-2816 Project: Teiid Issue Type: Feature Request Components: Connector API, JDBC Connector, JDBC Driver Affects Versions: Open To Community Reporter: devin pinkston Assignee: Steven Hawkins Develop a HBase translator/connector. Potentially using the Phoenix JDBC driver, supports most SQL and handles connections: https://github.com/forcedotcom/phoenix -- 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, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1632) Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-1632?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-1632: ------------------------------------ Just an observation from my first use, I'm not a fan of it. All I want was to do is output to the console. But in order to get logging to work, I now have to turn on some other logging just to get a statement out. It's all well and good, if I'm adding statements that will remain as part of standard logging. Having to turn on logging defeats the easiness of just writing to System.out. Just my opinion on easy of use. > Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic > ----------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1632 > URL: https://issues.jboss.org/browse/TEIID-1632 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 7.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 7.4.1, 7.5 > > > Provide something like an ECHO statement in the procedure language that can assist a user in debugging their procedure logic -- 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, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2815) Need to add the aggregate functions to list of supported functions, for Designer to expose for the user

by Van Halbert (JIRA)

Van Halbert created TEIID-2815: ---------------------------------- Summary: Need to add the aggregate functions to list of supported functions, for Designer to expose for the user Key: TEIID-2815 URL: https://issues.jboss.org/browse/TEIID-2815 Project: Teiid Issue Type: Enhancement Components: Server Affects Versions: 8.4.1 Reporter: Van Halbert Assignee: Steven Hawkins Need to add to the list, of known supported functions, what are all the aggregate functions that are supported. This list is what Teiid Designer would expose to the user for modeling purposes. -- 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, 11 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2814?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2814. ----------------------------------- Fix Version/s: 8.7 Resolution: Done Added single quotes around the time, date, timestamp literals as hive supports automatic conversion of the respective string literals to the timestamp/date values. > 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.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, 11 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2814?page=com.atlassian.jira.plugin... ] Work on TEIID-2814 started by Steven Hawkins. > 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 > > 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, 11 months

1
0
0 / 0

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

by Ivan Chan (JIRA)

Ivan Chan created TEIID-2814: -------------------------------- Summary: 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 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, 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 2014