KEYSET_FROM_JSON - MaxCompute - Alibaba Cloud Documentation Center

Converts a keyset of the JSON type into a keyset of the BINARY type.

Syntax

binary KEYSET_FROM_JSON(string <json_keyset>)

Parameters

json_keyset: required. This parameter specifies a keyset of the JSON type.

Return value

A keyset of the BINARY type is returned.

Note

You can use HEX to convert the BINARY type into the STRING type or use UNHEX to convert the STRING type into the BINARY type based on your business requirements.

Examples

select hex(KEYSET_FROM_JSON('{
    "key": [{
            "description": "hello world",
            "key_id": "r8MqZAEA8PDd3QSL",
            "key_meta_data": {
                "key_material_origin": "Origin_ALIYUN_MAXCOMPUTE",
                "key_material_type": "SYMMETRIC",
                "type": "AES-GCM-256",
                "value": "Jqj7ESbfT1td0DwYDmkZVl13FsuykYFe+1u/MPi++a8="},
            "output_prefix_type": "PREFIX_ALIYUN_MAXCOMPUTE",
            "status": "ENABLED"}],
    "primary_key_id": "r8MqZAEA8PDd3QSL"}')) ;

The following result is returned:

+------------+
| _c0        |
+------------+
| 0A1072384D715A414541385044643351534C12580A330A0B4145532D47434D2D323536122026A8FB1126DF4F5B5DD03C180E6919565D7716CBB291815EFB5BBF30F8BEF9AF1801200210011A1072384D715A414541385044643351534C20022A0B68656C6C6F20776F726C64 |
+------------+

References

References	Description
NEW_KEYSET	Describes the NEW_KEYSET function. The function is used to create a keyset based on the specified algorithm type.
ADD_KEY_TO_KEYSET	Describes the ADD_KEY_TO_KEYSET function. The function is used to add a key to a keyset and configure the key as the master key.
KEYSET_TO_JSON	Describes the KEYSET_TO_JSON function. The function is used to convert a keyset of the BINARY type into a readable JSON string. After the conversion, you can view the details of the keyset.
ROTATE_KEYSET	Describes the ROTATE_KEYSET function. The function allows the system to automatically produce a new key and configure the new key as the master key.
NEW_WRAPPED_KEYSET	Describes the NEW_WRAPPED_KEYSET function. The function is used to assume the Alibaba Cloud Resource Name (ARN) of a role that can use Key Management Service (KMS) customer master key (CMK) ARNs to MaxCompute and create a wrapped keyset. The role ARN is specified by `role_arn`. The KMS CMK ARN is specified by kms_cmk_arn. The function is also used to grant other Alibaba Cloud accounts the permissions to decrypt a keyset based on `role_chain`.
ROTATE_WRAPPED_KEYSET	Describes the ROTATE_WRAPPED_KEYSET function. The function is used to decrypt an encrypted keyset, implement key rotation, and use a new key to encrypt data.
USE_WRAPPED_KEYSET	Describes the USE_WRAPPED_KEYSET function. The function is used to convert a wrapped keyset into a basic keyset that is used as a parameter in the encryption or decryption function. You can also use the USE_WRAPPED_KEYSET function to obtain information about a wrapped keyset and save the information for subsequent keyset maintenance.
ENHANCED_SYM_ENCRYPT	Describes the ENHANCED_SYM_ENCRYPT function. The function is used to encrypt data by using a specified keyset.
ENHANCED_SYM_DECRYPT	Describes the ENHANCED_SYM_DECRYPT function. The function is used to decrypt data by using a specified keyset.