• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. User Guide
  4. Getting Started
  5. Step 6: Testing and Analyzing Data

Step 6: Testing and Analyzing Data

Scenario

TPC-DS is the benchmark for testing the performance of decision support. With TPC-DS test data and cases, you can simulate complex scenarios, such as big data set statistics, report generation, online query, and data mining, to better understand functions and performance of database applications.

This section describes how to query sample data and perform the test analysis task.

Prerequisites

Procedure

  1. In the ECS Linux command window, run the following commands to switch to a specific directory and query the sample data:

    cd sample/query_sql/

    /bin/bash tpcds100x.sh

  2. Enter the cluster's public network IP address, access port, database name, user who accesses the database, and password of the user.

    • The default database name is postgres.
    • Use the administrator username and password configured during cluster creation as the username and password for accessing the database. For details, see section Step 2: Creating a Cluster.

    After the query is complete, a directory for storing the query result, such as query_output_20170914_072341, will be generated in the current query directory, for example, sample/query_sql/.