[JBoss JIRA] (TEIID-3780) Hive: Convert "UseDatabaseMetaData: to be an translator import property
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3780?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3780:
---------------------------------------
> may be this should be designed as translator importer property?
Having a get/createMetadataProcessor without arguments means that we'd have to add an override of getMetadata, or merge the logic into the existing overriden metadata processor. So unfortunately this was the most straightforward initial solution.
> Hive: Convert "UseDatabaseMetaData: to be an translator import property
> -----------------------------------------------------------------------
>
> Key: TEIID-3780
> URL: https://issues.jboss.org/browse/TEIID-3780
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.11
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Minor
> Fix For: 8.12.1
>
>
> Currently "UseDatabaseMetadata" as been designed as Translator property, may be this should be designed as translator importer property?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3763) WS connector oauth security setting not work in Embedded
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3763?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3763:
-------------------------------------
OAuth10LoginModule and OAuth20LoginModule do the job of getting the "AccessToken" based on the "RefreshToken" obtained by the teiid-oauth-util.sh. So, Yes they are needed, so are the other properties. Look inside the "OAuth20CredentialImpl" and "OAuth10CredentialImpl" classes.
teiid-oauth-util.sh "only" gets the "RefreshToken", that is does not the complete security. Also, the "AccessToken" does expire and can be revoked any time, in those situations the LoginModule re-negotiates a new AccessToken.
As per per your UI comment, I have not thought about it yet. Yes it is already supported in WSManagedConnectionFactory, I am not sure what you mean by that comment.
As per IronJacmar, I am not sure how that integrates, so I can not comment right now.
> WS connector oauth security setting not work in Embedded
> --------------------------------------------------------
>
> Key: TEIID-3763
> URL: https://issues.jboss.org/browse/TEIID-3763
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Kylin Soong
> Fix For: 8.12.x
>
> Attachments: jca-ra-outbound.png
>
>
> In WSConnectionImpl setDispatchProperties setting depend on Security Subject:
> {code}
> else if (this.mcf.getAsSecurityType() == WSManagedConnectionFactory.SecurityType.OAuth) {
> Subject subject = ConnectionContext.getSubject();
> if (subject != null) {
> }
> ...
> }
> {code}
> Note if run WS connector with security in Embedded, ConnectionContext.getSubject() return null, the cause exception throw.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3775) HBase - GROUP BY clause returns duplicates results
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3775?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3775.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-3696
> HBase - GROUP BY clause returns duplicates results
> --------------------------------------------------
>
> Key: TEIID-3775
> URL: https://issues.jboss.org/browse/TEIID-3775
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> I have a view defined as follows:
> {code:sql}
> CREATE VIEW U8 (IntKey integer,
> StringKey string,
> IntNum integer,
> StringNum string,
> FloatNum float,
> LongNum long,
> DoubleNum double,
> ByteNum byte,
> DateValue date,
> TimeValue time,
> TimestampValue timestamp,
> BooleanValue boolean,
> CharValue char,
> ShortValue short,
> BigIntegerValue biginteger,
> BigDecimalValue bigdecimal)
> AS
> SELECT BQT1.SmallA.IntKey, BQT1.SmallA.StringKey, BQT1.SmallA.IntNum, BQT1.SmallA.StringNum,
> BQT1.SmallA.FloatNum, BQT1.SmallA.LongNum, BQT1.SmallA.DoubleNum, BQT1.SmallA.ByteNum,
> BQT1.SmallA.DateValue, BQT1.SmallA.TimeValue, BQT1.SmallA.TimestampValue, BQT1.SmallA.BooleanValue,
> BQT1.SmallA.CharValue, BQT1.SmallA.ShortValue, BQT1.SmallA.BigIntegerValue, BQT1.SmallA.BigDecimalValue
> FROM BQT1.SmallA
> UNION
> SELECT BQT1.SmallB.IntKey, BQT1.SmallB.StringKey, BQT1.SmallB.IntNum, BQT1.SmallB.StringNum,
> BQT1.SmallB.FloatNum, BQT1.SmallB.LongNum, BQT1.SmallB.DoubleNum, BQT1.SmallB.ByteNum,
> BQT1.SmallB.DateValue, BQT1.SmallB.TimeValue, BQT1.SmallB.TimestampValue, BQT1.SmallB.BooleanValue,
> BQT1.SmallB.CharValue, BQT1.SmallB.ShortValue, BQT1.SmallB.BigIntegerValue, BQT1.SmallB.BigDecimalValue
> FROM BQT1.SmallB ORDER BY IntKey;
> {code}
> Query *SELECT StringNum FROM VQT.U8 GROUP BY StringNum* returns duplicate results (multiple null).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3775) HBase - GROUP BY clause returns duplicates results
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3775?page=com.atlassian.jira.plugin... ]
Steven Hawkins edited comment on TEIID-3775 at 10/20/15 9:00 AM:
-----------------------------------------------------------------
Thanks Juraj, that confirms this is a duplicate of TEIID-3696
was (Author: shawkins):
Duplicate of TEIID-3696
> HBase - GROUP BY clause returns duplicates results
> --------------------------------------------------
>
> Key: TEIID-3775
> URL: https://issues.jboss.org/browse/TEIID-3775
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> I have a view defined as follows:
> {code:sql}
> CREATE VIEW U8 (IntKey integer,
> StringKey string,
> IntNum integer,
> StringNum string,
> FloatNum float,
> LongNum long,
> DoubleNum double,
> ByteNum byte,
> DateValue date,
> TimeValue time,
> TimestampValue timestamp,
> BooleanValue boolean,
> CharValue char,
> ShortValue short,
> BigIntegerValue biginteger,
> BigDecimalValue bigdecimal)
> AS
> SELECT BQT1.SmallA.IntKey, BQT1.SmallA.StringKey, BQT1.SmallA.IntNum, BQT1.SmallA.StringNum,
> BQT1.SmallA.FloatNum, BQT1.SmallA.LongNum, BQT1.SmallA.DoubleNum, BQT1.SmallA.ByteNum,
> BQT1.SmallA.DateValue, BQT1.SmallA.TimeValue, BQT1.SmallA.TimestampValue, BQT1.SmallA.BooleanValue,
> BQT1.SmallA.CharValue, BQT1.SmallA.ShortValue, BQT1.SmallA.BigIntegerValue, BQT1.SmallA.BigDecimalValue
> FROM BQT1.SmallA
> UNION
> SELECT BQT1.SmallB.IntKey, BQT1.SmallB.StringKey, BQT1.SmallB.IntNum, BQT1.SmallB.StringNum,
> BQT1.SmallB.FloatNum, BQT1.SmallB.LongNum, BQT1.SmallB.DoubleNum, BQT1.SmallB.ByteNum,
> BQT1.SmallB.DateValue, BQT1.SmallB.TimeValue, BQT1.SmallB.TimestampValue, BQT1.SmallB.BooleanValue,
> BQT1.SmallB.CharValue, BQT1.SmallB.ShortValue, BQT1.SmallB.BigIntegerValue, BQT1.SmallB.BigDecimalValue
> FROM BQT1.SmallB ORDER BY IntKey;
> {code}
> Query *SELECT StringNum FROM VQT.U8 GROUP BY StringNum* returns duplicate results (multiple null).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3763) WS connector oauth security setting not work in Embedded
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3763?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-3763:
------------------------------------
Please ignore my #1 comment, my previous thought is totally wrong, from JCA specification, security related stuff are only related with ConnectionManager which are implemented/maintained by Application Server(ironjacamar in JBoss), ManagedConnectionFactory no responsibility to handle security.
If use ironjacamar deploy webservice outbound resource adapter, then set security to ironjacamar, this may a possible solution for running WS connector oauth security in embedded, but I am not test.
Another founding of me is that the Oauth security related LoginModule and Credential are not really executed authentication, the real authentication executed manually by teiid-oauth-util.sh, Oauth security related LoginModule and Credential just pass teiid-oauth-util.sh authentication results to cxf WebClient, set as header like
{code}
OAuthClientUtils.Consumer consumer = new OAuthClientUtils.Consumer(consumerKey, consumerSecret);
OAuthClientUtils.Token token = new OAuthClientUtils.Token(accessToken, accessSecret);
String auth = OAuthClientUtils.createAuthorizationHeader(consumer, token, httpMethod, resourceURI);
...
WebClient client = ...
client.header("Authorization", auth)
{code}
consumerKey, consumerSecret, accessToken, accessSecret are all get manually, so in this term, we do not use the JAAS mechanism, we just path there properties as translator import properties, then used in connector directly, this also helpful for Teiid Designer to develop UI, also helpful Swagger translator develop.
Also, in terms of Oauth 2, do not need set consumerKey, consumerSecret, accessToken, accessSecret as header, it only need set access_token as request parameter, we may need think add OAuth 2 SecurityType in WSManagedConnectionFactory.
> WS connector oauth security setting not work in Embedded
> --------------------------------------------------------
>
> Key: TEIID-3763
> URL: https://issues.jboss.org/browse/TEIID-3763
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Kylin Soong
> Fix For: 8.12.x
>
> Attachments: jca-ra-outbound.png
>
>
> In WSConnectionImpl setDispatchProperties setting depend on Security Subject:
> {code}
> else if (this.mcf.getAsSecurityType() == WSManagedConnectionFactory.SecurityType.OAuth) {
> Subject subject = ConnectionContext.getSubject();
> if (subject != null) {
> }
> ...
> }
> {code}
> Note if run WS connector with security in Embedded, ConnectionContext.getSubject() return null, the cause exception throw.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3763) WS connector oauth security setting not work in Embedded
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3763?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-3763:
-------------------------------
Attachment: jca-ra-outbound.png
> WS connector oauth security setting not work in Embedded
> --------------------------------------------------------
>
> Key: TEIID-3763
> URL: https://issues.jboss.org/browse/TEIID-3763
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Kylin Soong
> Fix For: 8.12.x
>
> Attachments: jca-ra-outbound.png
>
>
> In WSConnectionImpl setDispatchProperties setting depend on Security Subject:
> {code}
> else if (this.mcf.getAsSecurityType() == WSManagedConnectionFactory.SecurityType.OAuth) {
> Subject subject = ConnectionContext.getSubject();
> if (subject != null) {
> }
> ...
> }
> {code}
> Note if run WS connector with security in Embedded, ConnectionContext.getSubject() return null, the cause exception throw.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3671) filter on child table not working
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3671:
------------------------------------------------
Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1259736|https://bugzilla.redhat.com/show_bug.cgi?id=1259736] from ON_QA to ASSIGNED
> filter on child table not working
> ---------------------------------
>
> Key: TEIID-3671
> URL: https://issues.jboss.org/browse/TEIID-3671
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Reporter: Prashanthi Kairuppala
> Assignee: Johnathon Lee
> Priority: Critical
> Fix For: 8.12, 8.11.4, 8.7.5
>
> Attachments: parent_childTables.PNG
>
>
>
> Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13.
>
> Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22'
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3671) filter on child table not working
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ]
Juraj Duráni reopened TEIID-3671:
---------------------------------
The fix has been tested in 6.1.4. According to query, original issue is resolved \[1\]. However, Odata does not work because Teiid throws NPE \[2\].
\[1\]
6.1.2 --> /*+ cache(ttl:300000 scope:USER) */ SELECT g1.id_uk, g1.DISCOUNT, g1.type, g1.PRICE, g1.ID FROM Source.sales AS g0 INNER JOIN Source.sales_uk AS g1 ON g0.ID = g1.ID WHERE g1.DISCOUNT = ? ORDER BY g1.id_uk
6.1.4 --> /*+ cache(ttl:300000 scope:USER) */ SELECT g1.id_uk, g1.DISCOUNT, g1.type, g1.PRICE, g1.ID FROM Source.sales AS g0 INNER JOIN Source.sales_uk AS g1 ON g0.ID = g1.ID WHERE (g0.ID = '13') AND (g1.DISCOUNT = ?) ORDER BY g1.id_uk
\[2\]
{code:text}
10:43:15,485 WARN [org.teiid.ODATA] (http-/127.0.0.1:8180-3) TEIID16012 Could not produce a successful OData response. Returning status ServerErrorException with message Internal Server Error.: org.odata4j.exceptions.ServerErrorException
at org.teiid.odata.LocalClient.executeSQL(LocalClient.java:333) [classes:]
at org.teiid.odata.TeiidProducer.getNavProperty(TeiidProducer.java:89) [classes:]
at org.teiid.odata.TeiidProducer.getNavProperty(TeiidProducer.java:55) [classes:]
at org.odata4j.producer.resources.PropertyRequestResource.getNavProperty(PropertyRequestResource.java:194) [odata-core-0.8.7.redhat-61-1.jar:0.8.7.redhat-61-1]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_40]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_40]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_40]
at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_40]
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:159) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:92) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at org.teiid.odata.ODataServletContainerDispatcher.service(ODataServletContainerDispatcher.java:118) [classes:]
at org.teiid.odata.ODataServlet.service(ODataServlet.java:65) [classes:]
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.8.SP4-redhat-2.jar:]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.4.3.Final-redhat-2.jar:7.4.3.Final-redhat-2]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.4.10.Final-redhat-1.jar:7.4.10.Final-redhat-1]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
Caused by: java.lang.NullPointerException
at org.teiid.odata.EntityList.getEntity(EntityList.java:62) [classes:]
at org.teiid.odata.EntityList.addEntity(EntityList.java:54) [classes:]
at org.teiid.odata.LocalClient.executeSQL(LocalClient.java:302) [classes:]
... 33 more
{code}
> filter on child table not working
> ---------------------------------
>
> Key: TEIID-3671
> URL: https://issues.jboss.org/browse/TEIID-3671
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Reporter: Prashanthi Kairuppala
> Assignee: Johnathon Lee
> Priority: Critical
> Fix For: 8.12, 8.11.4, 8.7.5
>
> Attachments: parent_childTables.PNG
>
>
>
> Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13.
>
> Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22'
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months
[JBoss JIRA] (TEIID-3770) HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate
by Juraj Duráni (JIRA)
[ https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin... ]
Juraj Duráni edited comment on TEIID-3770 at 10/20/15 2:38 AM:
---------------------------------------------------------------
phoenix driver: phoenix-4.5.0-HBase-1.1-client.jar
phoenix server: phoenix-4.5.1-HBase-1.1-server.jar
was (Author: jdurani):
phoenix driver: phoenix-4.5.0-HBase-1.1-client.jar
phoenix server: phoenix-4.5.1-HBase-1.1.1-server
> HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate
> ------------------------------------------------------------------------------------
>
> Key: TEIID-3770
> URL: https://issues.jboss.org/browse/TEIID-3770
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1.6_2
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Query:
> SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY
> It seems like bug in Phoenix driver.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 3 months