October 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-247) Add support for array types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-247?page=com.atlassian.jira.plugin.... ] Steven Hawkins closed TEIID-247. -------------------------------- > Add support for array types > --------------------------- > > Key: TEIID-247 > URL: https://issues.jboss.org/browse/TEIID-247 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, JDBC Driver, Query Engine > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.5 > > Original Estimate: 1 week > Remaining Estimate: 1 week > > Add language support for array types. Push down and client support should also be added. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2875) Metadata failed to load. No column found

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2875?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2875. --------------------------------- > Metadata failed to load. No column found > ---------------------------------------- > > Key: TEIID-2875 > URL: https://issues.jboss.org/browse/TEIID-2875 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.6 > Environment: Windows server 2003, Windows 7. > Reporter: SHI HONG CHIN > Assignee: Steven Hawkins > Attachments: JakkerData-vdb.xml > > > Affected database: Oracle > The following error displayed when Teiid loading a dynamic VDB: > 10:21:41,458 WARN [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50036 VDB JakkerData.1 model "IWMS" metadata failed to load. Reason:TEIID60011 No column found with name "RATE"."CHARGE_NAME" > 10:23:29,994 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB JakkerData.1 model "IWMS" metadata failed to load. Reason:TEIID60011 No column found with name "RATE"."CHARGE_NAME" > I am not the one who design the database. But, I cannot find any table with above mentioned column name in Oracle database. So, I am not sure whether the above mentioned column name is a hidden column or not. > This bug does not exist in version 8.5. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3087) Exception with unclear message

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3087?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3087. --------------------------------- > Exception with unclear message > ------------------------------ > > Key: TEIID-3087 > URL: https://issues.jboss.org/browse/TEIID-3087 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: OS: Fedora 20 > architecture: x86_64 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Attachments: exception-stack-trace, full-server.log, server.log > > > Description of problem: > Unexpected exception. Returned exception indicates that query failed but there is no reason in message. > Actual results: > TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4200 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(g_0.shortvalue AS smallint) AS c_0, abs(cast(g_0.shortvalue AS smallint)) AS c_1 FROM smallb AS g_0 ORDER BY c_0] > Expected results: > Remote java.sql.SQLException: Specified cursor is not known to the server. > Additional info: > server log and exception stack trace in attachment -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3182) Decimal number got converted to Integer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3182?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3182. ----------------------------------- Labels: (was: Teiid) Resolution: Duplicate Issue Duplicate of TEIID-3160 > Decimal number got converted to Integer > --------------------------------------- > > Key: TEIID-3182 > URL: https://issues.jboss.org/browse/TEIID-3182 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.8 > Environment: Teiid 8.8.1 with hive driver (hortonworks 2.0) > Reporter: Ivan Chan > Assignee: Steven Hawkins > > Teiid engines converts value 1000.0 to 1000 and it doesn't keep the original data type. > My original SQL: > select ("meat_sqft" / 1000.0) as "calcField2" from "HDP20_default"."store" group by ("meat_sqft" / 1000.0) > and Teiid translated it to: > SELECT v_0.c_0 FROM (SELECT (g_0.meat_sqft / 1000) AS c_0 FROM HDP20_default.store AS g_0) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 200001 > (g_0.meat_sqft / 1000) field returns Integer instead of decimal. > However, if I use 1000.1 instead and it would work. > Original SQL: > select ("meat_sqft" / 1000.1) as "calcField2" from "HDP20_default"."store" group by ("meat_sqft" / 1000.1) > And teiid translated it to: > SELECT v_0.c_0 FROM (SELECT (convert(g_0.meat_sqft, bigdecimal) / 1000.1) AS c_0 FROM HDP20_default.store AS g_0) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 200001 > I believe both 1000.0 and 1000.1 should have consistent behavior. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3182) Decimal number got converted to Integer

by Ivan Chan (JIRA)

Ivan Chan created TEIID-3182: -------------------------------- Summary: Decimal number got converted to Integer Key: TEIID-3182 URL: https://issues.jboss.org/browse/TEIID-3182 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.8 Environment: Teiid 8.8.1 with hive driver (hortonworks 2.0) Reporter: Ivan Chan Assignee: Steven Hawkins Teiid engines converts value 1000.0 to 1000 and it doesn't keep the original data type. My original SQL: select ("meat_sqft" / 1000.0) as "calcField2" from "HDP20_default"."store" group by ("meat_sqft" / 1000.0) and Teiid translated it to: SELECT v_0.c_0 FROM (SELECT (g_0.meat_sqft / 1000) AS c_0 FROM HDP20_default.store AS g_0) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 200001 (g_0.meat_sqft / 1000) field returns Integer instead of decimal. However, if I use 1000.1 instead and it would work. Original SQL: select ("meat_sqft" / 1000.1) as "calcField2" from "HDP20_default"."store" group by ("meat_sqft" / 1000.1) And teiid translated it to: SELECT v_0.c_0 FROM (SELECT (convert(g_0.meat_sqft, bigdecimal) / 1000.1) AS c_0 FROM HDP20_default.store AS g_0) AS v_0 GROUP BY v_0.c_0 ORDER BY c_0 LIMIT 200001 I believe both 1000.0 and 1000.1 should have consistent behavior. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3181) Use Teiid as default JAAS application name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3181?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3181. ----------------------------------- Resolution: Done Merged the pull request and updated the docs where we referenced the jaas name. > Use Teiid as default JAAS application name > ------------------------------------------ > > Key: TEIID-3181 > URL: https://issues.jboss.org/browse/TEIID-3181 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Affects Versions: 8.8 > Reporter: Cristiano Nicolai > Assignee: Steven Hawkins > Fix For: 8.9 > > > Enhancement for the client side of setting up JDBC connections using GSS API. Suggestion is to use "Teiid" as default JAAS application name. This is to be used in case jaasName is not supplied in the connection properties. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3181) Use Teiid as default JAAS application name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3181?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3181: ---------------------------------- Affects Version/s: 8.8 Component/s: JDBC Driver > Use Teiid as default JAAS application name > ------------------------------------------ > > Key: TEIID-3181 > URL: https://issues.jboss.org/browse/TEIID-3181 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Affects Versions: 8.8 > Reporter: Cristiano Nicolai > Assignee: Steven Hawkins > Fix For: 8.9 > > > Enhancement for the client side of setting up JDBC connections using GSS API. Suggestion is to use "Teiid" as default JAAS application name. This is to be used in case jaasName is not supplied in the connection properties. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3070) Netty worker threads cause system high cpu

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3070?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3070. ----------------------------------- Resolution: Done Added a release note to upgrade the AS netty version to 3.6.10.Final. > Netty worker threads cause system high cpu > ------------------------------------------ > > Key: TEIID-3070 > URL: https://issues.jboss.org/browse/TEIID-3070 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7, 8.9 > Environment: JDV 6.1.0.DR2 > JDV 6.0 > Reporter: Kylin Soong > Assignee: Kylin Soong > > I have hit this issue many times in deploying a VDB to JDV, All CPU be used by netty worker threads: > ~~~ > "New I/O worker #3" daemon prio=10 tid=0x00007fc71c0d2000 nid=0x320b runnable [0x00007fc7074f3000] > java.lang.Thread.State: RUNNABLE > at sun.nio.ch.EPollArrayWrapper.epollWait(Native Method) > at sun.nio.ch.EPollArrayWrapper.poll(EPollArrayWrapper.java:269) > at sun.nio.ch.EPollSelectorImpl.doSelect(EPollSelectorImpl.java:79) > at sun.nio.ch.SelectorImpl.lockAndDoSelect(SelectorImpl.java:87) > - locked <0x00000000c42b4318> (a sun.nio.ch.Util$2) > - locked <0x00000000c42b4328> (a java.util.Collections$UnmodifiableSet) > - locked <0x00000000c42b42d0> (a sun.nio.ch.EPollSelectorImpl) > at sun.nio.ch.SelectorImpl.select(SelectorImpl.java:98) > at org.jboss.netty.channel.socket.nio.SelectorUtil.select(SelectorUtil.java:64) > ~~~ > Seems this is a exist netty issue, search "jboss netty high cpu" via google we can get lots of result. > Below link have detailed depiction about this issue; > https://github.com/kylinsoong/teiid-samples/tree/master/highcpu -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3177) Enforce SSL connections over ODBC when Encryption Mode is enabled

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3177?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3177. ----------------------------------- Fix Version/s: 8.9 Resolution: Done I decided that it was worthwhile to make the transports consistent. That is if the ssl mode is set to enabled on either, that means that the client is allowed to use SSL. Also the login setting for the ODBC ssl configuration is taken to mean that a secure authentication mechanism is needed - which effectively requires GSS. This is a behavioral change though. The old behavior can be utilized by setting the system property org.teiid.ODBCRequireSecure to false. Alternatively the configuration can be updated so that the SSL configuration for the PG transport is explicitly disabled. > Enforce SSL connections over ODBC when Encryption Mode is enabled > ----------------------------------------------------------------- > > Key: TEIID-3177 > URL: https://issues.jboss.org/browse/TEIID-3177 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Affects Versions: 8.8 > Reporter: Cristiano Nicolai > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.9 > > > When connecting via ODBC transport, even if the encryption mode is set to enabled is still possible to establish non ssl connections. This allows clients to connect via insecure method. We would like that the Teiid transport could reject connections if they are not properly set up using SSL transport. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3181) Use Teiid as default JAAS application name

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3181?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-3181: -------------------------------- Fix Version/s: 8.9 > Use Teiid as default JAAS application name > ------------------------------------------ > > Key: TEIID-3181 > URL: https://issues.jboss.org/browse/TEIID-3181 > Project: Teiid > Issue Type: Enhancement > Reporter: Cristiano Nicolai > Assignee: Steven Hawkins > Fix For: 8.9 > > > Enhancement for the client side of setting up JDBC connections using GSS API. Suggestion is to use "Teiid" as default JAAS application name. This is to be used in case jaasName is not supplied in the connection properties. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2014