Apache HAWQ v2.3.0 Document
首页 白天 夜间 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签
编辑文档

HAWQ Management Tools Reference

来源 1 浏览 294 扫码 打印 2020-09-24 00:01:25

    HAWQ Management Tools Reference

    • analyzedb

    • createuser

    • dropuser

    • gplogfilter

    • hawq checkperf

    • hawq extract

    • hawq init

    • hawq register

    • hawq ssh

    • hawq start

    • hawq stop

    • pg_dumpall

    • vacuumdb

    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Getting Started with HAWQ Tutorial
      • Lesson 5 - HAWQ Tables
      • Lesson 6 - HAWQ Extension Framework (PXF)
      • Lesson 1 - Runtime Environment
      • Lesson 3 - Database Administration
      • Lesson 4 - Sample Data Set and HAWQ Schemas
      • Lesson 2 - Cluster Administration
    • HAWQ Reference
      • HAWQ Management Tools Reference
        • createuser
        • hawq state
        • pg_dump
        • hawq init
        • createdb
        • pg_restore
        • hawq ssh-exkeys
        • hawq register
        • hawq activate
        • hawq start
        • psql
        • pg_dumpall
        • vacuumdb
        • hawq load
        • dropuser
        • hawq stop
        • hawq restart
        • gplogfilter
        • analyzedb
        • dropdb
        • hawq scp
        • gpfdist
        • hawq filespace
        • hawq ssh
        • hawq check
        • hawq extract
        • hawq checkperf
        • hawq config
      • Data Types
      • Character Set Support Reference
      • SQL Commands
        • END
        • CREATE DATABASE
        • COPY
        • DROP GROUP
        • CREATE CAST
        • DROP SCHEMA
        • ALTER CONVERSION
        • ALTER ROLE
        • COMMIT
        • ALTER AGGREGATE
        • BEGIN
        • PREPARE
        • ABORT
        • CREATE AGGREGATE
        • FETCH
        • CLOSE
        • EXPLAIN
        • DROP CAST
        • ALTER TABLE
        • SET
        • ALTER FUNCTION
        • CREATE VIEW
        • DROP ROLE
        • CREATE USER
        • ANALYZE
        • RESET
        • SAVEPOINT
        • ALTER TABLESPACE
        • CREATE CONVERSION
        • DROP DATABASE
        • DROP USER
        • SELECT
        • GRANT
        • CREATE TABLE
        • DROP TYPE
        • RELEASE SAVEPOINT
        • REVOKE
        • DROP TABLE
        • INSERT
        • DROP FUNCTION
        • CREATE TABLESPACE
        • CREATE OPERATOR
        • DROP OPERATOR CLASS
        • ALTER OPERATOR CLASS
        • CREATE FUNCTION
        • SHOW
        • ALTER USER
        • DROP LANGUAGE
        • CREATE OPERATOR CLASS
        • CREATE TYPE
        • TRUNCATE
        • DROP FILESPACE
        • ALTER SEQUENCE
        • ROLLBACK
        • CREATE RESOURCE QUEUE
        • CREATE GROUP
        • CREATE TABLE AS
        • DROP EXTERNAL TABLE
        • ALTER TYPE
        • DROP OPERATOR
        • SET ROLE
        • CREATE EXTERNAL TABLE
        • DROP CONVERSION
        • DROP RESOURCE QUEUE
        • CREATE SEQUENCE
        • ALTER DATABASE
        • DROP SEQUENCE
        • ROLLBACK TO SAVEPOINT
        • DECLARE
        • REASSIGN OWNED
        • CHECKPOINT
        • ALTER OPERATOR
        • SELECT INTO
        • CREATE ROLE
        • DROP TABLESPACE
        • SET SESSION AUTHORIZATION
        • CREATE SCHEMA
        • VACUUM
        • DROP AGGREGATE
        • DROP VIEW
        • DEALLOCATE
        • EXECUTE
        • CREATE LANGUAGE
        • DROP OWNED
        • ALTER RESOURCE QUEUE
      • The hawq_toolkit Administrative Schema
      • Server Configuration Parameter Reference
        • Configuration Parameters
        • Configuration Parameter Categories
        • Sample hawq-site.xml Configuration File
        • About Server Configuration Parameters
      • HDFS Configuration Reference
      • Environment Variables
      • System Catalog Reference
        • System Tables
        • System Views
        • System Catalogs Definitions
          • pg_partition_encoding
          • pg_exttable
          • pg_largeobject
          • pg_filespace
          • pg_locks
          • pg_partition_rule
          • gp_master_mirroring
          • pg_description
          • pg_stat_last_operation
          • pg_window
          • pg_amproc
          • pg_namespace
          • pg_tablespace
          • gp_persistent_database_node
          • pg_pltemplate
          • pg_rewrite
          • pg_partition
          • pg_attribute_encoding
          • gp_persistent_relation_node
          • pg_aggregate
          • pg_authid
          • pg_auth_members
          • pg_database
          • pg_stat_activity
          • pg_attribute
          • pg_resqueue_status
          • gp_segment_configuration
          • pg_conversion
          • pg_partition_columns
          • pg_constraint
          • pg_stats
          • pg_partition_templates
          • gp_relfile_node
          • pg_proc
          • gp_persistent_relfile_node
          • pg_listener
          • pg_index
          • pg_resqueue
          • pg_stat_partition_operations
          • pg_appendonly
          • pg_am
          • pg_statistic
          • pg_type_encoding
          • pg_operator
          • pg_shdepend
          • gp_global_sequence
          • pg_class
          • pg_opclass
          • pg_roles
          • pg_trigger
          • pg_language
          • pg_shdescription
          • pg_stat_last_shoperation
          • pg_compression
          • pg_inherits
          • pg_partitions
          • pg_amop
          • pg_filespace_entry
          • gp_version_at_initdb
          • pg_depend
          • pg_stat_operations
          • pg_cast
          • pg_attrdef
          • gp_distribution_policy
          • pg_type
          • gp_configuration_history
          • gp_persistent_tablespace_node
          • gp_persistent_filespace_node
    • Best Practices
      • Querying Data
      • Operating HAWQ
      • Managing Data
      • Managing Resources
      • Configuring HAWQ
      • Securing HAWQ
    • System Requirements
    • Defining Database Objects
      • Creating and Managing Tablespaces
      • Identifying HAWQ Table HDFS Files
      • Choosing the Table Storage Model
      • Creating and Managing Views
      • Creating and Managing Databases
      • Partitioning Large Tables
      • Overview
      • Creating and Managing Tables
      • Creating and Managing Schemas
    • Managing Data with HAWQ
      • Concurrency Control
      • Loading and Unloading Data
        • Optimizing Data Load and Query Performance
        • Using the HAWQ File Server (gpfdist)
          • About gpfdist Setup and Performance
          • Troubleshooting gpfdist
          • Starting and Stopping gpfdist
          • Installing gpfdist
          • Controlling Segment Parallelism
        • Working with File-Based External Tables
          • gpfdists Protocol
          • Accessing File-Based External Tables
          • gpfdist Protocol
          • Handling Errors in External Table Data
        • Loading Data with COPY
        • Loading Data Using an External Table
        • Transforming XML Data
          • Load the Data
          • Write the gpfdist Configuration
          • Write a Transform
          • XML Transformation Examples
            • Example using IRS MeF XML Files (In demo Directory)
            • Command-based Web External Tables
            • Example using WITSML™ Files (In demo Directory)
          • Transfer and Store the Data
            • Transforming with INSERT INTO SELECT FROM
            • Transforming with GPLOAD
            • Configuration File Format
          • Determine the Transformation Schema
        • Loading Data with hawq load
        • Unloading Data from HAWQ
          • Defining a Command-Based Writable External Web Table
            • Disabling EXECUTE for Web or Writable External Tables
          • Defining a File-Based Writable External Table
            • Example - HAWQ file server (gpfdist)
          • Unloading Data Using a Writable External Table
          • Unloading Data Using COPY
        • Creating and Using Web External Tables
          • Command-based Web External Tables
          • URL-based Web External Tables
        • Formatting Data Files
          • Character Encoding
          • Formatting Columns
          • Escaping
            • Escaping in CSV Formatted Files
            • Escaping in Text Formatted Files
          • Representing NULL Values
          • Formatting Rows
        • Registering Files into HAWQ Internal Tables
        • Handling Load Errors
          • Moving Data between Tables
          • Capture Row Formatting Errors and Declare a Reject Limit
          • Identifying Invalid CSV Files in Error Table Data
          • Define an External Table with Single Row Error Isolation
        • Running COPY in Single Row Error Isolation Mode
        • Creating External Tables - Examples
        • Loading and Writing Non-HDFS Custom Data
          • Using a Custom Format
            • Examples - Read Fixed-Width Data
            • Importing and Exporting Fixed Width Data
      • Basic Data Operations
      • HAWQ InputFormat for MapReduce
      • About Database Statistics
      • Working with Transactions
    • Using PXF with Unmanaged Data
      • Installing PXF Plugins
      • Accessing External SQL Databases
      • PXF External Tables and API
      • Accessing HBase Data
      • Writing Data to HDFS
      • Configuring PXF
      • Troubleshooting PXF
      • Accessing HDFS File Data
      • Using Profiles to Read and Write Data
      • Accessing JSON Data
      • Accessing Hive Data
    • Querying Data
      • About HAWQ Query Processing
      • Query Performance
      • About GPORCA
        • Determining The Query Optimizer In Use
        • Considerations when Using GPORCA
        • GPORCA Limitations
        • Changed Behavior with GPORCA
        • Enabling GPORCA
        • GPORCA Features and Enhancements
        • Overview of GPORCA
      • Query Profiling
      • Using Functions and Operators
      • Defining Queries
    • Troubleshooting
    • HAWQ System Overview
      • Elastic Query Execution Runtime
      • Table Distribution and Storage
      • Resource Management
      • Management Tools
      • HDFS Catalog Cache
      • High Availability, Redundancy and Fault Tolerance
      • What is HAWQ?
      • HAWQ Architecture
    • Managing Client Access
      • Connecting with psql
      • Using Kerberos Authentication
        • Example - Setting up an MIT KDC Server
        • Configuring HAWQ/PXF for Secure HDFS
        • Configuring Kerberos User Authentication for HAWQ
      • Overview of HAWQ Authorization
      • Using HAWQ Native Authorization
      • Disabling Kerberos Security
      • Establishing a Database Session
      • Configuring Client Authentication
      • Using LDAP Authentication with TLS/SSL
      • HAWQ Client Applications
      • Troubleshooting Connection Problems
      • HAWQ Database Drivers and APIs
      • Using Ranger for Authorization
        • Configuring HAWQ to use Ranger Policy Management
        • Overview of Ranger Policy Management
        • High Availability and HAWQ Ranger
        • Creating HAWQ Authorization Policies in Ranger
          • HAWQ Resources and Permissions
          • SQL Command Permissions Summary
          • Using MADLib with Ranger Authorization
        • HAWQ Ranger Kerberos Integration
        • Auditing Authorization Events
    • Managing Resources
      • Analyzing Resource Manager Status
      • Best Practices for Configuring Resource Management
      • Configuring Resource Management
      • How HAWQ Manages Resources
      • Working with Hierarchical Resource Queues
      • Integrating YARN with HAWQ
    • Running a HAWQ Cluster
      • HAWQ Filespaces and High Availability Enabled HDFS
      • Monitoring a HAWQ System
      • Backing Up and Restoring HAWQ
      • Introducing the HAWQ Operating Environment
      • Expanding a Cluster
      • Recommended Monitoring and Maintenance Tasks
      • Starting and Stopping HAWQ
      • HAWQ Administrative Log Files
      • Managing HAWQ Using Ambari
        • Using the Ambari REST API
      • High Availability in HAWQ
      • Overview
      • Master Mirroring
      • Routine System Maintenance Tasks
      • Removing a Node
      • HAWQ Packcore Utility
      • Understanding the Fault Tolerance Service
    • Using Procedural Languages
      • Using HAWQ Built-In Languages
      • Using PL/R
      • Using PL/Python
      • Using PL/pgSQL
      • Using Languages in HAWQ
      • Using PL/Java
    暂无相关搜索结果！

      本文档使用 全库网 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度