[IMPALA-2033] Netezza compatibility functions: misc.

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Later
• Affects Version/s: Impala 2.2
• Component/s: Backend
• Labels: built-in-function netezza ramp-up
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Henry Robinson
• Created: 28/May/15 16:57
• Updated: 16/May/17 05:36
• Resolved: 16/May/17 05:36

Description

See https://issues.cloudera.org/secure/attachment/12200/netezza-functions.pdf

• TIMESTAMP_CMP
• INT_MONTHS_BETWEEN
• TIMEOFDAY
• WIDTH_BUCKET (now IMPALA-4848)
• QUOTE_LITERAL

Netezza

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)

Vertica

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)

Issue Links

• is related to: IMPALA-4848 add WIDTH_BUCKET() function