June 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5973) wrong type info for EPOCH return value

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5973?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5973. ----------------------------------- Resolution: Done Corrected the return type. > wrong type info for EPOCH return value > -------------------------------------- > > Key: TEIID-5973 > URL: https://issues.redhat.com/browse/TEIID-5973 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 14.0 > Reporter: Ken Geis > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0, 13.1.2, 14.0.1 > > Original Estimate: 45 minutes > Time Spent: 45 minutes > Remaining Estimate: 0 minutes > > The documentation states that EPOCH(..) and EXTRACT(EPOCH FROM ..) return double. I should be able to perform calculations on those. For example, I should be able to find the number of seconds since the epoch with > {code:sql} > SELECT EPOCH(NOW()) / 1000; > {code} > However, this query produces the error > {noformat} > TEIID30070 The function '(EPOCH(NOW()) / 1000)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.{noformat} > -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5973) wrong type info for EPOCH return value

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5973?focusedWorklogId=12451495&pag... ] Steven Hawkins logged work on TEIID-5973: ----------------------------------------- Author: Steven Hawkins Created on: 15/Jun/20 8:30 AM Start Date: 15/Jun/20 8:30 AM Worklog Time Spent: 45 minutes Issue Time Tracking ------------------- Remaining Estimate: 0 minutes (was: 45 minutes) Time Spent: 45 minutes Worklog Id: (was: 12451495) > wrong type info for EPOCH return value > -------------------------------------- > > Key: TEIID-5973 > URL: https://issues.redhat.com/browse/TEIID-5973 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 14.0 > Reporter: Ken Geis > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0, 13.1.2, 14.0.1 > > Original Estimate: 45 minutes > Time Spent: 45 minutes > Remaining Estimate: 0 minutes > > The documentation states that EPOCH(..) and EXTRACT(EPOCH FROM ..) return double. I should be able to perform calculations on those. For example, I should be able to find the number of seconds since the epoch with > {code:sql} > SELECT EPOCH(NOW()) / 1000; > {code} > However, this query produces the error > {noformat} > TEIID30070 The function '(EPOCH(NOW()) / 1000)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.{noformat} > -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5973) wrong type info for EPOCH return value

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5973?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5973: ---------------------------------- Component/s: Query Engine Fix Version/s: 15.0 13.1.2 14.0.1 Original Estimate: 45 minutes Remaining Estimate: 45 minutes Story Points: 0.1 Sprint: DV Sprint 65 > wrong type info for EPOCH return value > -------------------------------------- > > Key: TEIID-5973 > URL: https://issues.redhat.com/browse/TEIID-5973 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 14.0 > Reporter: Ken Geis > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0, 13.1.2, 14.0.1 > > Original Estimate: 45 minutes > Remaining Estimate: 45 minutes > > The documentation states that EPOCH(..) and EXTRACT(EPOCH FROM ..) return double. I should be able to perform calculations on those. For example, I should be able to find the number of seconds since the epoch with > {code:sql} > SELECT EPOCH(NOW()) / 1000; > {code} > However, this query produces the error > {noformat} > TEIID30070 The function '(EPOCH(NOW()) / 1000)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.{noformat} > -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5973) wrong type info for EPOCH return value

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5973?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5973: --------------------------------------- > For example, I should be able to find the number of seconds since the epoch with It will already return the number of seconds. > However, this query produces the error Yes that needs to be corrected. The function metadata is being inferred from the method, but the return type was left as object. A workaroud is to add a cast: SELECT cast(EPOCH(NOW()) as double) / 1000; > wrong type info for EPOCH return value > -------------------------------------- > > Key: TEIID-5973 > URL: https://issues.redhat.com/browse/TEIID-5973 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 14.0 > Reporter: Ken Geis > Assignee: Steven Hawkins > Priority: Major > > The documentation states that EPOCH(..) and EXTRACT(EPOCH FROM ..) return double. I should be able to perform calculations on those. For example, I should be able to find the number of seconds since the epoch with > {code:sql} > SELECT EPOCH(NOW()) / 1000; > {code} > However, this query produces the error > {noformat} > TEIID30070 The function '(EPOCH(NOW()) / 1000)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.{noformat} > -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5974) Can't Use Console to Change Logging Configuration

by Mike Higgins (Jira)

Mike Higgins created TEIID-5974: ----------------------------------- Summary: Can't Use Console to Change Logging Configuration Key: TEIID-5974 URL: https://issues.redhat.com/browse/TEIID-5974 Project: Teiid Issue Type: Bug Affects Versions: 12.2 Reporter: Mike Higgins Assignee: Steven Hawkins Could be a problem on my end, but Installing this version with Wildfly does not let me access the configuration->logging web console page. It comes up blank. I use this to change the command logging level on a running server. Seems to happen in version 13, also. I tried using the checkboxes in subsystem>teiid>configure>logging but they did not seem to change the level. Please let me know if this if reproducible for you. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5973) wrong type info for EPOCH return value

by Ken Geis (Jira)

Ken Geis created TEIID-5973: ------------------------------- Summary: wrong type info for EPOCH return value Key: TEIID-5973 URL: https://issues.redhat.com/browse/TEIID-5973 Project: Teiid Issue Type: Enhancement Affects Versions: 14.0 Reporter: Ken Geis Assignee: Steven Hawkins The documentation states that EPOCH(..) and EXTRACT(EPOCH FROM ..) return double. I should be able to perform calculations on those. For example, I should be able to find the number of seconds since the epoch with {code:sql} SELECT EPOCH(NOW()) / 1000; {code} However, this query produces the error {noformat} TEIID30070 The function '(EPOCH(NOW()) / 1000)' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.{noformat} -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5963) Teiid using all typeInfo takes too long from PG

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5963. ----------------------------------- Resolution: Done Added an import property useTypeInfo that can be disabled for scenarios such as this. > Teiid using all typeInfo takes too long from PG > ----------------------------------------------- > > Key: TEIID-5963 > URL: https://issues.redhat.com/browse/TEIID-5963 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 14.0 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Original Estimate: 3 hours > Remaining Estimate: 3 hours > > When we started teiid spring boot app, we have long start time. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5963) Teiid using all typeInfo takes too long from PG

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5963?focusedWorklogId=12451413&pag... ] Steven Hawkins logged work on TEIID-5963: ----------------------------------------- Author: Steven Hawkins Created on: 12/Jun/20 4:15 PM Start Date: 12/Jun/20 4:15 PM Worklog Time Spent: 1 hour, 30 minutes Work Description: Time spent on commenting, creating, and documenting a solution. Issue Time Tracking ------------------- Remaining Estimate: 1 hour, 30 minutes (was: 3 hours) Time Spent: 1 hour, 30 minutes Worklog Id: (was: 12451413) > Teiid using all typeInfo takes too long from PG > ----------------------------------------------- > > Key: TEIID-5963 > URL: https://issues.redhat.com/browse/TEIID-5963 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 14.0 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > Fix For: 15.0 > > Original Estimate: 3 hours > Time Spent: 1 hour, 30 minutes > Remaining Estimate: 1 hour, 30 minutes > > When we started teiid spring boot app, we have long start time. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5971) Hidden connection config

by Renat Eskenin (Jira)

[ https://issues.redhat.com/browse/TEIID-5971?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIID-5971: -------------------------------------- Hi! Ok, I understanded what you mean :) You have multiple places for bugs. I'm sorry, yes of course I will make new bugs in appropriate place. > Hidden connection config > ------------------------ > > Key: TEIID-5971 > URL: https://issues.redhat.com/browse/TEIID-5971 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 14.0 > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > In > SalesforceConnectionImpl:31 > private SalesforceConnectorConfig config; > In > BaseSalesforceConnection:77 > protected ConnectorConfig config; > When call > BaseSalesforceConnection:82 > we get NPE because > protected ConnectorConfig config == null; -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-211) create an s3 file source

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-211?page=com.atlassian.jira.plug... ] Steven Hawkins reassigned TEIIDSB-211: -------------------------------------- Assignee: Aditya Manglam Sharma (was: Steven Hawkins) > create an s3 file source > ------------------------- > > Key: TEIIDSB-211 > URL: https://issues.redhat.com/browse/TEIIDSB-211 > Project: Teiid Spring Boot > Issue Type: Feature Request > Components: datasource > Reporter: Steven Hawkins > Assignee: Aditya Manglam Sharma > Priority: Major > Fix For: 1.6.0 > > > The existing s3 support is implemented as a translator / ws source combo. We instead need this to be just a source to allow for translators to utilize it (excel, parquet, avro). > As an alternative to our existing support we should evaluate utilizing the sdk rather than providing our own processing logic. More than likely this will be a quicker path to things like s3 select support. However ceph seems to lag in s3 support (see TEIID-5935 and no s3 select support) so we'd have to compensate, make the metadata and/or the capabilities specific to the connection type. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2020