Hologres:Connect to HoloWeb

Procedure

1. Log on to the Hologres Management Console.

2. In the navigation pane on the left of the top menu bar, select the desired region.

3. You can click Go to HoloWeb to go to the HoloWeb development page.

4. Log on to the Hologres instance.

   1. On the Metadata Management tab, click Instances.

   2. In the Instances dialog box, configure the parameters and click OK.

      Parameter	Description	Required
      Network type	Public Network: Supported in China (Shanghai), China (Shenzhen), China (Beijing), China (Hangzhou), China (Zhangjiakou), Singapore, China (Hong Kong), Malaysia (Kuala Lumpur), Indonesia (Jakarta), and US (Silicon Valley). An instance with the icon uses the public network type. VPC: Only supported in the region where HoloWeb is logged on. An instance with the icon uses the VPC type. You cannot edit its details or delete it.	No
      Instance name	Select an instance that has been created under your current account. Note After purchasing an instance, HoloWeb may take time to load the instance information. If the instance name does not appear immediately, manually configure connection details such as the Domain Name to connect to the target instance.	No
      Name	If you select an Instance Name, the Name field defaults to the selected instance name. You can also customize the connection name.	Yes
      Description	A description for the connection.	No
      Domain name	The network domain name of the Hologres instance. You can go to the instance details page in the Hologres Management Console and obtain the domain name from the Network Information section. If you select an Instance Name, the system automatically fills in the corresponding Domain Name. You can also enter the domain name manually.	Yes
      Port	The network port of the Hologres instance. You can navigate to the Hologres Management Console instance details page and obtain the port from the Network Information. If you select an Instance Name, the system automatically fills in the corresponding Port. You can also enter the port number manually.	Yes
      Logon method	Password-free Logon: Log on directly using your current account without entering a username or password. Password Logon: Enter the username and password of your account or another account to log on.	Yes
      Username	This parameter is required only if you set logon method to logon with account and password. The AccessKey ID for the current account. You can obtain your AccessKey ID from AccessKey Management.	No
      Password	This parameter is required only if you set logon method to logon with account and password. Enter the AccessKey secret of your current account.	No
      Test connectivity	Check whether the connection succeeds: If The test is successful. appears, the connection succeeded. If The test failed. appears, the connection failed.	No
      Log on after connecting	Choose whether to log on to the instance after connecting. Yes: The instance logs on and appears in the logged-on instances list on the left. No: The instance appears in the not logged-on instances list on the left.	Yes

5. (Optional) Create a database.

   After you activate a Hologres instance, the system automatically creates a postgres database. This database is allocated minimal resources and is intended only for management tasks. To develop business services, create a new database.

   Note

   If you have already created a database, skip this step and create an SQL query.

   1. Click Metadata Management > Database.

      Alternatively, on the Metadata Management page, find the Logged On Instances list. Right-click the target connection and select Create Database.

   2. In the Create Database dialog box, configure the parameters and click OK.

      Parameter	Description
      Instance Name	The name of the logged-on instance where the current database resides is displayed by default.
      Database Name	Name the current database. Note The configured database name must be unique.
      Access Policy	Configure permissions for the database as needed. For more information about access policies, see: SPM SLPM standard PostgreSQL authorization model
      Log on Immediately	Yes: Use the created database directly after logging on. No: Log on to the database before using it.

6. Create an SQL query.

   After you connect to the Hologres instance, use standard PostgreSQL syntax to develop in the SQL Editor module.

   1. On the SQL Editor page, click the icon.

      Alternatively, in the navigation pane on the left, right-click My SQL Queries and select Create SQL Query. For more information, see SQL window.

   2. On the new Ad-hoc Query page, select the created Instance Name and Database. Then, enter the following sample statements in the SQL editor and click Run.

      BEGIN;
      CREATE TABLE nation (
       n_nationkey bigint NOT NULL,
       n_name text NOT NULL,
       n_regionkey bigint NOT NULL,
       n_comment text NOT NULL,
      PRIMARY KEY (n_nationkey)
      );
      CALL SET_TABLE_PROPERTY('nation', 'bitmap_columns', 'n_nationkey,n_name,n_regionkey');
      CALL SET_TABLE_PROPERTY('nation', 'dictionary_encoding_columns', 'n_name,n_comment');
      CALL SET_TABLE_PROPERTY('nation', 'time_to_live_in_seconds', '31536000');
      COMMIT;
      
      INSERT INTO nation VALUES
      (11,'zRAQ', 4,'nic deposits boost atop the quickly final requests? quickly regula'),
      (22,'RUSSIA', 3  ,'requests against the platelets use never according to the quickly regular pint'),
      (2,'BRAZIL',  1 ,'y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special '),
      (5,'ETHIOPIA',  0 ,'ven packages wake quickly. regu'),
      (9,'INDONESIA', 2  ,'slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull'),
      (14,'KENYA',  0  ,'pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t'),
      (3,'CANADA',  1 ,'eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold'),
      (4,'EGYPT', 4 ,'y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d'),
      (7,'GERMANY', 3 ,'l platelets. regular accounts x-ray: unusual, regular acco'),
      (20 ,'SAUDI ARABIA',  4 ,'ts. silent requests haggle. closely express packages sleep across the blithely');
      
      SELECT * FROM nation;

      Note

      SQL queries are not case-sensitive for table names and field names. To run a case-sensitive query for a table name, enclose the table name in double quotation marks ("").

   3. In the Result [1] section below the SQL editor, view the execution result of the statement.

      

7. Create a foreign table to accelerate queries of MaxCompute data.

   Hologres seamlessly connects to MaxCompute and lets you create foreign tables to accelerate queries of MaxCompute data. The following steps describe how to create a foreign table in HoloWeb using the visualization feature:

   Note

   • Make sure that you have created a MaxCompute project and that you have created the source table and written data to it. You can perform these operations in one of the following ways:

     1. Use the DataWorks platform. Attach a MaxCompute data source, and then create the table and write data to it.

     2. Use a local client to access MaxCompute to create the table and write data to it.

   • You must log on to a database in HoloWeb before you can use features to accelerate queries of MaxCompute and OSS data lake data.

   1. Click Metadata Management > MaxCompute Query Acceleration > Create Foreign Table.

   2. Configure the parameters in the Create Foreign Table dialog box, select an acceleration mode as needed, and click Submit.

      Whole-database acceleration

      Category	Parameter	Description
      Acceleration Method	Select an acceleration method.	Hologres supports three acceleration modes: Entire Project Selected Tables Single Table Select Entire Project.
      MaxCompute Data Source	Project Name	The name of the MaxCompute project.
      	Schema Name	The name of the MaxCompute schema. For a MaxCompute project for which schemas are enabled, you can specify the name of any schema in the project for which you have permissions. You do not need to configure this parameter for projects for which schemas are not enabled. For more information about schemas, see Schema operations.
      Destination Table Position	Holo Schema	The name of the pattern. You can select the default public schema or a new schema.
      Advanced Settings	Processing Rule for Table Name Conflicts	Three methods to resolve table name conflicts: Ignore and continue to create other tables Update and modify the table with the same name Report an error and do not create the table again
      	Processing Rule for Unsupported Data Types	Processing is not supported for the following two data types: Report an error and fail the import Ignore and Skip Table of Unsupported Fields

      Partial acceleration

      Category	Parameter	Description
      Acceleration Method	Select an acceleration method.	Hologres supports three acceleration modes: Entire Project Selected Tables Single Table Select Selected Tables.
      MaxCompute Data Source	Project Name	The name of the MaxCompute project.
      	Schema Name	The name of the MaxCompute schema. For a MaxCompute project for which schemas are enabled, you can specify the name of any schema in the project for which you have permissions. You do not need to configure this parameter for projects for which schemas are not enabled. For more information about schemas, see Schema operations.
      Destination Table Position	Holo Schema	The schema name. You can select the default public schema or a new schema.
      Advanced Settings	Processing Rule for Table Name Conflicts	Three methods to resolve table name conflicts: Ignore and continue to create other tables Update and modify the table with the same name Report an Error and Do Not Create a Duplicate
      	Processing Rule for Unsupported Data Types	Two data types are not supported for processing: Report an error and fail the import Ignore and Skip Table of Unsupported Fields
      	Search	Performs a fuzzy search by table name. A maximum of 200 tables can be displayed.

      Single-table acceleration

      Category	Parameter	Description
      Acceleration Method	Select an acceleration method.	Hologres supports three acceleration modes: Entire Project Selected Tables Single Table Select Single Table.
      MaxCompute Data Source	Project Name	The name of the MaxCompute project.
      	Schema Name	The name of the MaxCompute schema. For a MaxCompute project for which schemas are enabled, you can specify the name of any schema in the project for which you have permissions. You do not need to configure this parameter for projects for which schemas are not enabled. For more information about schemas, see Schema operations.
      	Table Name	The data table in the corresponding schema of MaxCompute. Fuzzy search based on table name prefixes is supported.
      Destination Hologres Table	Schema	The schema name. You can select the default public schema or a new schema.
      	Table Name	The name of the single table in Hologres that you want to accelerate.
      	Destination Table Description	The description of the single table in Hologres that you want to accelerate.

   3. After the foreign table is created, in the navigation pane on the left, choose Metadata Management > Logged On Instances. Double-click the destination foreign table. On the page that appears, click Data Preview to accelerate queries of MaxCompute data.