Folders

Public dataset queries

You can run queries on three public datasets: TPC-H 10 GB, TPC-H 100 GB, and TPC-H 1 TB. Open the corresponding SQL scripts to create tables, import data, and run the 22 TPC-H queries.

When you use Serverless Computing to run data import tasks, you can use dedicated serverless resources. This prevents the task from consuming your instance's resources and eliminates the need to reserve extra computing power for the instance. As a result, you can significantly improve instance stability and reduce the likelihood of out-of-memory (OOM) errors. You are charged only for the resources used by the task.

Accessing the SQL Editor

1. Log on to the Hologres management console.

2. In the top navigation bar, select a region.

3. Click Go to HoloWeb to open the HoloWeb developer page.

4. In the top navigation bar of the HoloWeb development page, click SQL Editor.

Create a folder

After you navigate to the SQL Editor page as described in Accessing the SQL Editor, follow these steps.

1. On the SQL Editor page, click the icon in the upper-left corner.

   Alternatively, you can right-click My SQL query and select Create Folder. HoloWeb also allows you to create subfolders within existing folders.

2. In the Create Folder dialog box, set the Folder Name and Directory parameters.

   If a target directory already exists, you can select it from the drop-down list.

3. Click OK. The new folder appears in the specified directory in the left-side panel.

Rename a folder

After you navigate to the SQL Editor page as described in Accessing the SQL Editor, follow these steps.

1. In the left-side panel of the SQL Editor page, click My SQL query to display all created folders.

2. Right-click the target folder and select Rename Folder.

3. In the Rename Folder dialog box, enter a new name for the folder.

4. Click OK to rename the folder.

Delete a folder

After you navigate to the SQL Editor page as described in Accessing the SQL Editor, follow these steps.

1. In the left-side panel of the SQL Editor page, click My SQL query to display all created folders.

2. Right-click the target folder and select Delete Folder.

   Note

   To delete a parent folder, you must first delete all its subfolders and SQL queries.

3. Click OK to delete the folder.

Search for a folder

If you have many folders under My SQL query and need to find a specific one quickly, navigate to the SQL Editor page as described in Accessing the SQL Editor and follow these steps.

1. In the left-side panel of the SQL Editor page, enter the name of the target folder in the search box.

2. Matching folders appear in the My SQL query list. Click the name of the target folder to view its details.