November 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3227) Add support for sub-expression pushing of must pushdown functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-3227 at 11/24/14 12:16 PM: ------------------------------------------------------------------ If the function is deterministic, then it's valid to create the pushdown form but we would need to add an aggregate such as first/last or add the function to the grouping (although that wouldn't quite be correct for rollups). So more than likely this would look like: SELECT AAA, SUM(first\(x)) AS BBB_ALIAS FROM (select AAA, custom_function(BBB) as x from some_table WHERE some_table.CCC = 'VAL') as v GROUP BY AAA ORDER BY AAA Detecting this is also a little different than the existing must pushdown logic in RuleAssignOutputElements in that we're actually dealing with the grouping node and not a project node when this determination needs to be made. Although we could rationalize this by inserting an explicit project node, rather than the current logic in the grouping processing node that performs the necessary projection. was (Author: shawkins): If the function is deterministic, then it's valid to create the pushdown form but we would need to add an aggregate such as first/last or add the function to the grouping (although that wouldn't quite be correct for rollups). So more than likely this would look like: SELECT AAA, SUM(first(x)) AS BBB_ALIAS FROM (select AAA, custom_function(BBB) as x from some_table WHERE some_table.CCC = 'VAL') as v GROUP BY AAA ORDER BY AAA Detecting this is also a little different than the existing must pushdown logic in RuleAssignOutputElements in that we're actually dealing with the grouping node and not a project node when this determination needs to be made. Although we could rationalize this by inserting an explicit project node, rather than the current logic in the grouping processing node that performs the necessary projection. > Add support for sub-expression pushing of must pushdown functions > ----------------------------------------------------------------- > > Key: TEIID-3227 > URL: https://issues.jboss.org/browse/TEIID-3227 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.9 > Reporter: Michał Warecki > Assignee: Steven Hawkins > Priority: Minor > > As a user I'd like to have a possibility to push down sub-expressions of must pushdown functions. > Example: > Input query with not supported group by: > SELECT AAA, SUM(custom_function(BBB)) AS BBB_ALIAS FROM some_table WHERE some_table.CCC = 'VAL' GROUP BY AAA ORDER BY AAA > > Output query (processed by teiid): > SELECT AAA, BBB AS BBB_ALIAS FROM some_table.CCC = 'VAL' > > What I think it should looks like: > SELECT AAA, custom_function(BBB) AS BBB_ALIAS FROM some_table.CCC = 'VAL' > https://developer.jboss.org/message/910926#910926 -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3227) Add support for sub-expression pushing of must pushdown functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3227?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3227: --------------------------------------- If the function is deterministic, then it's valid to create the pushdown form but we would need to add an aggregate such as first/last or add the function to the grouping (although that wouldn't quite be correct for rollups). So more than likely this would look like: SELECT AAA, SUM(first(x)) AS BBB_ALIAS FROM (select AAA, custom_function(BBB) as x from some_table WHERE some_table.CCC = 'VAL') as v GROUP BY AAA ORDER BY AAA Detecting this is also a little different than the existing must pushdown logic in RuleAssignOutputElements in that we're actually dealing with the grouping node and not a project node when this determination needs to be made. Although we could rationalize this by inserting an explicit project node, rather than the current logic in the grouping processing node that performs the necessary projection. > Add support for sub-expression pushing of must pushdown functions > ----------------------------------------------------------------- > > Key: TEIID-3227 > URL: https://issues.jboss.org/browse/TEIID-3227 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.9 > Reporter: Michał Warecki > Assignee: Steven Hawkins > Priority: Minor > > As a user I'd like to have a possibility to push down sub-expressions of must pushdown functions. > Example: > Input query with not supported group by: > SELECT AAA, SUM(custom_function(BBB)) AS BBB_ALIAS FROM some_table WHERE some_table.CCC = 'VAL' GROUP BY AAA ORDER BY AAA > > Output query (processed by teiid): > SELECT AAA, BBB AS BBB_ALIAS FROM some_table.CCC = 'VAL' > > What I think it should looks like: > SELECT AAA, custom_function(BBB) AS BBB_ALIAS FROM some_table.CCC = 'VAL' > https://developer.jboss.org/message/910926#910926 -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3231) Timezone of DV server has influence on Date and Timestamp columns in some data sources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3231?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3231: --------------------------------------- >From the BZ it says JDG, MongoDB and Solr are affected. At least for JDG and MongoDB there is no remote notion of a Calendar based timestamp. That is to say it's all UTC so you would expect date/time/timestamp values to display differently in different local timezones vs. the remote. I assume that Solr is the same. This is not entirely undesirable behavior if you want to keep the original UTC value. The approaches would be to have the respective translators updated with a server timezone setting (similar to JDBC) and have the translator adjust the utc value to keep the calendar fields consistent. Or don't work an enhancement and let the user manually use the modifytimezone system function. > Timezone of DV server has influence on Date and Timestamp columns in some data sources > -------------------------------------------------------------------------------------- > > Key: TEIID-3231 > URL: https://issues.jboss.org/browse/TEIID-3231 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Timezone of DV server has influence on Date and Timestamp columns in some data sources -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3232) Embedded dist zip for 8.9.0 is missing from repo

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3232?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3232: --------------------------------------- Nexus reported that the staging repo closed and was published. Don't know if this is something that happened after the fact. > Embedded dist zip for 8.9.0 is missing from repo > ------------------------------------------------ > > Key: TEIID-3232 > URL: https://issues.jboss.org/browse/TEIID-3232 > Project: Teiid > Issue Type: Bug > Components: Build/Kits, Embedded > Affects Versions: 8.9 > Environment: Java version: 1.7.0_71, vendor: Oracle Corporation > Java home: C:\Program Files\Java\jdk1.7.0_71\jre > Default locale: en_US, platform encoding: Cp1252 > OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows" > Ant 1.9.4 > Ivy 2.3.0 > Reporter: Gary Gregory > Assignee: Steven Hawkins > Priority: Blocker > > For version 8.8.1, our build uses > https://repository.jboss.org/org/jboss/teiid/teiid/8.8.1/teiid-8.8.1-embe... > There is no such zip for 8.9.0. > In fact there are no useful files in https://repository.jboss.org/org/jboss/teiid/teiid/8.9.0.Final > Help! -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3232) Embedded dist zip for 8.9.0 is missing from repo

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3232?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3232: ------------------------------------- We been having some issues with JBoss Nexus in pushing the artifacts. Meanwhile you can download the artifacts from download site > Embedded dist zip for 8.9.0 is missing from repo > ------------------------------------------------ > > Key: TEIID-3232 > URL: https://issues.jboss.org/browse/TEIID-3232 > Project: Teiid > Issue Type: Bug > Components: Build/Kits, Embedded > Affects Versions: 8.9 > Environment: Java version: 1.7.0_71, vendor: Oracle Corporation > Java home: C:\Program Files\Java\jdk1.7.0_71\jre > Default locale: en_US, platform encoding: Cp1252 > OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows" > Ant 1.9.4 > Ivy 2.3.0 > Reporter: Gary Gregory > Assignee: Steven Hawkins > Priority: Blocker > > For version 8.8.1, our build uses > https://repository.jboss.org/org/jboss/teiid/teiid/8.8.1/teiid-8.8.1-embe... > There is no such zip for 8.9.0. > In fact there are no useful files in https://repository.jboss.org/org/jboss/teiid/teiid/8.9.0.Final > Help! -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3232) Embedded dist zip for 8.9.0 is missing from repo

by Gary Gregory (JIRA)

Gary Gregory created TEIID-3232: ----------------------------------- Summary: Embedded dist zip for 8.9.0 is missing from repo Key: TEIID-3232 URL: https://issues.jboss.org/browse/TEIID-3232 Project: Teiid Issue Type: Bug Components: Build/Kits, Embedded Affects Versions: 8.9 Environment: Java version: 1.7.0_71, vendor: Oracle Corporation Java home: C:\Program Files\Java\jdk1.7.0_71\jre Default locale: en_US, platform encoding: Cp1252 OS name: "windows 7", version: "6.1", arch: "amd64", family: "windows" Ant 1.9.4 Ivy 2.3.0 Reporter: Gary Gregory Assignee: Steven Hawkins Priority: Blocker For version 8.8.1, our build uses https://repository.jboss.org/org/jboss/teiid/teiid/8.8.1/teiid-8.8.1-embe... There is no such zip for 8.9.0. In fact there are no useful files in https://repository.jboss.org/org/jboss/teiid/teiid/8.9.0.Final Help! -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3231) Timezone of DV server has influence on Date and Timestamp columns in some data sources

by Van Halbert (JIRA)

Van Halbert created TEIID-3231: ---------------------------------- Summary: Timezone of DV server has influence on Date and Timestamp columns in some data sources Key: TEIID-3231 URL: https://issues.jboss.org/browse/TEIID-3231 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.7.1 Reporter: Van Halbert Assignee: Steven Hawkins Timezone of DV server has influence on Date and Timestamp columns in some data sources -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3231) Timezone of DV server has influence on Date and Timestamp columns in some data sources

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3231?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3231: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1167321 > Timezone of DV server has influence on Date and Timestamp columns in some data sources > -------------------------------------------------------------------------------------- > > Key: TEIID-3231 > URL: https://issues.jboss.org/browse/TEIID-3231 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Timezone of DV server has influence on Date and Timestamp columns in some data sources -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2816) HBase Connector/Translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2816?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2816: ------------------------------------- The intent is to use the Phoenix JDBC driver. There is no reason to duplicate the functionality in Teiid. > HBase Connector/Translator > -------------------------- > > Key: TEIID-2816 > URL: https://issues.jboss.org/browse/TEIID-2816 > Project: Teiid > Issue Type: Feature Request > Components: Connector API, JDBC Connector, JDBC Driver > Affects Versions: Open To Community > Reporter: devin pinkston > Assignee: Kylin Soong > Labels: HBase, Translator > Fix For: 8.10 > > > Develop a HBase translator/connector. Potentially using the Phoenix JDBC driver, supports most SQL and handles connections: > https://github.com/forcedotcom/phoenix -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3223: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1165132|https://bugzilla.redhat.com/show_bug.cgi?id=1165132] from NEW to MODIFIED > An issue with time in WHERE clause - SQLServer > ---------------------------------------------- > > Key: TEIID-3223 > URL: https://issues.jboss.org/browse/TEIID-3223 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora20 > arch: x86_64 > java: oracle 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.10 > > > Teiid is not able to manage WHERE clause with time value. > translator: sqlserver > base DB: SQL Server 2012/2008/2005 -- This message was sent by Atlassian JIRA (v6.3.8#6338)

11 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 November 2014