October 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2695?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-2695: ------------------------------------ I logged for each of the following users, and each came back false. user - SELECT hasRole('prices') or SELECT hasRole('user') and portfolio = SELECT hasRole('superuser') > Unable to use CASE statement in Select > -------------------------------------- > > Key: TEIID-2695 > URL: https://issues.jboss.org/browse/TEIID-2695 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Trying to add a <mask> of: > <permission> > <resource-name>Stocks.StockPrices.Price</resource-name> > <mask>CASE WHEN hasRole('prices') THEN Price END</mask> > </permission> > even tried using "= true" just to see > but it it always returns null for Prices. > To test it, I logged in as 'user' using CommandLog vdb and issued: > Select VDB, CASE WHEN hasRole('prices') THEN 'Y' Else 'N' END as V from TEIID_COMMANDLOG > and 'N' was always returned for column V. > teiid roles file: > # A roles.properties file for use with the UsersRolesLoginModule > # username=role1,role2 > portfolio=superuser > viewonly=readonly > user=user,prices -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2695?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2695: --------------------------------------- Just to make sure I'm not confused, are you saying that something seems amiss with CASE, or is hasRole not meeting your expectation? For example just issue "SELECT hasRole('prices')" > Unable to use CASE statement in Select > -------------------------------------- > > Key: TEIID-2695 > URL: https://issues.jboss.org/browse/TEIID-2695 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Trying to add a <mask> of: > <permission> > <resource-name>Stocks.StockPrices.Price</resource-name> > <mask>CASE WHEN hasRole('prices') THEN Price END</mask> > </permission> > even tried using "= true" just to see > but it it always returns null for Prices. > To test it, I logged in as 'user' using CommandLog vdb and issued: > Select VDB, CASE WHEN hasRole('prices') THEN 'Y' Else 'N' END as V from TEIID_COMMANDLOG > and 'N' was always returned for column V. > teiid roles file: > # A roles.properties file for use with the UsersRolesLoginModule > # username=role1,role2 > portfolio=superuser > viewonly=readonly > user=user,prices -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select

by Van Halbert (JIRA)

Van Halbert created TEIID-2695: ---------------------------------- Summary: Unable to use CASE statement in Select Key: TEIID-2695 URL: https://issues.jboss.org/browse/TEIID-2695 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.4.1 Reporter: Van Halbert Assignee: Steven Hawkins Trying to add a <mask> of: <permission> <resource-name>Stocks.StockPrices.Price</resource-name> <mask>CASE WHEN hasRole('prices') THEN Price END</mask> </permission> even tried using "= true" just to see but it it always returns null for Prices. To test it, I logged in as 'user' using CommandLog vdb and issued: Select VDB, CASE WHEN hasRole('prices') THEN 'Y' Else 'N' END as V from TEIID_COMMANDLOG and 'N' was always returned for column V. teiid roles file: # A roles.properties file for use with the UsersRolesLoginModule # username=role1,role2 portfolio=superuser viewonly=readonly user=user,prices -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2406) Quickstart to demonstrate custom database appender logger

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2406?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-2406. -------------------------------- Resolution: Done Quick start added and documentation updated. > Quickstart to demonstrate custom database appender logger > --------------------------------------------------------- > > Key: TEIID-2406 > URL: https://issues.jboss.org/browse/TEIID-2406 > Project: Teiid > Issue Type: Feature Request > Components: Build/Kits > Affects Versions: 8.3 > Reporter: Van Halbert > Assignee: Van Halbert > -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2694) Support for Blob Input in Teiid REST services

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2694?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2694: --------------------------------------- Seems like we should do some general tweaking of the parameter handling in general. Ramesh is there a reason to hard code the parameters as String type rather than the java type corresponding to the Teiid type or just Object type? It looks like the MultipartForm example from http://www.mkyong.com/webservices/jax-rs/file-upload-example-in-resteasy/ would allow Blob/Clob/XML inputs to be represented as a class, but a new one would need to be generated potentially for every use as an annotation is needed to match the parameter name. > Support for Blob Input in Teiid REST services > --------------------------------------------- > > Key: TEIID-2694 > URL: https://issues.jboss.org/browse/TEIID-2694 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.5 > Environment: EAP 6.1 Alpha , Teiid 8.5 > Reporter: Madhu Garimilla > Assignee: Steven Hawkins > > We are trying to upload large files as Blobs using Teiid REST service through VDB. Though we are writing the Blob objects to HttpUrlConnection object, it is not received on REST method. As per the conversation in the thread "https://community.jboss.org/thread/232840" Current parameter handling is done through strings and needs be enhanced to support Blob objects. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2674) Makedep not honored with aggregate decomposition

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2674?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2674. ----------------------------------- Fix Version/s: 8.6 Resolution: Done Added checks to look below grouping nodes (which can only be the case after pushing aggregates) when looking for dependent hints. > Makedep not honored with aggregate decomposition > ------------------------------------------------ > > Key: TEIID-2674 > URL: https://issues.jboss.org/browse/TEIID-2674 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6 > > > A makedep hint on a joined table under aggregation for a source that does not support the grouping will result in the makedep hint being ignored - for example where pm1 does not support join/aggregation: > select count(x.e2), e1 from pm1.g1 x makedep, pm1.g2 where x.e3 = pm1.g2.e3 group by e1 -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2665) Hive translator pushdown improvements

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2665?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2665: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1016111|https://bugzilla.redhat.com/show_bug.cgi?id=1016111] from ASSIGNED to MODIFIED > Hive translator pushdown improvements > ------------------------------------- > > Key: TEIID-2665 > URL: https://issues.jboss.org/browse/TEIID-2665 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: Alpha2 > Fix For: 8.4.1, 8.6 > > > - Hive 0.11 windowing functions: push down > - Native Queries support > - Test multi-source bindings with Hive Partition Tables - each binding to a discrete partition table > - validate that off-heap buffer management can be used with very large data sets from Hadoop/Hive -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2683) Proactive eviction of new batches reduces forward-only performance

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2683?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2683: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1015232|https://bugzilla.redhat.com/show_bug.cgi?id=1015232] from ASSIGNED to MODIFIED > Proactive eviction of new batches reduces forward-only performance > ------------------------------------------------------------------ > > Key: TEIID-2683 > URL: https://issues.jboss.org/browse/TEIID-2683 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.6 > > > With TEIID-2429 to improve performance under heavy buffer load the cleaner was made more proactive in evicting new batches. In streaming scenarios this results in a lot of unnecessary buffering as the batches are likely to be held only for a short time. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2683) Proactive eviction of new batches reduces forward-only performance

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2683?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2683. ----------------------------------- Resolution: Done Marking as resolved from local multi-batch forward only processing tests. > Proactive eviction of new batches reduces forward-only performance > ------------------------------------------------------------------ > > Key: TEIID-2683 > URL: https://issues.jboss.org/browse/TEIID-2683 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.6 > > > With TEIID-2429 to improve performance under heavy buffer load the cleaner was made more proactive in evicting new batches. In streaming scenarios this results in a lot of unnecessary buffering as the batches are likely to be held only for a short time. -- 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

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2694) Support for Blob Input in Teiid REST services

by Madhu Garimilla (JIRA)

Madhu Garimilla created TEIID-2694: -------------------------------------- Summary: Support for Blob Input in Teiid REST services Key: TEIID-2694 URL: https://issues.jboss.org/browse/TEIID-2694 Project: Teiid Issue Type: Enhancement Affects Versions: 8.5 Environment: EAP 6.1 Alpha , Teiid 8.5 Reporter: Madhu Garimilla Assignee: Steven Hawkins We are trying to upload large files as Blobs using Teiid REST service through VDB. Though we are writing the Blob objects to HttpUrlConnection object, it is not received on REST method. As per the conversation in the thread "https://community.jboss.org/thread/232840" Current parameter handling is done through strings and needs be enhanced to support Blob objects. -- 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

11 years, 3 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2013