Help Center/ MapReduce Service/ User Guide (Kuala Lumpur Region)/ FAQs/ Big Data Service Development/ How Do I Do If an Error Occurs When Hive Runs the beeline -e Command to Execute Multiple Statements?
Updated on 2022-12-14 GMT+08:00
View PDF
Share

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

When Hive of MRS 3.x runs the beeline -e " use default;show tables;" command, the following error message is displayed: 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;"