检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Log in to the ECS and run the following commands to create directories for storing the TPC-H tool: mkdir -p /data1/script/tpch-kit/tpch1000X mkdir -p /data2/script/tpch-kit/tpch1000X Upload the obtained TPC-H tool to the /data1/script/tpch-kit directory on the ECS and run the following
Log in to the ECS and run the following command to create a directory for storing the TPC-H tools: 1 2 mkdir -p /data1/script/tpch-kit/tpch1000X mkdir -p /data2/script/tpch-kit/tpch1000X Use SFTP to upload the obtained TPC-H tools to the /data1/script/tpch-kit directory of the ECS
Service Data Security GaussDB(DWS) is built on public cloud software infrastructure, including ECS and OBS. Both ECS and OBS won the Trusted Cloud Certification issued by the China Data Center Alliance in 2017.
Test Methods Overall Process Creating an ECS and a GaussDB(DWS) Cluster Constructing Data for TPC-H and TPC-DS Tests Table Creation and Data Import Performing Queries and Collecting Results
If the client host connects to the data warehouse cluster using the cluster's private IP address, apply for another ECS as the client host. The ECS must be in the same VPC and subnet as the data warehouse cluster. Ping is not allowed in the security group rule.
Using gsql to Connect to GaussDB(DWS) Connecting to GaussDB(DWS) Cluster Using gsql Go to the /opt directory of the ECS and run the environment variables. 1 2 cd /opt source gsql_env.sh Run the following command to connect to the GaussDB(DWS) database.
GaussDB(DWS) is deployed in a dedicated ECS environment, which is not shared with any other tenant. This eliminates the possibility of data leakage caused by computing resource sharing.
This mode is ideal when you want more flexibility and control on ECS usage. For example, customers that require early operation tests, proof of concept, and short-term use. Parent topic: Billing Modes
ECS GaussDB(DWS) uses an ECS as a cluster node. BMS GaussDB(DWS) uses a BMS as a cluster node. VPC GaussDB(DWS) uses the Virtual Private Cloud (VPC) service to provide a network topology for clusters to isolate clusters and control access.
For details about how to log in to an ECS, see "ECSs> Logging In to a Linux ECS > Login Using an SSH Password" in the Elastic Cloud Server User Guide.
"Version": "1.1", "Statement": [ { "Effect": "Allow", "Action": [ "dws:snapshot:*", "ecs:*:get*", "ecs:*:list*", "vpc:*:get*",
Video Tutorial Preparing an ECS as the GDS Server For details about how to purchase an ECS, see Purchasing an ECS in the Elastic Cloud Server Getting Started. After the purchase, log in to the ECS by referring to Logging In to a Linux ECS.
Make sure that the ECS disk space is sufficient. Because the generated data is large, it takes a long time to import data if only one GDS is started. You are advised to generate data on two data disks evenly.
Enter a valid cluster administrator password as prompted and try again later. 400 DWS.5146 The ECS group parameter is missing. The ECS group parameters is missing. Enter a valid parameter and try again. 400 DWS.5147 Invalid ECS group parameter. Invalid ECS group parameter.
Importing data from a remote server to GaussDB(DWS) using GDS Use the GDS data import function provided by GaussDB(DWS) to import data files from a common file system (for example, an ECS). Migrating data to GaussDB(DWS) using CDM Parent topic: Data Migration
Importing data from a remote server to GaussDB(DWS) using GDS Use the GDS data import function provided by GaussDB(DWS) to import data files from a common file system (for example, an ECS). Migrating data to GaussDB(DWS) using CDM Parent topic: Data Migration
Replace the IP address with the private network IP address of ECS to ensure that GaussDB(DWS) can communicate with GDS through this IP address. The port numbers are 5000 and 5001 for TPC-H and 5002 and 5003 for TPC-DS.
You need to create an ECS as the GDS server. The created ECS and GaussDB(DWS) must belong to the same region, VPC, and subnet. Procedure Create a table in GaussDB(DWS) to store imported data. For details, see CREATE TABLE.
To access a cluster by calling Elasticsearch APIs on the ECS that is located in the same VPC as the cluster, perform the following steps: Log in to Huawei Cloud API Explorer and choose Analytics > Data Warehouse Service. The DWS OpenAPI page is displayed.
Creating an ECS For details, see Purchasing an ECS. After purchasing an ECS, log in to the ECS by referring to Logging In to a Linux ECS. When creating an ECS, ensure that the ECS is in the same region, AZ, and VPC subnet as the stream data warehouse.
