Updated on 2022-09-14 GMT+08:00

Commissioning Applications on Windows

Running the JDBC Client Using CLI

  1. Run the sample project.

    After importing and modifying the sample project In the development environment, right-click JDBCExample.java and choose Run 'JDBCExample.main()' from the shortcut menu to run the corresponding application project.

    You can use either of the following method to access an MRS cluster to operate Impala on Windows.

    Method 1: Apply for a Windows ECS to access the MRS cluster to operate Impala. Run the sample code after the development environment is installed. To apply for ECS to access the MRS cluster, perform the following steps:
    1. On the Active Clusters page, click the name of an existing cluster.

      On the cluster details page, record the AZ, VPC, and Default Security Group of the Master node.

    2. On the ECS management console, create a new ECS.

      The AZ, VPC, and security group of ECS must be the same as those of the cluster to be accessed.

      Select a Windows public image.

      For details about other configuration parameters, see Purchasing an ECS.

    Method 2: Use the local host to access the MRS cluster to operate Impala. After installing the development environment and completing the following steps, run the sample code.

    1. Bind an EIP address to any Core node. Then, configure the IP address in the impala-server configuration item in the client.properties file of the development sample to access the Impala service and submit SQL statements. To bind an EIP, perform the following steps:
      1. On the ECS page, apply for an EIP and bind it to the ECS. For details, see Assigning an EIP and Binding It to an ECS.
      2. Open security group rules for the MRS cluster.

        Add security group rules to the security groups of Master and Core nodes in the cluster so that ECS can access the cluster. For details, see Configuring Security Group Rules.

    2. Modify the IP addresses of the kdc, admin_server, and kpasswd_server parameters in the krb5.conf file of the imported sample to the EIPs corresponding to KrbServer. (The Kerberos service is deployed on the master node by default. Therefore, the public IP address of the master node is used.)

    The client.properties configuration in the sample is as follows:

    auth = KERBEROS ## Kerberos mode
    principal = impala/node-ana-corexphm@10530B19_8446_4846_97BD_87880A2535DF.COM  ## Principal used by the Impalad instance to be connected
    impala-server = XX.XX.XX.XX:21050 ## Specifies the service address bound to the Core node where the Impalad instance to be connected is located. If method 2 is used, enter the EIP bound in step 1.

  2. View the execution result.

    View the Impala SQL query results in the sample code. If the following information is displayed, the execution is successful.

    Result:

    Create table success!
    _c0
    0
    Delete table success!