Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2033

Netezza compatibility functions: misc.

    XMLWordPrintableJSON

    Details

      Description

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

      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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                henryr Henry Robinson
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: