December 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4023) Exception with unresolved Array expression hashcode

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4023?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4023. --------------------------------- > Exception with unresolved Array expression hashcode > --------------------------------------------------- > > Key: TEIID-4023 > URL: https://issues.jboss.org/browse/TEIID-4023 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.2 > > > The type is being used in the hashCode, but it may not be set. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4019) teiid-standalone-mode-install.cli executed failed due to 'authentication-security-domain' be removed

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4019?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4019. --------------------------------- > teiid-standalone-mode-install.cli executed failed due to 'authentication-security-domain' be removed > ---------------------------------------------------------------------------------------------------- > > Key: TEIID-4019 > URL: https://issues.jboss.org/browse/TEIID-4019 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 9.0 > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 9.0 > > > The following cli executed failed > {code} > subsystem=teiid/transport=odata:add(authentication-security-domain=teiid-security) > /subsystem=teiid/transport=jdbc:add(protocol=teiid, socket-binding=teiid-jdbc, authentication-security-domain=teiid-security) > /subsystem=teiid/transport=odbc:add(protocol=pg, socket-binding=teiid-odbc, authentication-security-domain=teiid-security, ssl-mode=disabled) > {code} > The error looks > {code} > 'authentication-security-domain' is not found among the supported properties: [input-buffer-size, keystore-key-alias, keystore-key-password, keystore-name, keystore-password, keystore-type, max-socket-threads, output-buffer-size, pg-max-lob-size-in-bytes, protocol, socket-binding, ssl-authentication-mode, ssl-enabled-cipher-suites, ssl-keymanagement-algorithm, ssl-mode, ssl-ssl-protocol, truststore-name, truststore-password] > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3972) Create asciidoc generation from javacc doc

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3972?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3972. --------------------------------- > Create asciidoc generation from javacc doc > ------------------------------------------ > > Key: TEIID-3972 > URL: https://issues.jboss.org/browse/TEIID-3972 > Project: Teiid > Issue Type: Sub-task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > The grammar page from confluence was generated automatically from javacc a modification of the html generation of jjdoc from - https://developer.jboss.org/wiki/TeiidReleaseProcedure > This needs changed again to produce asciidoc - and ideally to run automatically based upon parser changes. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4014) remove oid from system tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4014?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4014. --------------------------------- > remove oid from system tables > ----------------------------- > > Key: TEIID-4014 > URL: https://issues.jboss.org/browse/TEIID-4014 > Project: Teiid > Issue Type: Task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > The oid column on system tables is unused and should be removed. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3580) Hive 0.13.1 JDBC jars makes queries run slow

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3580?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3580. --------------------------------- > Hive 0.13.1 JDBC jars makes queries run slow > -------------------------------------------- > > Key: TEIID-3580 > URL: https://issues.jboss.org/browse/TEIID-3580 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.3 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: threaddump-1437508266001.tdump > > > When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return. > The Hive JDBC jars for version 0.13.1 can be found here : > https://github.com/vchintal/hive-jdbc-jars-archive > Alternatively a ready-to-go modules can be downloaded from here for testing: > https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/ > Use the following driver snippet when using the above mentioned module: > <driver name="hive" module="org.apache.hadoop.hive:0.13.1"> > <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class> > </driver> -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2403) SAML support in Teiid based web services

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2403?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2403. --------------------------------- > SAML support in Teiid based web services > ---------------------------------------- > > Key: TEIID-2403 > URL: https://issues.jboss.org/browse/TEIID-2403 > Project: Teiid > Issue Type: Feature Request > Components: Server, SOAP Services > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Currently there is no built in support for SAML based authentication for OData based REST Services and also REST based WAR created automatically. They should provide an option to support SAML. > Designer based web services (REST, SOAP) are not part of this JIRA, they should be handled using a separate TEIIDDES JIRA. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3942) Accumulo translators should use LexiCoders to preserve the native ordering

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3942?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3942. --------------------------------- > Accumulo translators should use LexiCoders to preserve the native ordering > -------------------------------------------------------------------------- > > Key: TEIID-3942 > URL: https://issues.jboss.org/browse/TEIID-3942 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.12.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Accumulo translator currently converts all the data to string based byte array and management of the data types is done at the translator level. In 1.6 version, there is support for LexiCoders which is standard way to encode/decode Java data types. The translator must be changed to make use of these. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3949) Subqueries are wrongly pushed down to the underlying datasource

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3949?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3949. --------------------------------- > Subqueries are wrongly pushed down to the underlying datasource > --------------------------------------------------------------- > > Key: TEIID-3949 > URL: https://issues.jboss.org/browse/TEIID-3949 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.1 > > > I have two schemas, one in PostgreSQL and another one in MySQL, called "pg" and "my" respectively. > I defined the following tables in PG: > {code:sql} > CREATE TABLE test_a (a integer, b integer); > CREATE TABLE test_only_pg (a integer, b integer); > {code} > and this table in MySQL: > {code:sql} > CREATE TABLE `test_b` ( > `b` int(11), > `c` int(11) > ) > {code} > When I run this query: > {code:sql} > SELECT > SUM(x.b - (SELECT a FROM pg.test_only_pg WHERE b = 1)) > FROM my.test_b x > INNER JOIN pg.test_a y ON x.b = y.b > {code} > I get the following exception: > {code:sql} > 16:44:54,776 WARN [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue28) QWfZdmacM17x Connector worker process failed for atomic-request=QWfZdmacM17x.12.7.4: org.teiid.translator.jdbc.JDBCExecutionException: 1146 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.`b` AS c_0, SUM((g_0.`b` - (SELECT g_1."a" AS c_0 FROM "public"."test_only_pg" AS g_1 WHERE g_1."b" = 1 LIMIT 2))) AS c_1 FROM `test_tables`.`test_b` AS g_0 GROUP BY g_0.`b` ORDER BY c_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.4.jar:8.12.4] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:356) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_67] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_67] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_67] > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_67] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_67] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67] > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'public.test_only_pg' doesn't exist > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_67] > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_67] > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_67] > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_67] > at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) > at com.mysql.jdbc.Util.getInstance(Util.java:386) > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) > at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) > at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) [translator-jdbc-8.12.4.jar:8.12.4] > ... 18 more > {code} > I could reproduce this behavior in Teiid 8.12.4. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3899) Allow Web Services translator to retrieve metadata without source connection

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3899?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3899. --------------------------------- > Allow Web Services translator to retrieve metadata without source connection > ---------------------------------------------------------------------------- > > Key: TEIID-3899 > URL: https://issues.jboss.org/browse/TEIID-3899 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.11 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: 8.12.4 > Fix For: 8.13, 8.12.4 > > > The "ws" translator, is set to "isSourceRequiredForMetadata" to true. However, there are two issues > 1) There is no way to turn this flag to false > 2) If the "ws" translator is secured through "security-domain", then authentication failure message by passes the "isSourceRequiredForMetadata" flag and returns as error, thus leaving the VDB in "metadata load failed" state. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3215) External Materialization ON_VDB_START_SCRIPT invocation issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3215?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3215. --------------------------------- > External Materialization ON_VDB_START_SCRIPT invocation issues > -------------------------------------------------------------- > > Key: TEIID-3215 > URL: https://issues.jboss.org/browse/TEIID-3215 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7 > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.7.1, 8.9 > > Attachments: mat-views-vdb.xml > > > With materialized view I have set teiid_rel:ON_VDB_START_SCRIPT property for the external matview table. (Simple query to increment a column in table to count invocations.) > Invocation of the script is dependent upon the way the vdb is deployed. The first case (A) doesn't invoke the script, the second (B) does. > A - 1. Copy the vdbname-vdb.xml into deployments folder > 2. Start the server > B - 1. Start the server > 2. Copy the vdbname-vdb.xml into deployments folder > That means that after server stop (maintenance) the script is not invoked on start, which can cause problems when the script is used to initialize running environment (clear table, create temporary table,...) -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2017