Help Center/ MapReduce Service/ FAQs/ Component Configurations/ What Should I Do If an Error Occurs When Hive Runs the beeline -e Command to Execute Multiple Statements?
Updated on 2024-08-16 GMT+08:00
View PDF
Share

What Should I Do If an Error Occurs When Hive Runs the beeline -e Command to Execute Multiple Statements?

When Hive uses Beeline to run the beeline -e "use default;show tables;" command on an MRS 3.x cluster, the following error is reported:

Error while compiling statement: FAILED: ParseException line 1:11 missing EOF at ';' near 'default' (state=42000,code=40000)

Solutions:

  • Method 1: Replace the beeline -e " use default;show tables;" command with beeline --entirelineascommand=false -e "use default;show tables;".
  • Method 2:
    1. In the /opt/Bigdata/client/Hive directory on the Hive client, change export CLIENT_HIVE_ENTIRELINEASCOMMAND=true in the component_env file to export CLIENT_HIVE_ENTIRELINEASCOMMAND=false.
      Figure 1 Changing the component_env file
    2. Run the following command to verify the configuration:

      source /opt/Bigdata/client/bigdata_env

      beeline -e "use default;show tables;"

Parent topic: Component Configurations