Running Python and Viewing Results

Running Python in CLI Mode

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

   chmod +x python-examples -R

2. Enter the service plane IP address of the node where HiveServer is installed in the hosts array of python-examples/pyCLI_nosec.py.
3. Run the following command:

   cd python-examples

   python pyCLI_nosec.py

4. 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']     

   

   If the following exception occurs:

   importError: libsasl2.so.2: cannot open shared object file: No such file or directory

   You can handle the problem as follows:

   1. Run the following command to check the LibSASL version in the installed operating system.

      ldconfig -p|grep sasl

      If the following is displayed, the current operating system only has the 3.x version.

      libsasl2.so.3 (libc6,x86-64) => /usr/lib64/libsasl2.so.3
      libsasl2.so.3 (libc6) => /usr/lib/libsasl2.so.3

   2. If only the 3. x version exists, run the following command to create a soft link.

      ln -s /usr/lib64/libsasl2.so.3.0.0 /usr/lib64/libsasl2.so.2