November 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4191) Add a NOQUOTE option for the TEXTAGG function

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4191?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4191. --------------------------------- > Add a NOQUOTE option for the TEXTAGG function > --------------------------------------------- > > Key: TEIID-4191 > URL: https://issues.jboss.org/browse/TEIID-4191 > Project: Teiid > Issue Type: Feature Request > Components: Grammar, Server > Affects Versions: 8.7.5.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1 > > > Currently on the TEXTAGG function it defaults to double quotes(") and you can specify something else with QUOTE, but there is not a way to have NO QUOTES at all. Can this be added? -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4275) No NIS is setup for the Procedure parameters during the JDBC metadata import

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4275?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4275. --------------------------------- > No NIS is setup for the Procedure parameters during the JDBC metadata import > ---------------------------------------------------------------------------- > > Key: TEIID-4275 > URL: https://issues.jboss.org/browse/TEIID-4275 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 9.1 > > > NameInSource property is not automatically set during the "NATIVE" matadata load of the metadata, and when a procedure's column is defined with spaces inside it, the SQLStringVisitor never quotes it, thus ends up parsing error when writing the queries. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4106) Rename and align infinispan translators/resource-adapters for their purpose

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4106?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4106. --------------------------------- > Rename and align infinispan translators/resource-adapters for their purpose > ---------------------------------------------------------------------------- > > Key: TEIID-4106 > URL: https://issues.jboss.org/browse/TEIID-4106 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.0 > > > The infinispan-cache and infinispan-cache-dsl translators/resource-adapters need to be renamed and aligned for what their purpose is. Because using "dsl" as part of the name is confusing, because both translators now support querying using JDG DSL language. > infinispan-cache: > - rename to infinispan-cache-library-mode (or leave as infinispan-cache and it be assume library mode) > - deprecate the access to remote-cache because the other infinispan-cache-dsl translator provides this feature. > - this will enable the cleaning of the documentation to be specific to library mode > infinispan-cache-dsl: > - rename to infinispan-cache-hot-rod (or something other than "dsl") because this all about remote cache access using hot rod client -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4379) OData entity row created twice

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4379?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4379. --------------------------------- > OData entity row created twice > ------------------------------ > > Key: TEIID-4379 > URL: https://issues.jboss.org/browse/TEIID-4379 > Project: Teiid > Issue Type: Quality Risk > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 9.1 > > > The logic to detect duplicate entities in the simple case of no duplicates causes each entity row to be created twice. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4254) PG transport SSL Warning during the client connection

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4254?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4254. --------------------------------- > PG transport SSL Warning during the client connection > ----------------------------------------------------- > > Key: TEIID-4254 > URL: https://issues.jboss.org/browse/TEIID-4254 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 9.0 > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 9.0 > > > While using a ODBC client with SSL is throwing this following exception on server at the time of connection. I used the script here https://developer.jboss.org/wiki/JDBCODBCSSLConnectionUsingSelf-signedSSL... > It seemed to work fine after that > {code} > 5:42:02,651 WARNING [io.netty.util.concurrent.DefaultPromise] (NIO2) An exception was thrown by org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(): io.netty.util.concurrent.BlockingOperationException: SslHandler$LazyChannelPromise@5a8a25ae(incomplete) > at io.netty.util.concurrent.DefaultPromise.checkDeadLock(DefaultPromise.java:390) > at io.netty.util.concurrent.DefaultPromise.await(DefaultPromise.java:251) > at io.netty.util.concurrent.DefaultPromise.sync(DefaultPromise.java:218) > at io.netty.util.concurrent.DefaultPromise.sync(DefaultPromise.java:32) > at org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(PgBackendProtocol.java:90) > at org.teiid.transport.PgBackendProtocol$SSLEnabler.operationComplete(PgBackendProtocol.java:77) > at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680) > at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:567) > at io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:406) > at io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:82) > at io.netty.channel.ChannelOutboundBuffer.safeSuccess(ChannelOutboundBuffer.java:639) > at io.netty.channel.ChannelOutboundBuffer.remove(ChannelOutboundBuffer.java:259) > at io.netty.channel.ChannelOutboundBuffer.removeBytes(ChannelOutboundBuffer.java:334) > at io.netty.channel.socket.nio.NioSocketChannel.doWrite(NioSocketChannel.java:317) > at io.netty.channel.AbstractChannel$AbstractUnsafe.flush0(AbstractChannel.java:750) > at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.flush0(AbstractNioChannel.java:303) > at io.netty.channel.AbstractChannel$AbstractUnsafe.flush(AbstractChannel.java:719) > at io.netty.channel.DefaultChannelPipeline$HeadContext.flush(DefaultChannelPipeline.java:1119) > at io.netty.channel.AbstractChannelHandlerContext.invokeFlush(AbstractChannelHandlerContext.java:735) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:765) > at io.netty.channel.AbstractChannelHandlerContext.writeAndFlush(AbstractChannelHandlerContext.java:753) > at org.teiid.transport.PgBackendProtocol.sendSslResponse(PgBackendProtocol.java:591) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.teiid.transport.PgBackendProtocol.write(PgBackendProtocol.java:219) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:705) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:763) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:698) > at io.netty.channel.ChannelDuplexHandler.write(ChannelDuplexHandler.java:106) > at io.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:705) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:763) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:698) > at io.netty.channel.AbstractChannelHandlerContext.write(AbstractChannelHandlerContext.java:684) > at io.netty.channel.DefaultChannelPipeline.write(DefaultChannelPipeline.java:940) > at io.netty.channel.AbstractChannel.write(AbstractChannel.java:234) > at org.teiid.transport.SSLAwareChannelHandler$ObjectChannelImpl.write(SSLAwareChannelHandler.java:93) > at org.teiid.transport.ODBCClientInstance$1.invoke(ODBCClientInstance.java:60) > at com.sun.proxy.$Proxy58.sendSslResponse(Unknown Source) > at org.teiid.odbc.ODBCServerRemoteImpl.sslRequest(ODBCServerRemoteImpl.java:1034) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:127) > at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:116) > at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:212) > at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218) > at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) > at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) > at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511) > at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468) > at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382) > at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354) > at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) > at java.lang.Thread.run(Thread.java:745) > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4334) Prepared insert resolving failure with implicitly named temp table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4334?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4334. --------------------------------- > Prepared insert resolving failure with implicitly named temp table > ------------------------------------------------------------------ > > Key: TEIID-4334 > URL: https://issues.jboss.org/browse/TEIID-4334 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Similar to TEIID-3994 we will fail to execute a prepared update with explicit columns against a temp table with an implicit name: > create local temporary table #x (e1 string) > insert into #x (e1) values (?) -- fails with a resolving exception -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3380) Simplify Kerberos configuration with Embedded

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3380?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3380. --------------------------------- > Simplify Kerberos configuration with Embedded > --------------------------------------------- > > Key: TEIID-3380 > URL: https://issues.jboss.org/browse/TEIID-3380 > Project: Teiid > Issue Type: Quality Risk > Components: Embedded > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.11, 8.7.2.6_2, 8.7.6 > > > The current code requires overriding the embedded server to install a custom session service. It may be good to have some base level of functionality built-in and/or just delegated to the security helper. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4227) Impala Translator - Support Multiple Count Distinct with Group By

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4227?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4227. --------------------------------- > Impala Translator - Support Multiple Count Distinct with Group By > ----------------------------------------------------------------- > > Key: TEIID-4227 > URL: https://issues.jboss.org/browse/TEIID-4227 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.13.3 > Reporter: Scott Wallace > Assignee: Steven Hawkins > Fix For: 9.1 > > > This is somewhat related to TEIID-3743, which added support of multiple count distinct metrics. We have a requirement to allow multiple count distinct metrics grouped by common attributes. > Currently, we get a failure as follows: > {noformat}org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 vw_impression_click_transaction_process_date_detail: 500051 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.process_date_key, SUM(g_0.num_clicks), SUM(g_0.num_impressions), COUNT(DISTINCT g_0.orderid), COUNT(DISTINCT g_0.`hash_tid`), SUM(g_0.sales) FROM detail.vw_impression_click_transaction_process_date_detail g_0 WHERE g_0.process_date_key >= '2016-05-22' AND g_0.process_date_key < '2016-05-23' AND g_0.advertiser_key = 12345 GROUP BY g_0.process_date_key] > {noformat} > To allow this request to succeed, we could have translator write that Impala query as: > {noformat} > select nvl(v1.c1,v2.c1), nvl(v1.c2,v1.c2), nvl(v1.c3,v1.c3), v1.c4, v2.c5, nvl(v1.c6,v1.c6) from ( > SELECT g_0.process_date_key as c1, > SUM(g_0.num_clicks) as c2, > SUM(g_0.num_impressions) as c3, > COUNT(DISTINCT g_0.orderid) as c4, > SUM(g_0.sales) as c6 > FROM detail.vw_impression_click_transaction_process_date_detail g_0 > WHERE g_0.process_date_key >= '2016-05-22' > AND g_0.process_date_key < '2016-05-23' > AND g_0.advertiser_key = 12345 > GROUP BY g_0.process_date_key > ) v1 inner join > ( > SELECT g_0.process_date_key as c1, > SUM(g_0.num_clicks) as c2, > SUM(g_0.num_impressions) as c3, > COUNT(DISTINCT g_0.`hash_tid`) as c5, > SUM(g_0.sales) as c6 > FROM detail.vw_impression_click_transaction_process_date_detail g_0 > WHERE g_0.process_date_key >= '2016-05-22' > AND g_0.process_date_key < '2016-05-23' > AND g_0.advertiser_key = 12345 > GROUP BY g_0.process_date_key > ) v2 on v1.c1 = v2.c1; > {noformat} > FYI [~shawkins] -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3462) Add support for semantic versioning of VDBs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3462?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3462. --------------------------------- > Add support for semantic versioning of VDBs > ------------------------------------------- > > Key: TEIID-3462 > URL: https://issues.jboss.org/browse/TEIID-3462 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 8.7 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.0 > > > Semantic versioning [1] should be supported in the VDB versioning in order to be able to easier determine whether there are breaking changes from the client perspective and to more easily establish a link between client software versions and the VDBs they rely upon. > [1] http://semver.org/ -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4138) Move teiid embedded example doc to gitbook

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4138?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4138. --------------------------------- > Move teiid embedded example doc to gitbook > ------------------------------------------ > > Key: TEIID-4138 > URL: https://issues.jboss.org/browse/TEIID-4138 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Affects Versions: 9.x > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > Moving the doc from https://docs.jboss.org/author/display/teiidexamples/Teiid+Embedded+Examples to gitbook -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 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 November 2016