Commissioning the Hive Python3 Sample Program

Running Python in CLI Mode

1. Grant the execution permission for the script of python3-examples folder. Run the following command in the CLI:

   chmod +x python3-examples -R.

2. In python3-examples/pyCLI_sec.py, change the value of host to the service plane IP address of the node where HiveServer is installed, and change the value of port to the port (hive.server2.thrift.port) used by Hive to provide the Thrift service. The default value is 10000.
3. Change hadoop.hadoop.com in the conf of python-examples/pyCLI_sec.py to hadoop.the actual domain name. To view the actual domain name, log in to FusionInsight Manager and choose System > Permission > Domain and Mutual Trust > Local Domain.
4. Run the kinit command to obtain the cache for Kerberos authentication.

   Use the developer account created in Preparing MRS Application Development User to run the following commands to run the client program:

   kinit -kt keytabstorage path username

   cd python3-examples

   python3 pyCLI_sec.py

5. In the CLI, view the HQL query results in the example codes. For example:

   [['default', '']] 
    [{'comment': 'from deserializer', 'columnName': 'tab_name', 'type': 'STRING_TYPE'}] 
    ['xx']