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;"

Была ли эта статья полезна?