[SPARK-19927] SparkThriftServer2 can not get ''--hivevar" variables in spark 2.1

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.0.1, 2.1.0
• Component/s: SQL

Environment

CentOS 6.5,spark 2.1 build with mvn -Pyarn -Phadoop-2.6 -Dhadoop.version=2.6.0 -Phive -Phive-thriftserver -Dscala-2.11

• External issue ID: https://issues.apache.org/jira/browse/SPARK-13983 https://issues.apache.org/jira/browse/SPARK-18086
• Assignee: Unassigned
• Reporter: bruce xu
• Created: 12/Mar/17 18:02
• Updated: 23/Mar/17 06:41
• Resolved: 22/Mar/17 16:34

Description

suppose the content of file test.sql:
-------------------------------------------------
!connect jdbc:hive2://localhost:10000 test test
USE ${hivevar:db_name};
-------------------------------------------------

when execute beeline command: bin/beeline -f /tmp/test.sql --hivevar db_name=offline
the output is:
------------------------------------------------------------------------------------
Error: org.apache.spark.sql.catalyst.parser.ParseException:
no viable alternative at input '<EOF>'(line 1, pos 4)

== SQL ==
use
----^^^ (state=,code=0)
-------------------------------------------------------------------------------------

so the parameter --hivevar can not be read from beeline CLI.

Issue Links

• duplicates: SPARK-13983 HiveThriftServer2 can not get "--hiveconf" or ''--hivevar" variables since 1.6 version (both multi-session and single session)
• links to: [Github] Pull Request #17269 (BruceXu1991)