Vertica-OT-White
  • Vertica Documentation
    • Supported platforms
    • New features
    • Getting started
    • Architecture
    • Setup
    • Eon
    • Containerized Vertica
    • Data exploration
    • Data load
    • Data analysis
    • Flex tables
    • Data export and replication
    • Management Console
    • Administrator's guide
      • Administration overview
      • Managing licenses
      • Configuring the DB
      • DB users & privileges
      • Using admin tools
      • Operating the DB
      • Working with native tables
      • Managing client connections
      • Projections
      • Partitioning tables
      • Constraints
      • Managing queries
        • Query plans
        • Directed queries
          • Creating directed queries
          • Setting hints in annotated queries
          • Ignoring constants in directed queries
          • Rewriting queries
          • Managing directed queries
            • Getting directed queries
            • Identifying active directed queries
            • Activating & deactivating directed queries
            • Exporting directed queries from the catalog
            • Dropping directed queries
          • Batch query plan export
          • Half join & cross join semantics
          • Directed query restrictions
      • Transactions
      • Vertica DB locks
      • Using text search
      • Managing storage locations
      • Analyzing workloads
      • Managing the DB
      • Monitoring Vertica
      • Backing up & restoring the DB
      • Failure recovery
      • Collecting DB statistics
      • Using diagnostic tools
      • Profiling DB performance
      • About locale
      • Creating native binary format files
    • Security & authentication
    • Connecting to Vertica
    • Extending Vertica
    • Hadoop integration
    • Kafka integration
    • Spark integration
    • Voltage SecureData integration
    • SQL reference
    • API reference
    • Vertica error messages
    • Glossary
    • Copyright notice

Thanks for your feedback!

Print entire section
  1. Administrator's guide
  2. Managing queries
  3. Directed queries
  4. Managing directed queries

Managing directed queries

Vertica provides a number of ways to manage directed queries:.

Vertica provides a number of ways to manage directed queries:

  • Get directed queries

  • Identify directed queries that are active

  • Activate and deactivate directed queries

  • Export directed queries from the catalog

  • Drop directed queries

In this section

  • Getting directed queries
  • Identifying active directed queries
  • Activating and deactivating directed queries
  • Exporting directed queries from the catalog
  • Dropping directed queries
© 2024 Open Text Corporation All Rights Reserved
Privacy Policy
Cookie Preferences