You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Greg Rahn (JIRA)" <ji...@apache.org> on 2017/05/16 05:37:04 UTC
[jira] [Closed] (IMPALA-2033) Netezza compatibility functions:
misc.
[ https://issues.apache.org/jira/browse/IMPALA-2033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Greg Rahn closed IMPALA-2033.
-----------------------------
Resolution: Later
Closing. If these come up again we can add them.
> Netezza compatibility functions: misc.
> --------------------------------------
>
> Key: IMPALA-2033
> URL: https://issues.apache.org/jira/browse/IMPALA-2033
> Project: IMPALA
> Issue Type: Improvement
> Components: Backend
> Affects Versions: Impala 2.2
> Reporter: Henry Robinson
> Priority: Minor
> Labels: built-in-function, netezza, ramp-up
>
> See https://issues.cloudera.org/secure/attachment/12200/netezza-functions.pdf
> * {{[-TIMESTAMP_CMP-|http://www.cloudera.com/documentation/enterprise/5-7-x/topics/impala_datetime_functions.html#datetime_functions__timestamp_cmp]}}
> * {{[-INT_MONTHS_BETWEEN-|http://www.cloudera.com/documentation/enterprise/5-7-x/topics/impala_datetime_functions.html#datetime_functions__int_months_between]}}
> * {{[TIMEOFDAY|https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Date-Time/TIMEOFDAY.htm]}}
> * {{[-WIDTH_BUCKET-|https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Mathematical/WIDTH_BUCKET.htm]}} (now IMPALA-4848)
> * {{[QUOTE_LITERAL|https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/String/QUOTE_LITERAL.htm]}}
> *Netezza*
> {code}
> SYSTEM.ADMIN(ADMIN)=> \df timeofday
> List of functions
> SCHEMA | RESULT | FUNCTION | BUILTIN | ARGUMENTS
> -------------------+-------------------+-----------+---------+-----------
> DEFINITION_SCHEMA | CHARACTER VARYING | TIMEOFDAY | t | ()
> (1 row)
> SYSTEM.ADMIN(ADMIN)=> \df width_bucket
> List of functions
> SCHEMA | RESULT | FUNCTION | BUILTIN | ARGUMENTS
> -------------------+---------+--------------+---------+-----------------------------------------------------------------
> DEFINITION_SCHEMA | INTEGER | WIDTH_BUCKET | t | (DOUBLE PRECISION, DOUBLE PRECISION, DOUBLE PRECISION, INTEGER)
> (1 row)
> SYSTEM.ADMIN(ADMIN)=> \df quote_literal
> List of functions
> SCHEMA | RESULT | FUNCTION | BUILTIN | ARGUMENTS
> -------------------+----------------------------+---------------+---------+-----------------------------------
> DEFINITION_SCHEMA | NATIONAL CHARACTER VARYING | QUOTE_LITERAL | t | (NATIONAL CHARACTER VARYING(ANY))
> (1 row)
> {code}
> *Vertica*
> {code}
> dbadmin=> \df timeofday
> List of functions
> procedure_name | procedure_return_type | procedure_argument_types
> ----------------+-----------------------+--------------------------
> timeofday | Varchar |
> (1 row)
> dbadmin=> \df width_bucket
> List of functions
> procedure_name | procedure_return_type | procedure_argument_types
> ----------------+-----------------------+---------------------------------------------------------------------------------
> width_bucket | Integer | Float, Float, Float, Integer
> width_bucket | Integer | Interval Day to Second, Interval Day to Second, Interval Day to Second, Integer
> width_bucket | Integer | Interval Year to Month, Interval Year to Month, Interval Year to Month, Integer
> width_bucket | Integer | Time, Time, Time, Integer
> width_bucket | Integer | Timestamp, Timestamp, Timestamp, Integer
> (5 rows)
> dbadmin=> \df quote_literal
> List of functions
> procedure_name | procedure_return_type | procedure_argument_types
> ----------------+-----------------------+--------------------------
> quote_literal | Varchar | Varchar
> (1 row)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)