This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

How-to guides

    Users can create Quick Query services by entering the required information and selecting detailed options through the Samsung Cloud Platform Console.

    Creating Quick Query

    You can create Quick Query services through the Samsung Cloud Platform Console.

    To create Quick Query, follow these steps:

    1. Click All Services > Data Analytics > Quick Query. This will take you to the Service Home page of Quick Query.

    2. On the Service Home page, click the Create Quick Query button. This will take you to the Create Quick Query page.

    3. On the Create Quick Query page, enter the required information and select the detailed options.

      • In the Version Selection section, select the required information.
        Category
        Required
        Description
        Quick QueryRequiredSelect the Quick Query service version
        • Provides a list of available versions
        Table. Quick Query Service Version Selection Items
      • In the Service Information Input section, enter or select the required information.
        Category
        Required
        Description
        Quick Query NameRequiredEnter the Quick Query name
        • Starts with a lowercase letter and does not end with a special character (-), uses lowercase letters, numbers, and special characters (-) to enter 3-30 characters
        DescriptionOptionalEnter additional information or description of Quick Query within 150 characters
        Domain SettingRequiredEnter the Quick Query domain
        • Starts with a lowercase letter and does not end with special characters (-, .), uses lowercase letters, numbers, and special characters (-, .) to enter 3-50 characters
        • {Quick Query Name}.{Set Domain} will be the Quick Query access address.
        Query Engine TypeRequiredSelect the query engine type
        • Shared: Multiple users share a single query engine
        • Dedicated: Each user has a separate engine
        Cluster SizeRequiredSelect the resource capacity for cluster configuration
        • If the engine type is Shared,
          • Auto Scaling can be selected to choose the cluster capacity (Small, Medium, Large, Extra Large).
          • If Auto Scaling is not selected, the cluster capacity can be set by entering Replica, CPU, and Memory.
        • If the engine type is Dedicated,
          • the cluster capacity can be selected (Small, Medium, Large, Extra Large).
        • Engine capacity (when using Auto Scaling)
          • Small: 1Core, 4GB
          • Medium: 4Core, 16GB
          • Large: 8Core, 64GB
          • Extra Large: 16Core, 128GB
        • Engine capacity (when not using Auto Scaling)
          • Replica: 1-9 input possible, default: 1
          • CPU: 4-24 input possible (4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24 input possible), default: 4
          • Memory: 8-256 input possible (8, 16, 32, 64, 128, 192, 256 input possible), default: 8
        Maximum Concurrent Query ExecutionRequiredSelect the maximum number of queries to execute concurrently in Quick Query
        • Available values: 32, 64, 96, 128
        Data Service Console ConnectionRequiredEnter the Data Service Console domain
        • Starts with a lowercase letter and does not end with special characters (-, .), uses lowercase letters, numbers, and special characters (-, .) to enter 3-50 characters
        Host AliasOptionalAdd host information to be connected to Quick Query (up to 20 can be created, including the default)
        • Use is selected, and the + button is clicked
        • Hostname: Hostname or domain format, using lowercase letters, numbers, and special characters (-, .) to enter 3-63 characters
        • IP: IP format input
        • To delete, click the X button
        • The firewall between the cluster and the corresponding server must be open to use the added host information
        Table. Quick Query Service Information Input Items
      • In the Cluster Information Input section, enter or select the required information.
        Category
        Required
        Description
        Cluster NameRequiredEnter the cluster name
        • Starts with a lowercase letter and does not end with a special character (-), uses lowercase letters, numbers, and special characters (-) to enter 3-30 characters
        Control Area SettingRequired/Optional
        • Kubernetes Version: Displays the Kubernetes version
          • The Kubernetes version can be upgraded after provisioning.
        • Public Endpoint Access: To access the Kubernetes API server endpoint from outside, select Use and enter the Access Control IP Range (cannot be changed after service application).
        • Control Area Logging: Select whether to use control area logging
          • If Use is selected, the cluster control area’s Audit/event log can be checked in Management > Cloud Monitoring > Log Analysis.
          • 1GB of log storage is provided free of charge for all services in the project, and logs exceeding 1GB will be deleted sequentially.
        Network SettingRequiredSet the network connection
        • VPC: Use the same VPC as Data Service Console
        • Subnet: Select a subnet from the selected VPC
        • Security Group: Click Search and select a security group in the Security Group Selection popup window
        File Storage SettingRequiredSelect the file storage volume to be used by the cluster
        • Default Volume (NFS): Click Search and select a file storage in the File Storage Selection popup window
        Table. Quick Query Service Cluster Information Input Items
      • Enter Node Pool Information area, enter or select the required information.
        Classification
        Required
        Detailed Description
        Node Pool ConfigurationRequired/OptionalEnter detailed information about the node pool to be added
        • * marked items are required input items
          • If the Query Engine Type is Public and Auto Scaling is set to Not Used, only the Node Pool Configuration (Fixed) item can be set.
          • Keypair: Select the authentication method to use when connecting to the Virtual Server
        Table. Quick Query Service Node Pool Information Input Items
      • Enter Additional Information area, enter or select the required information.
        Classification
        Required
        Detailed Description
        TagsOptionalAdd tags
        • Tag Add button to create and add tags or add existing tags
        • Up to 50 tags can be added
        • Newly added tags are applied after service creation is complete
        Table. Quick Query Service Additional Information Input Items
    4. In the Summary panel, check the detailed information created and the estimated billing amount, and click the Complete button.

    • After creation is complete, check the created resource in the Quick Query List page.

    Check Quick Query Details

    You can check the entire resource list and detailed information of the Quick Query service and modify it. The Quick Query Details page consists of Details, Tags, and Work History tabs.

    To check the detailed information of the Quick Query service, follow these steps:

    1. Click All Services > Data Analytics > Quick Query menu. Move to the Quick Query Service Home page.
    2. Click the Quick Query menu on the Service Home page. Move to the Quick Query List page.
    3. Click the resource to check the detailed information on the Quick Query List page. Move to the Quick Query Details page.
      • At the top of the Quick Query Details page, status information and additional feature information are displayed.
        ClassificationDetailed Description
        Status DisplayStatus of the Quick Query created by the user
        • Creating: Creating
        • Running: Creation complete, service available
        • Updating: Setting update in progress
        • Terminating: Service termination in progress
        • Error: Error occurred during creation or service abnormal state
        Hosts File Setting InformationButton to check and copy host file information for accessing Quick Query and Data Service Console
        Service TerminationButton to terminate the service
        Table. Quick Query Status Information and Additional Features

    Details

    You can check the detailed information of the resource selected on the Quick Query List page and modify it if necessary.

    ClassificationDetailed Description
    ServiceService name
    Resource TypeResource type
    SRNUnique resource ID in Samsung Cloud Platform
    • Means cluster SRN
    Resource NameResource name
    • Means cluster name
    Resource IDUnique resource ID in the service
    CreatorUser who created the service
    Creation TimeTime when the service was created
    ModifierUser who modified the service information
    Modification TimeTime when the service information was modified
    Quick Query NameQuick Query name
    DescriptionAdditional information or description of Quick Query
    VersionQuick Query version
    Service TypeQuick Query service type
    Query Engine TypeQuick Query engine type
    Engine Spec
    • Whether Auto Scaling is used
    • Resource capacity for cluster configuration
    Maximum Concurrent Query ExecutionMaximum number of queries that can be executed concurrently in Quick Query
    Domain SettingQuick Query domain
    Data Service ConsoleData Service Console domain
    Host AliasHost information to be connected to Quick Query
    Web URLWeb URL of Data Service Console and Quick Query
    Cluster NameName of the cluster composed of servers
    Installation Node InformationDetailed information of the installed node pool
    Table. Quick Query Details Tab Items

    Tags

    You can check the tag information of the resource selected on the Quick Query List page and add, change, or delete it.

    ClassificationDetailed Description
    Tag ListTag list
    • Key, Value information of tags can be checked
    • Up to 50 tags can be added per resource
    • When entering tags, existing Key and Value lists can be searched and selected
    Table. Quick Query Tag Tab Items

    Work History

    You can check the work history of the resource selected on the Quick Query List page.

    ClassificationDetailed Description
    Work History ListResource change history
    • Work time, resource type, resource name, work details, work result, and worker information can be checked
    • Click the corresponding resource in the Work History List. The Work History Details popup window opens.
    • Detailed Search button provides detailed search function
    Table. Quick Query Work History Tab Detailed Information Items

    Connecting to Quick Query

    To connect to Quick Query, follow these steps:

    1. Check the IP of the Windows system (PC) that you want to connect to Quick Query.
      • You need to check the public IP of the system since external access is required.
    2. Check if the IGW connection is set to use in the VPC where Quick Query is installed.
      • The Internet Gateway setting must be enabled for external access.
    3. Add the following contents to the hosts file of the Windows system:
      • Domain address of Data Service Console
      • Domain address of Data Service Console IAM
      • Domain address of Quick Query
      • You can check the hosts file setting information by clicking Hosts file setting information in the Quick Query detailed screen.
    4. Add the following rules to the VPC IGW Firewall that you selected when applying for the Quick Query service:
      • Source IP: IP of the Windows system (PC)
      • Destination IP: Subnet range of the Kubernetes where Quick Query is installed
      • Protocol: TCP
      • Port: 443
    5. Add the following rules to the Load Balancer Firewall that you selected when applying for the Quick Query service:
      • Source IP: IP of the Windows system (PC)
      • Destination IP: Subnet range of the Kubernetes where Quick Query is installed
      • Protocol: TCP
      • Port: 443
    6. Add the following rules to the Security Group that you selected when applying for the Quick Query service:
      • Type: Inbound rule
      • Destination address: IP of the Windows system (PC)
      • Protocol: TCP
      • Port: 443, 30000 ~ 32767
    7. Run the Chrome browser on the Windows system (PC) that you want to connect to and access the Quick Query URL.

    Quick Query Target IP/Port Information

    To access Quick Query, add the target IP and port for each service to the Security Group as follows:

    ItemProtocolSourceTarget IPPortNote
    Quick QueryTCPUser IPQuick Query443, 30000 ~ 32767Quick Query web https
    Table. Quick Query Target IP/Port Information

    Canceling Quick Query

    You can cancel the service to reduce operating costs. However, canceling the service may immediately stop the operating service, so you should carefully consider the impact of service cancellation before proceeding.

    To cancel Quick Query, follow these steps:

    1. Click the All Services > Data Analytics > Quick Query menu. You will be taken to the Service Home page of Quick Query.
    2. Click the Quick Query menu on the Service Home page. You will be taken to the Quick Query List page.
    3. On the Quick Query List page, select the resource you want to cancel and click the Cancel Service button.
    4. After cancellation is complete, check if the resource has been canceled on the Quick Query List page.