On this page

Question
Answer

Show all

Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Spark2x/ Common Issues About Spark2x/ Spark SQL and DataFrame/ Why Does the "--hivevar" Option I Specified in the Command for Starting spark-beeline Fail to Take Effect?

Why Does the "--hivevar" Option I Specified in the Command for Starting spark-beeline Fail to Take Effect?

Updated on 2022-11-18 GMT+08:00

View PDF

Question

Why does the --hivevar option I specified in the command for starting spark-beeline fail to take effect?

In the V100R002C60 version, if I use the --hivevar <VAR_NAME>=<var_value> option to define a variable in the command for starting spark-beeline, no error is reported in spark-beeline. However, if the variable <VAR_NAME> is used in SQL, the variable cannot be parsed and the <VAR_NAME> exception is reported.

For example:

Run the following command to start the spark-beeline:
spark-beeline --hivevar <VAR_NAME>=<var_value>

After spark-beeline is started successfully, I run the SQL statements DROP TABLE ${VAR_NAME} in spark-beeline. The VAR_NAME exception occurs.

Answer

In the V100R002C60 version, the --hivevar <VAR_NAME>=<var_value> feature of Hive is not supported in Spark because multi-session management function is added. Therefore, the --hivevar option in the command for starting spark-beeline is invalid.

Parent topic: Spark SQL and DataFrame

Previous topic: Why No Result Is found When 2016-6-30 Is Set in the Date Field as the Filter Condition?

Next topic: Why Does the "Permission denied" Exception Occur When I Create a Temporary Table or View in Spark-beeline?

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback