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

Using Procedural Languages

来源 1 浏览 502 扫码 打印 2020-09-23 23:50:08
  • Using PL/pgSQL
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • 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 ) 重置阅读进度