September 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3582) Add the query requestID to all lines for that query in the logs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3582?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3582: ---------------------------------- Fix Version/s: 8.12.1 (was: 8.12) > Add the query requestID to all lines for that query in the logs > --------------------------------------------------------------- > > Key: TEIID-3582 > URL: https://issues.jboss.org/browse/TEIID-3582 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Van Halbert > Fix For: 8.12.1 > > > Currently when running a query, the logs show the requestId on most of the lines but not all, especially CONNECTOR. > for example, the following line doesn't have it: > 14:13:34,071 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) Source-specific command: .... > That's the problem. When lots of queries are running, user wants to grep through the log for that requestid and get just that one query's stuff. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2884) Support for Amazon Elastic MapReduce

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2884?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2884: ---------------------------------- Fix Version/s: 8.12.1 (was: 8.12) > Support for Amazon Elastic MapReduce > ------------------------------------ > > Key: TEIID-2884 > URL: https://issues.jboss.org/browse/TEIID-2884 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Kylin Soong > Fix For: 8.12.1 > > > Amazon Elastic MapReduce > from http://en.wikipedia.org/wiki/Amazon_Elastic_MapReduce#Amazon_Elastic_MapR... > Elastic MapReduce (EMR)was introduced by Amazon in April 2009. Provisioning of the Hadoop cluster, running and terminating jobs, and handling data transfer between EC2 and S3 are automated by Elastic MapReduce. Apache Hive, which is built on top of Hadoop for providing data warehouse services, is also offered in Elastic MapReduce. > ... > In June 2012, premium options for EMR were added that replace ordinary Hadoop with MapR's M3 and M5 versions. These options provide additional capabilities over and above what the default EMR offering provides. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3349) Allow column type to be altered

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3349?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3349: ---------------------------------- Fix Version/s: 9.0 (was: 8.12) > Allow column type to be altered > ------------------------------- > > Key: TEIID-3349 > URL: https://issues.jboss.org/browse/TEIID-3349 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > Add ddl support for alter column type to assist in importing. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3489) Can a function be added to filter certain ASCII chars below 31 and above 127 out of an XML Document

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3489?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3489: ---------------------------------- Fix Version/s: 9.0 (was: 8.12) > Can a function be added to filter certain ASCII chars below 31 and above 127 out of an XML Document > --------------------------------------------------------------------------------------------------- > > Key: TEIID-3489 > URL: https://issues.jboss.org/browse/TEIID-3489 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Debbie Steigner > Priority: Minor > Fix For: 9.0 > > > Add a function in Teiid to filter off all ASCII chars below 31 and above 127. > web service data source that contains control characters due to data entered by copy and paste the text from another system. > The characters in this instance were the print control chars ASCII 28 and 29, File Separator and Group Separator respectively. These are used for formatting in older systems. Unfortunately, the XML standard prohibits the processing of all ASCII characters below 31 apart from Tab, Line Feed and Carriage Return which are permissible. Also, ASCII chars above 127 to 255 will also cause XML parsers to crash. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3509) Consolidate internal and external materialization management

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3509?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3509: ---------------------------------- Fix Version/s: 9.0 (was: 8.12) > Consolidate internal and external materialization management > ------------------------------------------------------------ > > Key: TEIID-3509 > URL: https://issues.jboss.org/browse/TEIID-3509 > Project: Teiid > Issue Type: Enhancement > Components: Server > Affects Versions: 8.7 > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 9.0 > > > - Currently there separate SYSADMIN procedures for internal and external materialization to refresh them, we need to provide single set > - The management of the (usage of status table) is not fully utilized by the internal materialization this needs to addressed such that both external and internal use this table to keep track of load status -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3660) Add support for unnesting anti semijoins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3660?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3660: ---------------------------------- Fix Version/s: 9.0 (was: 8.12) > Add support for unnesting anti semijoins > ---------------------------------------- > > Key: TEIID-3660 > URL: https://issues.jboss.org/browse/TEIID-3660 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > Currently we won't perform the rewrite if it's the anit case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3396) Redis Connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3396?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3396: ---------------------------------- Fix Version/s: 9.0 (was: 8.12) > Redis Connector > ---------------- > > Key: TEIID-3396 > URL: https://issues.jboss.org/browse/TEIID-3396 > Project: Teiid > Issue Type: Enhancement > Components: Connector API > Affects Versions: 8.11 > Reporter: Devin Pinkston > Assignee: Steven Hawkins > Priority: Minor > Fix For: 9.0 > > > Resource Adapter and Translator for Redis store (http://redis.io/) > Using Jedis client (https://github.com/xetorthio/jedis) > https://github.com/pinkdevelops/teiid -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3454) Dependent Join optimizations for Netezza and Hive

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3454?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3454: ---------------------------------- Fix Version/s: 9.0 (was: 8.12) > Dependent Join optimizations for Netezza and Hive > ------------------------------------------------- > > Key: TEIID-3454 > URL: https://issues.jboss.org/browse/TEIID-3454 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.10 > Reporter: John Muller > Assignee: Steven Hawkins > Priority: Minor > Fix For: 9.0 > > > Currently, dependent joins create 1 or more IN clauses. Many MPP / NoSQL systems can have drastically better performance by creating temp tables that match key distributions. Two examples I know of would be Netezza and Hive. > In Netezza, if the incoming dependent join (small dimension; here "Customer" using Northwind data model concepts) has a key that will be joined to to a big fact table that is DISTRIBUTED ON or ORGANIZED BY 'ed then creating a temp table that matches this distribution will result in ~100x query performance. Sometimes, if the dimension is small enough, this doesn't make a big difference as Netezza will perform a broadcast join, but it's never a bad idea to create the temp table. > Similarly, Hive DDL has both partitions and buckets (pre-sorted). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3541) Remove the Teiid embedded kit

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3541?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3541: ---------------------------------- Fix Version/s: 9.0 (was: 8.12) > Remove the Teiid embedded kit > ----------------------------- > > Key: TEIID-3541 > URL: https://issues.jboss.org/browse/TEIID-3541 > Project: Teiid > Issue Type: Task > Components: Embedded > Reporter: Ramesh Reddy > Assignee: Kylin Soong > Fix For: 9.0 > > > There is no reason to keep a separate embedded kit supplied by Teiid. The scripts that are building the kit needs to be removed from build. > All the required jar files for the "embedded" examples will be available from the "teiid-embedded-examples". Here we need to focus on documentation, but that is separate effort -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3425) Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3425?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3425. ----------------------------------- Resolution: Deferred It doesn't appear we will address this issue due to issues with the IBM JRE. > Pass-through kerberos authentication on IBM JDK - principal is not passed to MSSQL driver > ----------------------------------------------------------------------------------------- > > Key: TEIID-3425 > URL: https://issues.jboss.org/browse/TEIID-3425 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: Fedora 20 > java: IBM JDK 1.7 > arch: x86_64 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 8.12 > > Attachments: set-up-mssql-ibm.cli, sql2012krb-static-vdb.xml, sql2012krb-vdb.xml > > > I have configured a datasource for MSSQL database. The datasource uses PassthroughIdentityLoginModule. I have also created a VDB which requires kerberos authentication. I am trying to pass credentials used for authentication CLIENT <=> TEIID to datasource so they can be used for authentication TEIID <=> MSSQL. > Method getConnection(..) (record in server log) is called with correct credentials, but SQLServerDriver throws an exception: > initAuthInit failed privileged exception:-java.security.PrivilegedActionException: org.ietf.jgss.GSSException, major code: 13, minor code: 0 > major string: Invalid credentials > minor string: Cannot get credential from JAAS Subject for principal: default principal > Some ideas, but I am only guessing: > 1. I have seen same exception (on client side) if system property "javax.security.auth.useSubjectCredsOnly" is set to false on client side. As this property is set to true in the server config (<property name="javax.security.auth.useSubjectCredsOnly" value="true"/>), it is probably not passed to the driver (or is being ignored). > 2. SQLServerDriver sets two system properties by default (if no kerberos configuration file is specified) useDefaultCcache = true moduleBanner = false - see https://msdn.microsoft.com/en-us/library/gg558122%28v=sql.110%29.aspx - ibm kerberos login module will try to get TGT from ticket cache > I have tried static kerberos configuration for same DS and there was no problem with it. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 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 September 2015