Hologres:Manage a folder

Public dataset queries

The SQL Editor module provides a folder named Public Dataset Queries, which allows you to perform queries from public datasets. The TPC-H 10 GB, TPC-H 100 GB, and TPC-H 1 TB public datasets are supported. You can open the related SQL scripts and perform operations such as table creation, data import, and the 22 TPC-H queries.

When you use Serverless Computing to execute data import tasks, you can directly utilize additional serverless computing resources, avoiding the use of local resources of the instance. You do not need to reserve extra computing resources for the instance. This significantly improves instance stability and reduces OOM errors. During this process, you pay for only the tasks.

Entry point

1. Log on to the Hologres console.

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

3. In the left-side navigation pane, click Go to HoloWeb to go to the HoloWeb console.

4. In the HoloWeb console, click SQL Editor in the top navigation bar.

Create a folder

After you go to the SQL Editor page from the entry point, perform the following steps:

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

   You can also right-click My SQL query in the left-side navigation pane and select Create Folder. HoloWeb allows you to create a subfolder in an existing folder.

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

   You can select an existing directory from the drop-down list to place the new folder.

3. Click OK. The new folder is displayed in the specified directory in the left-side navigation pane.

Rename a folder

After you go to the SQL Editor page from the entry point, perform the following steps:

1. In the left-side navigation pane of the SQL Editor page, click My SQL query. All the created folders are displayed.

2. Right-click the folder that you want to rename and select Rename Folder.

3. In the Rename Folder dialog box, enter a new name based on your business requirements.

4. Click OK.

Delete a folder

After you go to the SQL Editor page from the entry point, perform the following steps:

1. In the left-side navigation pane of the SQL Editor page, click My SQL query. All the created folders are displayed.

2. Right-click the folder that you want to delete and select Delete Folder.

   Note

   Before you delete a folder, you must delete all subfolders and SQL query tasks in the folder.

3. Click OK.

Search for a folder

If the My SQL query list contains a lot of folders, you can perform the following steps to quickly locate a folder after you go to the SQL Editor page from the entry point:

1. In the left-side navigation pane of the SQL Editor page, enter a keyword in the search box below Query.

2. The folders whose names contain the keyword are displayed in the My SQL query list.