Vertica-OT-White
  • 11.1.x
    24.2.x 24.1.x 23.4.x 23.3.x 12.0.x 11.0.x 10.1.x 10.0.x 9.3.x 9.2.x 9.1.x 9.0.x 8.1.x
  • English
    中文
English
中文
  • Vertica Documentation
    • Supported platforms
    • New features
    • Getting started
    • Architecture
    • Installation
    • Eon
    • Containerized Vertica
    • Data load
    • Data analysis
    • Flex tables
    • Data export
    • MC
    • Administrator's guide
    • Security & authentication
    • Connecting to Vertica
    • Extending Vertica
    • Using Vertica on the cloud
    • Hadoop integration
    • Kafka integration
    • Spark integration
    • Voltage SecureData integration
    • SQL reference
      • System limits
      • Language elements
      • Data types
      • File systems & object stores
      • Functions
        • Aggregate functions
        • Analytic functions
        • AWS library functions
        • Collection functions
        • Date/time functions
        • Error-handling functions
        • Flex functions
        • Formatting functions
        • Geospatial functions
        • IP conversion functions
        • Load functions
        • Machine learning functions
        • Mathematical functions
        • NULL-handling functions
        • Pattern matching functions
        • Regular expression functions
        • Sequence functions
        • String functions
        • System information functions
        • Text search functions
        • Timeseries functions
        • URI encode/decode functions
        • UUID functions
        • Vertica meta-functions
          • Catalog management functions
            • DROP_LICENSE
            • DUMP_CATALOG
            • EXPORT_CATALOG
            • EXPORT_OBJECTS
            • EXPORT_TABLES
            • INSTALL_LICENSE
            • MARK_DESIGN_KSAFE
            • RELOAD_ADMINTOOLS_CONF
          • Client connection management functions
            • DESCRIBE_LOAD_BALANCE_DECISION
            • GET_CLIENT_LABEL
            • RESET_LOAD_BALANCE_POLICY
            • SET_CLIENT_LABEL
            • SET_LOAD_BALANCE_POLICY
          • Cloud management functions
            • AZURE_TOKEN_CACHE_CLEAR
          • Cluster management functions
            • REALIGN_CONTROL_NODES
            • REBALANCE_CLUSTER
            • RELOAD_SPREAD
            • SET_CONTROL_SET_SIZE
          • Cluster scaling functions
            • CANCEL_REBALANCE_CLUSTER
            • DISABLE_LOCAL_SEGMENTS
            • ENABLE_ELASTIC_CLUSTER
            • ENABLE_LOCAL_SEGMENTS
            • SET_SCALING_FACTOR
            • START_REBALANCE_CLUSTER
          • Communications functions
            • NOTIFY
          • Constraint management functions
            • ANALYZE_CONSTRAINTS
            • ANALYZE_CORRELATIONS
            • DISABLE_DUPLICATE_KEY_ERROR
            • LAST_INSERT_ID
            • REENABLE_DUPLICATE_KEY_ERROR
          • Data collector functions
            • CLEAR_DATA_COLLECTOR
            • DATA_COLLECTOR_HELP
            • FLUSH_DATA_COLLECTOR
            • GET_DATA_COLLECTOR_NOTIFY_POLICY
            • GET_DATA_COLLECTOR_POLICY
            • SET_DATA_COLLECTOR_NOTIFY_POLICY
            • SET_DATA_COLLECTOR_POLICY
            • SET_DATA_COLLECTOR_TIME_POLICY
          • DB designer functions
            • DESIGNER_ADD_DESIGN_QUERIES
            • DESIGNER_ADD_DESIGN_QUERIES_FROM_RESULTS
            • DESIGNER_ADD_DESIGN_QUERY
            • DESIGNER_ADD_DESIGN_TABLES
            • DESIGNER_CANCEL_POPULATE_DESIGN
            • DESIGNER_CREATE_DESIGN
            • DESIGNER_DESIGN_PROJECTION_ENCODINGS
            • DESIGNER_DROP_ALL_DESIGNS
            • DESIGNER_DROP_DESIGN
            • DESIGNER_OUTPUT_ALL_DESIGN_PROJECTIONS
            • DESIGNER_OUTPUT_DEPLOYMENT_SCRIPT
            • DESIGNER_RESET_DESIGN
            • DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY
            • DESIGNER_SET_DESIGN_KSAFETY
            • DESIGNER_SET_DESIGN_TYPE
            • DESIGNER_SET_OPTIMIZATION_OBJECTIVE
            • DESIGNER_SET_PROPOSE_UNSEGMENTED_PROJECTIONS
            • DESIGNER_SINGLE_RUN
            • DESIGNER_WAIT_FOR_DESIGN
          • DB management functions
            • CLEAR_RESOURCE_REJECTIONS
            • COMPACT_STORAGE
            • CURRENT_SCHEMA
            • DUMP_LOCKTABLE
            • DUMP_PARTITION_KEYS
            • GET_CONFIG_PARAMETER
            • KERBEROS_CONFIG_CHECK
            • MEMORY_TRIM
            • PURGE
            • RUN_INDEX_TOOL
            • SECURITY_CONFIG_CHECK
            • SET_CONFIG_PARAMETER
            • SET_SPREAD_OPTION
            • SHUTDOWN
          • Directed queries functions
            • EXPORT_DIRECTED_QUERIES
            • IMPORT_DIRECTED_QUERIES
          • Eon functions
            • ALTER_LOCATION_SIZE
            • BACKGROUND_DEPOT_WARMING
            • CANCEL_DEPOT_WARMING
            • CLEAN_COMMUNAL_STORAGE
            • CLEAR_DATA_DEPOT
            • CLEAR_DEPOT_PIN_POLICY_PARTITION
            • CLEAR_DEPOT_PIN_POLICY_PROJECTION
            • CLEAR_DEPOT_PIN_POLICY_TABLE
            • CLEAR_FETCH_QUEUE
            • DEMOTE_SUBCLUSTER_TO_SECONDARY
            • FINISH_FETCHING_FILES
            • FLUSH_REAPER_QUEUE
            • MIGRATE_ENTERPRISE_TO_EON
            • PROMOTE_SUBCLUSTER_TO_PRIMARY
            • REBALANCE_SHARDS
            • SET_DEPOT_PIN_POLICY_PARTITION
            • SET_DEPOT_PIN_POLICY_PROJECTION
            • SET_DEPOT_PIN_POLICY_TABLE
            • SHUTDOWN_SUBCLUSTER
            • START_REAPING_FILES
            • SYNC_CATALOG
          • Epoch management functions
            • ADVANCE_EPOCH
            • GET_AHM_EPOCH
            • GET_AHM_TIME
            • GET_CURRENT_EPOCH
            • GET_LAST_GOOD_EPOCH
            • MAKE_AHM_NOW
            • SET_AHM_EPOCH
            • SET_AHM_TIME
          • Flex table data functions
            • BUILD_FLEXTABLE_VIEW
            • COMPUTE_FLEXTABLE_KEYS
            • COMPUTE_FLEXTABLE_KEYS_AND_BUILD_VIEW
            • MATERIALIZE_FLEXTABLE_COLUMNS
            • RESTORE_FLEXTABLE_DEFAULT_KEYS_TABLE_AND_VIEW
          • Hadoop functions
            • CLEAR_HDFS_CACHES
            • EXTERNAL_CONFIG_CHECK
            • GET_METADATA
            • HADOOP_IMPERSONATION_CONFIG_CHECK
            • HASH_EXTERNAL_TOKEN
            • HCATALOGCONNECTOR_CONFIG_CHECK
            • HDFS_CLUSTER_CONFIG_CHECK
            • KERBEROS_HDFS_CONFIG_CHECK
            • SYNC_WITH_HCATALOG_SCHEMA
            • SYNC_WITH_HCATALOG_SCHEMA_TABLE
            • VERIFY_HADOOP_CONF_DIR
          • LDAP link functions
            • LDAP_LINK_DRYRUN_CONNECT
            • LDAP_LINK_DRYRUN_SEARCH
            • LDAP_LINK_DRYRUN_SYNC
            • LDAP_LINK_SYNC_CANCEL
            • LDAP_LINK_SYNC_START
          • License management functions
            • AUDIT
            • AUDIT_FLEX
            • AUDIT_LICENSE_SIZE
            • AUDIT_LICENSE_TERM
            • DISPLAY_LICENSE
            • GET_AUDIT_TIME
            • GET_COMPLIANCE_STATUS
            • SET_AUDIT_TIME
          • Multiple active result sets functions
            • CLOSE_ALL_RESULTSETS
            • CLOSE_RESULTSET
          • Partition management functions
            • CALENDAR_HIERARCHY_DAY
            • COPY_PARTITIONS_TO_TABLE
            • DROP_PARTITIONS
            • DUMP_PROJECTION_PARTITION_KEYS
            • DUMP_TABLE_PARTITION_KEYS
            • MOVE_PARTITIONS_TO_TABLE
            • PARTITION_PROJECTION
            • PARTITION_TABLE
            • PURGE_PARTITION
            • SWAP_PARTITIONS_BETWEEN_TABLES
          • Privileges & access functions
            • ENABLED_ROLE
            • GET_PRIVILEGES_DESCRIPTION
            • HAS_ROLE
            • RELEASE_SYSTEM_TABLES_ACCESS
            • RESTRICT_SYSTEM_TABLES_ACCESS
          • Profiling functions
            • CLEAR_PROFILING
            • DISABLE_PROFILING
            • ENABLE_PROFILING
            • SHOW_PROFILING_CONFIG
          • Projection management functions
            • CLEAR_PROJECTION_REFRESHES
            • EVALUATE_DELETE_PERFORMANCE
            • GET_PROJECTION_SORT_ORDER
            • GET_PROJECTION_STATUS
            • GET_PROJECTIONS
            • PURGE_PROJECTION
            • REFRESH
            • REFRESH_COLUMNS
            • START_REFRESH
          • Session management functions
            • CANCEL_REFRESH
            • CLOSE_ALL_SESSIONS
            • CLOSE_SESSION
            • CLOSE_USER_SESSIONS
            • GET_NUM_ACCEPTED_ROWS
            • GET_NUM_REJECTED_ROWS
            • INTERRUPT_STATEMENT
            • RELEASE_ALL_JVM_MEMORY
            • RELEASE_JVM_MEMORY
            • RESERVE_SESSION_RESOURCE
            • RESET_SESSION
          • Statistics management functions
            • ANALYZE_EXTERNAL_ROW_COUNT
            • ANALYZE_STATISTICS
            • ANALYZE_STATISTICS_PARTITION
            • DROP_EXTERNAL_ROW_COUNT
            • DROP_STATISTICS
            • DROP_STATISTICS_PARTITION
            • EXPORT_STATISTICS
            • EXPORT_STATISTICS_PARTITION
            • IMPORT_STATISTICS
            • VALIDATE_STATISTICS
          • Storage management functions
            • ALTER_LOCATION_LABEL
            • ALTER_LOCATION_USE
            • CLEAR_CACHES
            • CLEAR_OBJECT_STORAGE_POLICY
            • DROP_LOCATION
            • ENFORCE_OBJECT_STORAGE_POLICY
            • MEASURE_LOCATION_PERFORMANCE
            • MOVE_RETIRED_LOCATION_DATA
            • RESTORE_LOCATION
            • RETIRE_LOCATION
            • SET_LOCATION_PERFORMANCE
            • SET_OBJECT_STORAGE_POLICY
          • Table management functions
            • COPY_TABLE
            • INFER_EXTERNAL_TABLE_DDL
            • INFER_TABLE_DDL
            • PURGE_TABLE
            • REBALANCE_TABLE
          • Tuple mover functions
            • DO_TM_TASK
          • Workload management functions
            • ANALYZE_WORKLOAD
            • CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY
            • CHANGE_RUNTIME_PRIORITY
            • MOVE_STATEMENT_TO_RESOURCE_POOL
            • SLEEP
      • Statements
      • Vertica system tables
    • API reference
    • Vertica error messages
    • Glossary
    • Third-Party Software Acknowledgements
    • Copyright notice

Thanks for your feedback!

Send feedback








Submitting...

Print entire section
  1. SQL reference
  2. Functions
  3. Vertica meta-functions

Vertica meta-functions

Vertica meta-functions usually access the internal state of Vertica.

Vertica meta-functions usually access the internal state of Vertica. They can be used in a top-level SELECT statement only, and the statement cannot contain other clauses such as FROM or WHERE. These functions are not part of the SQL standard.

In this section

  • Catalog management functions
  • Client connection management functions
  • Cloud management functions
  • Cluster management functions
  • Cluster scaling functions
  • Communications functions
  • Constraint management functions
  • Data collector functions
  • Database Designer functions
  • Database management functions
  • Directed queries functions
  • Eon Mode functions
  • Epoch management functions
  • Flex table data functions
  • Hadoop functions
  • LDAP link functions
  • License management functions
  • Multiple active result sets functions
  • Partition management functions
  • Privileges and access functions
  • Profiling functions
  • Projection management functions
  • Session management functions
  • Statistics management functions
  • Storage management functions
  • Table management functions
  • Tuple mover functions
  • Workload management functions
© 2025 Open Text Corporation All Rights Reserved
Privacy Policy
Cookie Preferences