September 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5026) Add function to transform timestamp into Unix time

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-5026?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-5026: ------------------------------------ [~shawkins] for the JDG integration there is a workaround with using string data type in source DDL instead of timestamps. So this enhancement can be considered outside of that context. > Add function to transform timestamp into Unix time > -------------------------------------------------- > > Key: TEIID-5026 > URL: https://issues.jboss.org/browse/TEIID-5026 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Jan Stastny > Assignee: Steven Hawkins > Fix For: 10.0 > > > Teiid supports function FROM_UNIXTIME as a result of TEIID-248. > There isn't its reverse counterpart though. > This is an issue, when there is a data source which doesn't support timestamp/date/time data types: > * users choose to use long(unix time) in the source > * by using FROM_UNIXTIME function they transform the long value (unix time) into respective data type value in their virtual model > * they can read such source. > * they can't insert/update it as this would require 'INSTEAD OF TRIGGER' with ability to transform timestamp/time/date back to long value - Unix time. This part is missing. > As an example could serve [MySQL's UNIX_TIMESTAMP|https://dev.mysql.com/doc/refman/5.5/en/date-and-time-func...] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5026) Add function to transform timestamp into Unix time

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5026?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5026: --------------------------------------- > So this enhancement can be considered exactly that. My confusion is that this seemed to stem from JDG integration, which seems like it would use millis/longs instead. Looking at this more, I think our implementation of from_unixtime is not correct. The other vendors use it as a conversion to string, not to timestamp - although in many contexts that distinction won't matter. I'll see if there is a way to rationalize all of this. > Add function to transform timestamp into Unix time > -------------------------------------------------- > > Key: TEIID-5026 > URL: https://issues.jboss.org/browse/TEIID-5026 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Jan Stastny > Assignee: Steven Hawkins > Fix For: 10.0 > > > Teiid supports function FROM_UNIXTIME as a result of TEIID-248. > There isn't its reverse counterpart though. > This is an issue, when there is a data source which doesn't support timestamp/date/time data types: > * users choose to use long(unix time) in the source > * by using FROM_UNIXTIME function they transform the long value (unix time) into respective data type value in their virtual model > * they can read such source. > * they can't insert/update it as this would require 'INSTEAD OF TRIGGER' with ability to transform timestamp/time/date back to long value - Unix time. This part is missing. > As an example could serve [MySQL's UNIX_TIMESTAMP|https://dev.mysql.com/doc/refman/5.5/en/date-and-time-func...] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5002) Use WildFly 11 Server Environment

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5002?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5002: --------------------------------------- Netty deprecated a method when it actually should have been removed. In ObjectEncoder.AnonymousChunkedStream use: {code} public ByteBuf readChunk(ByteBufAllocator allocator) throws Exception { ByteBuf cb = super.readChunk(allocator); {code} Instead of the old readChunk signature. > Use WildFly 11 Server Environment > --------------------------------- > > Key: TEIID-5002 > URL: https://issues.jboss.org/browse/TEIID-5002 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.0 > > > Move the server environment to latest WildFly version 11 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5026) Add function to transform timestamp into Unix time

by Jan Stastny (JIRA)

[ https://issues.jboss.org/browse/TEIID-5026?page=com.atlassian.jira.plugin... ] Jan Stastny commented on TEIID-5026: ------------------------------------ Like I indicated above. I've thought of this enhancement as adding the reverse option to FROM_UNIXTIME, which works with seconds. So this enhancement can be considered exactly that. The MySQL implementation returns seconds. PostgreSQL on the other hand offers more complex solution with using export function https://www.postgresql.org/docs/9.2/static/functions-datetime.html which is probably larger scope though. > Add function to transform timestamp into Unix time > -------------------------------------------------- > > Key: TEIID-5026 > URL: https://issues.jboss.org/browse/TEIID-5026 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Jan Stastny > Assignee: Steven Hawkins > Fix For: 10.0 > > > Teiid supports function FROM_UNIXTIME as a result of TEIID-248. > There isn't its reverse counterpart though. > This is an issue, when there is a data source which doesn't support timestamp/date/time data types: > * users choose to use long(unix time) in the source > * by using FROM_UNIXTIME function they transform the long value (unix time) into respective data type value in their virtual model > * they can read such source. > * they can't insert/update it as this would require 'INSTEAD OF TRIGGER' with ability to transform timestamp/time/date back to long value - Unix time. This part is missing. > As an example could serve [MySQL's UNIX_TIMESTAMP|https://dev.mysql.com/doc/refman/5.5/en/date-and-time-func...] -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5002) Use WildFly 11 Server Environment

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5002?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5002: --------------------------------------- I'll have a look. > Use WildFly 11 Server Environment > --------------------------------- > > Key: TEIID-5002 > URL: https://issues.jboss.org/browse/TEIID-5002 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.0 > > > Move the server environment to latest WildFly version 11 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4992) Add OSDQ set functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4992?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-4992 at 9/6/17 8:11 PM: --------------------------------------------------------------- [~osdq]The intersect and union operations are not symmetric. If you have: {code} String[] first = new String[]{"vivek16","abcd","vivek44", "x", "xx"}; String[] second = new String[]{"vivek36","vivekkk","abcd","vivek445", "x"}; //these will return different values intersectionFuzzy(first,second,1); intersectionFuzzy(second,first,1); {code} It seems like the logic should account for the fuzzing within both sets, such that these operations should be symmetrical. was (Author: shawkins): [~osdq]The intersect and union operations are not symmetric. If you have: String[] first = new String[]{"vivek16","abcd","vivek44", "x", "xx"}; String[] second = new String[]{"vivek36","vivekkk","abcd","vivek445", "x"}; //these will return different values intersectionFuzzy(first,second,1); intersectionFuzzy(second,first,1); It seems like the logic should account for the fuzzing within both sets, such that these operations should be symmetrical. > Add OSDQ set functions > ---------------------- > > Key: TEIID-4992 > URL: https://issues.jboss.org/browse/TEIID-4992 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > Attachments: SetUtil.java > > > There will be a new osdq core library drop in maven central soon containing additional functions for Teiid to add. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4992) Add OSDQ set functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4992?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4992: --------------------------------------- [~osdq]The intersect and union operations are not symmetric. If you have: String[] first = new String[]{"vivek16","abcd","vivek44", "x", "xx"}; String[] second = new String[]{"vivek36","vivekkk","abcd","vivek445", "x"}; //these will return different values intersectionFuzzy(first,second,1); intersectionFuzzy(second,first,1); It seems like the logic should account for the fuzzing within both sets, such that these operations should be symmetrical. > Add OSDQ set functions > ---------------------- > > Key: TEIID-4992 > URL: https://issues.jboss.org/browse/TEIID-4992 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > Attachments: SetUtil.java > > > There will be a new osdq core library drop in maven central soon containing additional functions for Teiid to add. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5002) Use WildFly 11 Server Environment

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5002?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5002: ------------------------------------- [~shawkins] I have this in a branch at https://github.com/rareddy/teiid/tree/TEIID-5002 for WF 11 CR1. I have one test failing with netty stuff I could not resolve could you take a look. TestCommSockets. Once the final is released then we can upgrade to that, that should be hopefully in next couple weeks. I need to figure out how far WildFly Swarm behind this release or simultaneous. > Use WildFly 11 Server Environment > --------------------------------- > > Key: TEIID-5002 > URL: https://issues.jboss.org/browse/TEIID-5002 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 10.0 > > > Move the server environment to latest WildFly version 11 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4944) Remove misc deprecated code

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4944?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4944. ----------------------------------- Resolution: Done The remaining deprecations are either trivial and public or were introduced in 9.x, so this should be sufficient for 10.0. > Remove misc deprecated code > --------------------------- > > Key: TEIID-4944 > URL: https://issues.jboss.org/browse/TEIID-4944 > Project: Teiid > Issue Type: Task > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.0 > > > With a new major release we can remove older deprecated code. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5015) Redesign Teiid.org site

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIID-5015?page=com.atlassian.jira.plugin... ] Barry LaFond commented on TEIID-5015: ------------------------------------- [~shawkins] [~rareddy] Another template we could use is http://www.apicur.io/ > Redesign Teiid.org site > ----------------------- > > Key: TEIID-5015 > URL: https://issues.jboss.org/browse/TEIID-5015 > Project: Teiid > Issue Type: Task > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.x > > > The website is currently in awestruct and needs updated to a new look and feel, and the consolidation of the tooling efforts. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 7 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 2017