January 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2761) Enable/disable transport per model/view/virtual procedure

by Patrick Deenen (JIRA)

[ https://issues.jboss.org/browse/TEIID-2761?page=com.atlassian.jira.plugin... ] Patrick Deenen commented on TEIID-2761: --------------------------------------- [English further down] Geachte mevrouw, heer, Van 18-1-2014 t/m 26-1-2014 ben ik afwezig. Uw mail wordt niet doorgezonden naar een collega. Voor dringende zaken kunt u contact opnemen met Jordan van Est van Ciber Nederland op telefoonnummer +31(0)40-2329090. Dear Mrs. / Sir, I am out of the office from 18-1-2014 untill 26-1-2014. Your mail is not forwarded to a colleague. For urgent matters you can contact Jordan van Est of Ciber Nederland on phone number +31(0)40-2329090. Met vriendelijke groet / With kind regards, Patrick Deenen > Enable/disable transport per model/view/virtual procedure > --------------------------------------------------------- > > Key: TEIID-2761 > URL: https://issues.jboss.org/browse/TEIID-2761 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 8.5 > Reporter: Patrick Deenen > Assignee: Steven Hawkins > Fix For: 8.7 > > > It would be nice to be able to enable and disable access to models, tables, views or (virtual) procedures for a specific transport (JDBC, ODBC, OData, REST, Web services). > One may want to have access to virtual procedures only by Odata for example. -- 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-2761) Enable/disable transport per model/view/virtual procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2761?page=com.atlassian.jira.plugin... ] Work on TEIID-2761 started by Steven Hawkins. > Enable/disable transport per model/view/virtual procedure > --------------------------------------------------------- > > Key: TEIID-2761 > URL: https://issues.jboss.org/browse/TEIID-2761 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 8.5 > Reporter: Patrick Deenen > Assignee: Steven Hawkins > Fix For: 8.7 > > > It would be nice to be able to enable and disable access to models, tables, views or (virtual) procedures for a specific transport (JDBC, ODBC, OData, REST, Web services). > One may want to have access to virtual procedures only by Odata for example. -- 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-2700) Add CRUD support to Infinispan translator/connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2700?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2700: ---------------------------------- Assignee: (was: Steven Hawkins) > Add CRUD support to Infinispan translator/connector > --------------------------------------------------- > > Key: TEIID-2700 > URL: https://issues.jboss.org/browse/TEIID-2700 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 8.7 > > > Add CRUD support to the Infinispan translator/connector to work with JDG 6.2. -- 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-2802) HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2802?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2802. ----------------------------------- Fix Version/s: 8.7 Resolution: Done when group by and order by appear together the translator will remove the table qualifier from the order by column references > HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2 > ----------------------------------------------------------------------------------------- > > Key: TEIID-2802 > URL: https://issues.jboss.org/browse/TEIID-2802 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: TEIID with HIVE2 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > Fix For: 8.7 > > > If I tried to combine 2 tables from a same HIVE2 data source using UNION ALL, I got "Invalid table alias or column reference" error. > Query that I submitted to Teiid originally: > select "name" > from (Select * from hive2.opportunities_small UNION ALL Select * from > hive2.opportunities) "query" > group by "name" > order by "name" > Query that Teiid generated: > SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM > opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities > g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY v_0.c_0 > Error: > Invalid table alias or column reference 'v_0': (possible column names are: c_0) -- 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-2802) HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-2802?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-2802: ---------------------------------- Thanks! > HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2 > ----------------------------------------------------------------------------------------- > > Key: TEIID-2802 > URL: https://issues.jboss.org/browse/TEIID-2802 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: TEIID with HIVE2 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > > If I tried to combine 2 tables from a same HIVE2 data source using UNION ALL, I got "Invalid table alias or column reference" error. > Query that I submitted to Teiid originally: > select "name" > from (Select * from hive2.opportunities_small UNION ALL Select * from > hive2.opportunities) "query" > group by "name" > order by "name" > Query that Teiid generated: > SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM > opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities > g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY v_0.c_0 > Error: > Invalid table alias or column reference 'v_0': (possible column names are: c_0) -- 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-2802) HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2802?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2802: --------------------------------------- > However, the one that Teiid generated doesn't work. It is "ORDER BY v_0.c_0" instead of "ORDER BY c_0". Yes, I just wanted to confirm that simple column references in the order by clause would work with a group by. The fix is straightforward and will be committed shortly. > HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2 > ----------------------------------------------------------------------------------------- > > Key: TEIID-2802 > URL: https://issues.jboss.org/browse/TEIID-2802 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: TEIID with HIVE2 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > > If I tried to combine 2 tables from a same HIVE2 data source using UNION ALL, I got "Invalid table alias or column reference" error. > Query that I submitted to Teiid originally: > select "name" > from (Select * from hive2.opportunities_small UNION ALL Select * from > hive2.opportunities) "query" > group by "name" > order by "name" > Query that Teiid generated: > SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM > opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities > g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY v_0.c_0 > Error: > Invalid table alias or column reference 'v_0': (possible column names are: c_0) -- 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-2802) HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-2802?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-2802: ---------------------------------- This following SQL works: SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY c_0 However, the one that Teiid generated doesn't work. It is "ORDER BY v_0.c_0" instead of "ORDER BY c_0". Query that Teiid generated: SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY v_0.c_0 Original Query: select "name" from (Select * from hive2.opportunities_small UNION ALL Select * from hive2.opportunities) "query" group by "name" order by "name" > HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2 > ----------------------------------------------------------------------------------------- > > Key: TEIID-2802 > URL: https://issues.jboss.org/browse/TEIID-2802 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: TEIID with HIVE2 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > > If I tried to combine 2 tables from a same HIVE2 data source using UNION ALL, I got "Invalid table alias or column reference" error. > Query that I submitted to Teiid originally: > select "name" > from (Select * from hive2.opportunities_small UNION ALL Select * from > hive2.opportunities) "query" > group by "name" > order by "name" > Query that Teiid generated: > SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM > opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities > g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY v_0.c_0 > Error: > Invalid table alias or column reference 'v_0': (possible column names are: c_0) -- 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-2806) Accumulo Connector: Handling Authorizations with NULL value

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2806?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-2806: -------------------------------- Fix Version/s: 8.7 Assignee: Ramesh Reddy (was: Steven Hawkins) The metadata processor also not making use of NULL Authorizations all the time, thus user may not see all the tables in metadata. Chance of NPE with "table" instance as reported here https://community.jboss.org/message/853523?et=watches.email.thread#853523 > Accumulo Connector: Handling Authorizations with NULL value > ----------------------------------------------------------- > > Key: TEIID-2806 > URL: https://issues.jboss.org/browse/TEIID-2806 > Project: Teiid > Issue Type: Bug > Components: Connector API > Affects Versions: 8.7 > Reporter: devin pinkston > Assignee: Ramesh Reddy > Fix For: 8.7 > > > Currently the connector cannot handle null authorizations or roles left blank. -- 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-2729) Dynamic VDB xml requires sibling elements to be in a certain order

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2729?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2729: --------------------------------------- >From a first glance this is not possible as xs:all means that the elements can appear 0 or 1 times (at least until xsd 1.1). However we allow for unbounded property elements. I think this may have to be tabled for now. > Dynamic VDB xml requires sibling elements to be in a certain order > ------------------------------------------------------------------ > > Key: TEIID-2729 > URL: https://issues.jboss.org/browse/TEIID-2729 > Project: Teiid > Issue Type: Enhancement > Components: AdminApi > Affects Versions: 8.5 > Reporter: Mark Drilling > Assignee: Steven Hawkins > Fix For: 8.7 > > > In my *-vdb.xml, I have a model defined per following snippet: > <model name="myModel" type="PHYSICAL" visible="true"> > <source name="myModel" translator-name="hive" connection-jndi-name="Hive12Src" /> > <property name="trimColumnNames" value="true" /> > </model> > The vdb.xml failed to parse, so I moved the <property> element ahead of <source> and then it worked. > I don't think element ordering should matter in this case? -- 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-2807) Remove connector-template, replaced by teiid-tools connector-archetype

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2807?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2807: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > Remove connector-template, replaced by teiid-tools connector-archetype > ----------------------------------------------------------------------- > > Key: TEIID-2807 > URL: https://issues.jboss.org/browse/TEIID-2807 > Project: Teiid > Issue Type: Task > Components: Tools > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > Remove the connector-template project. The connector-archetype now provides the ability to generate a connector project. -- 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