[JBoss JIRA] (TEIID-3887) Redshift - RS does not support ASCII function
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3887?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3887.
-----------------------------------
Resolution: Done
Resolved with a new redshift translator TEIID-3890
> Redshift - RS does not support ASCII function
> ----------------------------------------------
>
> Key: TEIID-3887
> URL: https://issues.jboss.org/browse/TEIID-3887
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.3
> Environment: driver - PostgreSQL 9.2
> translator - postgresql
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Redshift database does not support ASCII function
> E.g. *SELECT INTKEY, ASCII(INTKEY) FROM BQT1.SmallA ORDER BY INTKEY* is translated as *SELECT g_0.intkey AS c_0, ascii(cast(g_0.intkey AS varchar(4000))) AS c_1 FROM smalla AS g_0 ORDER BY c_0*
> Result:
> {code:text}
> Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables.
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3885) Redshift - conversion to time does not work
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3885?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3885.
-----------------------------------
Resolution: Done
Resolved with a new redshift translator TEIID-3890
> Redshift - conversion to time does not work
> -------------------------------------------
>
> Key: TEIID-3885
> URL: https://issues.jboss.org/browse/TEIID-3885
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Conversion to TIME data type does not work for Redshift (using postgresql translator).
> E.g.: SELECT CONVERT(timestampvalue, time) FROM Source.SmallA
> Result:
> {code:text}
> 14:08:36,300 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue158) Source-specific command: SELECT cast(date_trunc('second', g_0.timevalue) AS time) FROM smalla AS g_0
> 14:08:36,481 WARN [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue158) Connector worker process failed for atomic-request=ajCOQrzOcEmF.3.0.36: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(date_trunc('second', g_0.timevalue) AS time) FROM smalla AS g_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:349)
> at sun.reflect.GeneratedMethodAccessor189.invoke(Unknown Source) [:1.8.0_40]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_40]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_40]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy124.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:266) [rt.jar:1.8.0_40]
> 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:1142) [rt.jar:1.8.0_40]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
> Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables.
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
> 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.3.redhat-1.jar:8.12.3.redhat-1]
> ... 17 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3885) Redshift - conversion to time does not work
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3885?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3885:
----------------------------------
Component/s: JDBC Connector
> Redshift - conversion to time does not work
> -------------------------------------------
>
> Key: TEIID-3885
> URL: https://issues.jboss.org/browse/TEIID-3885
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.3
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Conversion to TIME data type does not work for Redshift (using postgresql translator).
> E.g.: SELECT CONVERT(timestampvalue, time) FROM Source.SmallA
> Result:
> {code:text}
> 14:08:36,300 DEBUG [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue158) Source-specific command: SELECT cast(date_trunc('second', g_0.timevalue) AS time) FROM smalla AS g_0
> 14:08:36,481 WARN [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue158) Connector worker process failed for atomic-request=ajCOQrzOcEmF.3.0.36: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT cast(date_trunc('second', g_0.timevalue) AS time) FROM smalla AS g_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.3.redhat-1.jar:8.12.3.redhat-1]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:349)
> at sun.reflect.GeneratedMethodAccessor189.invoke(Unknown Source) [:1.8.0_40]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_40]
> at java.lang.reflect.Method.invoke(Method.java:497) [rt.jar:1.8.0_40]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211)
> at com.sun.proxy.$Proxy124.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:266) [rt.jar:1.8.0_40]
> 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:1142) [rt.jar:1.8.0_40]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_40]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_40]
> Caused by: org.postgresql.util.PSQLException: ERROR: Specified types or functions (one per INFO message) not supported on Redshift tables.
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
> 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.3.redhat-1.jar:8.12.3.redhat-1]
> ... 17 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3890) Add a redshift translator
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3890:
-------------------------------------
Summary: Add a redshift translator
Key: TEIID-3890
URL: https://issues.jboss.org/browse/TEIID-3890
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.13, 8.12.4
To account for differences between Redshift and Postgres, a new translator should be added.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3881:
---------------------------------------
No problem, thanks for getting back to this so soon.
> time date function doesn't return value without sorting
> -------------------------------------------------------
>
> Key: TEIID-3881
> URL: https://issues.jboss.org/browse/TEIID-3881
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.3
> Environment: Teiid 8.12.3 and PostgreSQL 9.3.2
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
> Labels: teiid-engine
>
> HOUR(), MINUTE(), SECOND(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), MONTH(),
> QUARTER(), WEEK(), YEAR() are returning null unless sql is ordered by date time function.
> Not working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date"
> limit 200001
> Working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date", "Month_Field"
> limit 200001
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3881.
-----------------------------------
Resolution: Rejected
> time date function doesn't return value without sorting
> -------------------------------------------------------
>
> Key: TEIID-3881
> URL: https://issues.jboss.org/browse/TEIID-3881
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.3
> Environment: Teiid 8.12.3 and PostgreSQL 9.3.2
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
> Labels: teiid-engine
>
> HOUR(), MINUTE(), SECOND(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), MONTH(),
> QUARTER(), WEEK(), YEAR() are returning null unless sql is ordered by date time function.
> Not working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date"
> limit 200001
> Working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date", "Month_Field"
> limit 200001
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3881.
---------------------------------
> time date function doesn't return value without sorting
> -------------------------------------------------------
>
> Key: TEIID-3881
> URL: https://issues.jboss.org/browse/TEIID-3881
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.3
> Environment: Teiid 8.12.3 and PostgreSQL 9.3.2
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
> Labels: teiid-engine
>
> HOUR(), MINUTE(), SECOND(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), MONTH(),
> QUARTER(), WEEK(), YEAR() are returning null unless sql is ordered by date time function.
> Not working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date"
> limit 200001
> Working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date", "Month_Field"
> limit 200001
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin... ]
Steven Hawkins reopened TEIID-3881:
-----------------------------------
> time date function doesn't return value without sorting
> -------------------------------------------------------
>
> Key: TEIID-3881
> URL: https://issues.jboss.org/browse/TEIID-3881
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.3
> Environment: Teiid 8.12.3 and PostgreSQL 9.3.2
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
> Labels: teiid-engine
>
> HOUR(), MINUTE(), SECOND(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), MONTH(),
> QUARTER(), WEEK(), YEAR() are returning null unless sql is ordered by date time function.
> Not working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date"
> limit 200001
> Working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date", "Month_Field"
> limit 200001
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIID-3881) time date function doesn't return value without sorting
by Ivan Chan (JIRA)
[ https://issues.jboss.org/browse/TEIID-3881?page=com.atlassian.jira.plugin... ]
Ivan Chan commented on TEIID-3881:
----------------------------------
It seems like I made a mistake on my side. Sorry about it. Closing this issue now. Thanks for looking.
> time date function doesn't return value without sorting
> -------------------------------------------------------
>
> Key: TEIID-3881
> URL: https://issues.jboss.org/browse/TEIID-3881
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.12.3
> Environment: Teiid 8.12.3 and PostgreSQL 9.3.2
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
> Labels: teiid-engine
>
> HOUR(), MINUTE(), SECOND(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), MONTH(),
> QUARTER(), WEEK(), YEAR() are returning null unless sql is ordered by date time function.
> Not working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date"
> limit 200001
> Working query:
> select MONTH("birth_date") as "MONTH_birth_date",
> MONTH("birth_date") as "Month_Field",
> "birth_date"
> from "FoodmartDataSource_public"."employee"
> order by "birth_date", "Month_Field"
> limit 200001
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years