AnalyticDB for MySQL:Notebook editor

Parameter

Description

Resource Group

Create Resource Group

Allows you to create a job resource group. For more information, see Create a resource group.

Change Resource Group

Allows you to change the resource group of the notebook. Before you change the resource group of the notebook, make sure that the following requirements are met:

• The resource group is of the job type.

• The resource group is in the running state.

• The maximum amount of computing resources is greater than or equal to 8 ACUs.

Kernel

Restart Kernel

Allows you to restart the notebook kernel. The restart process requires approximately 3 minutes to complete, and the running notebook jobs fail during the process.

Kill Kernel

Allows you to kill the notebook kernel. If you kill the notebook kernel, the running notebook jobs fail.

Parameter

Description

Allows you to save notebook jobs. The following methods are also available to save notebook jobs:

• The system saves notebook jobs at an interval of 5 seconds.

• You can press Ctrl+S to save notebook jobs.

Allows you to create a paragraph. You can also move the pointer over the middle part between two paragraphs and click +Create Paragraph.

Allows you to run code in all paragraphs.

Allows you to pause the execution of code in all paragraphs.

Allows you to clear the results of all paragraphs.

Allows you to configure startup parameters for a notebook job. For information about configuration parameters, see Conf configuration parameters.

Example:

{
        "spark.driver.resourceSpec": "small",
        "spark.executor.instances": 2,
        "spark.executor.resourceSpec": "small",
        "spark.adb.eni.vswitchId":"vsw-bp14pj8h0k5p0kwu3****",
        "spark.adb.eni.securityGroupId": "sg-bp14qrdskvwnzels****",
        "spark.hadoop.hive.metastore.uris": "thrift://192.168.XX.XX:9083"
    }

Parameter

Description

The saving status of notebook jobs. The system saves notebook jobs at an interval of 5 seconds.

The state of the notebook kernel. The system refreshes the state of the notebook kernel at an interval of 5 seconds. Valid values:

• (Kernel Not Started): The notebook kernel is not started. You can choose Kernel > Restart Kernel to restart the notebook kernel.

• (Kernel Idle): The notebook kernel is idle and available to run notebook jobs.

• (Kernel Starting): The notebook kernel is being started. You can try again later.

• (Kernel Busy): The notebook kernel is running large amounts of code. You can try again later.

• (Kernel Error): A startup error occurs on the notebook kernel. You can try again later or restart the notebook kernel.

• (Kernel Invalid): The notebook kernel is invalid. You can restart the notebook kernel.

• (Kernel Killed): The notebook kernel is killed. You can restart the notebook kernel.

• (Kernel Unknown): The state of the notebook kernel is unknown. You can restart the notebook kernel.

Parameter

Description

①

The ID of the handle that uniquely identifies a running statement and is used to identify issues.

②

The code editing box. Syntax keywords are automatically highlighted, and Spark SQL and Python language are supported.

③

The toolbar that allows you to switch languages, format code, run code, pause code execution, clear results, and delete paragraphs.

• : allows you to switch languages between Spark SQL and Python.

• : allows you to format only Spark SQL code.

• : allows you to run the code in the current paragraph.

• : allows you to pause the execution of the code in the current paragraph.

• : allows you to clear the results of the current paragraph.

• : allows you to delete the current paragraph.

④

The result section of the current paragraph. The code execution results are displayed in the table format for Spark SQL, and are displayed in the text format for other languages.

⑤

The status bar of the current paragraph that contains the running status, the execution duration, and the most recent update time.