Help Center> MapReduce Service> Developer Guide (3.x)> Spark2x Development Guide (Normal Mode)> More Information> FAQ> Permission Problems Occur if spark.sql.limitScan.enabled Is Set to true
View PDF

Permission Problems Occur if spark.sql.limitScan.enabled Is Set to true

Question

If spark-beeline is used to run SQL statements, and the limit field is added to the query statements, error messages (including permission problems) are reported.

Answer

Possible Causes

If the spark-sql query contains the limit field, the query will be performed in Hive. As a result, permission problems occur.

Solution

Set spark.sql.limitScan.enabled to false.

Parent topic: FAQ