Apache HAWQ v2.3 Documentation
首页
白天
夜间
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
Defining Database Objects
来源 1
浏览
383
扫码
打印
2020-11-10 08:01:56
Creating and Managing Tablespaces
Identifying HAWQ Table HDFS Files
Creating and Managing Views
上一篇:
下一篇:
发布点评
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
Viewing HAWQ Server Log Files
Checking Database Object Sizes and Disk Space
Checking for Tables that Need Routine Maintenance
Server Configuration Parameter Reference
Configuration Parameters
pxf_enable_filter_pushdown
hawq_rm_nvseg_perquery_perseg_limit
gp_reject_percent_threshold
gp_filerep_tcp_keepalives_idle
krb_caseins_users
log_min_duration_statement
gp_external_enable_exec
block_size
hawq_rm_yarn_address
gp_enable_direct_dispatch
server_version_num
hawq_rm_rejectrequest_nseg_limit
hawq_rm_stmt_nvseg
hawq_rm_tolerate_nseg_limit
vacuum_cost_page_dirty
log_duration
server_version
gp_role
search_path
integer_datetimes
bonjour_name
enable_nestloop
krb_server_keyfile
gp_autostats_mode
gp_external_max_segs
hawq_dfs_url
cpu_tuple_cost
enable_sort
server_encoding
application_name
hawq_master_address_host
standard_conforming_strings
lc_messages
lc_monetary
log_rotation_age
optimizer_analyze_root_partition
gp_enable_agg_distinct_pruning
hawq_rm_memory_limit_perseg
pxf_stat_max_fragments
gp_adjust_selectivity_for_outerjoins
gp_enable_multiphase_agg
cpu_index_tuple_cost
debug_print_parse
gp_interconnect_default_rtt
gp_log_format
hawq_rm_nresqueue_limit
debug_print_rewritten
gp_workfile_limit_per_segment
hawq_rps_address_port
gp_statistics_use_fkeys
hawq_rm_nslice_perseg_limit
TimeZone
log_parser_stats
gp_vmem_protect_segworker_cache_limit
gp_backup_directIO_read_chunk_mb
effective_cache_size
enable_hashjoin
superuser_reserved_connections
gp_idf_deduplicate
gp_interconnect_snd_queue_depth
gp_debug_linger
log_statement_stats
gp_enable_sequential_window_plans
default_tablespace
dynamic_library_path
gp_enable_groupext_distinct_gather
gp_segments_for_planner
optimizer_prefer_scalar_dqa_multistage_agg
hawq_global_rm_type
log_min_error_statement
gp_max_plan_size
gp_interconnect_queue_depth
pljava_release_lingering_savepoints
enable_groupagg
unix_socket_permissions
gp_enable_groupext_distinct_pruning
default_hash_table_bucket_number
debug_print_slice_table
gp_max_filespaces
escape_string_warning
optimizer
gp_backup_directIO
regex_flavor
hawq_rm_nvseg_variance_amon_seg_limit
hawq_rm_yarn_app_name
debug_pretty_print
unix_socket_directory
pxf_enable_stat_collection
enable_mergejoin
gp_enable_sort_distinct
gp_workfile_compress_algorithm
gp_interconnect_setup_timeout
gp_workfile_checksumming
max_appendonly_tables
gp_autostats_on_change_threshhold
gp_analyze_relative_error
hawq_re_memory_overcommit_max
optimizer_parts_to_force_sort_on_insert
hawq_segment_directory
gp_enable_sort_limit
hawq_rm_master_port
gp_set_proc_affinity
enable_bitmapscan
hawq_rm_return_percent_on_overcommit
gp_enable_preunique
hawq_acl_type
tcp_keepalives_idle
log_rotation_size
deadlock_timeout
enable_hashagg
gp_command_count
hawq_rm_nvseg_perquery_limit
log_hostname
gp_vmem_idle_resource_timeout
add_missing_from
gp_set_read_only
hawq_rm_yarn_scheduler_address
listen_addresses
log_truncate_on_rotation
temp_buffers
ssl_ciphers
client_encoding
join_collapse_limit
gp_max_csv_line_length
gp_filerep_tcp_keepalives_interval
hawq_rm_nvcore_limit_perseg
local_preload_libraries
vacuum_freeze_min_age
gp_hashjoin_tuples_per_bucket
gp_enable_fast_sri
max_connections
default_transaction_isolation
max_function_args
tcp_keepalives_interval
max_locks_per_transaction
gp_statistics_pullup_from_child_partition
krb_srvname
lc_time
seq_page_cost
hawq_rm_yarn_queue_name
enable_indexscan
pxf_service_port
gp_interconnect_timer_period
pljava_classpath
hawq_rm_force_alterqueue_cancel_queued_request
ssl
max_fsm_relations
gp_interconnect_timer_checking_period
client_min_messages
backslash_quote
IntervalStyle
custom_variable_classes
gp_interconnect_min_rto
gp_cached_segworkers_threshold
statement_timeout
from_collapse_limit
log_min_messages
log_disconnections
extra_float_digits
vacuum_cost_page_miss
array_nulls
cursor_tuple_fraction
gp_enable_agg_distinct
pxf_service_address
explain_pretty_print
gp_workfile_limit_per_query
gp_reraise_signal
hawq_rm_segment_port
transform_null_equals
log_executor_stats
gp_motion_cost_per_row
gp_dynamic_partition_pruning
optimizer_minidump
log_dispatch_stats
random_page_cost
debug_assertions
log_error_verbosity
track_activities
hawq_segment_temp_directory
check_function_bodies
hawq_rm_stmt_vseg_memory
gp_max_databases
gp_interconnect_fc_method
log_connections
gp_connections_per_thread
gp_interconnect_cache_future_packets
seg_max_connections
hawq_rm_cluster_report_period
log_timezone
gp_interconnect_hash_multiplier
hawq_rm_resource_idle_timeout
log_statement
gp_enable_fallback_plan
hawq_master_temp_directory
max_identifier_length
default_transaction_read_only
log_autostats
max_stack_depth
pgstat_track_activity_query_size
server_ticket_renew_interval
vacuum_cost_delay
hawq_master_address_port
lc_ctype
debug_print_plan
lc_numeric
gp_segment_connect_timeout
gp_external_grant_privileges
enable_tidscan
transaction_read_only
port
pxf_remote_service_login
authentication_timeout
gp_max_packet_size
gp_safefswritesize
password_encryption
db_user_namespace
gp_interconnect_type
gp_filerep_tcp_keepalives_count
DateStyle
enable_seqscan
hawq_rm_segment_heartbeat_interval
gp_interconnect_min_retries_before_timeout
gp_workfile_limit_files_per_query
max_fsm_pages
lc_collate
pljava_statement_cache_size
cpu_operator_cost
vacuum_cost_limit
log_planner_stats
runaway_detector_activation_percent
hawq_master_directory
shared_buffers
hawq_rm_min_resource_perseg
shared_preload_libraries
gp_max_tablespaces
max_prepared_transactions
update_process_title
hawq_rps_check_local_interval
timezone_abbreviations
transaction_isolation
pxf_remote_service_secret
default_statistics_target
max_files_per_process
track_counts
max_index_keys
xid_stop_limit
debug_print_prelim_plan
tcp_keepalives_count
pljava_vmoptions
gp_session_id
unix_socket_group
hawq_segment_address_port
gp_enable_predicate_propagation
Configuration Parameter Categories
Ranger Configuration Parameters
Query Tuning Parameters
Past PostgreSQL Version Compatibility Parameters
External Table Parameters
Append-Only Table Parameters
System Resource Consumption Parameters
Error Reporting and Logging Parameters
Database and Tablespace/Filespace Parameters
Client Connection Default Parameters
Connection and Authentication Parameters
HAWQ PL/Java Extension Parameters
Statistics Collection Parameters
Lock Management Parameters
HAWQ Array Configuration Parameters
GPORCA Parameters
HAWQ Resource Management Parameters
HAWQ Extension Framework (PXF) Parameters
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
Queries Cancelled Due to High VMEM Usage
Rejection of Query Resource Requests
Query Performance Issues
Segments Do Not Appear in gp_segment_configuration
Handling Segment Resource Fragmentation
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
)
重置阅读进度