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:
- 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
- Run the following command to verify the configuration:
source /opt/Bigdata/client/bigdata_env
beeline -e " use default;show tables;"
- 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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.