[
https://issues.apache.org/jira/browse/SPARK-19927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15937644#comment-15937644
]
bruce xu edited comment on SPARK-19927 at 3/23/17 3:37 AM:
-----------------------------------------------------------
[~q79969786] Thx for response. your comment is half right. reason:
- issue SPARK-19927 derives from SPARK-13983, but SPARK-13983 still not merge
into master.
- SPARK-18086 has merged into master. however this issue only resolve
bin/spark-sql shell interface(code change in SparkSQLCLIDriver) problem but
not dealing with bin/beeline interface(without code change in
SparkSQLOperationManager).
that's why cmd: bin/beeline -f test.sql --hivevar db_name=online can not work
in spark 2.X.
so SPARK-19927's value is to deal with this problem.
was (Author: xwc3504):
[~q79969786] Thx for response. it is half right. reason:
- issue SPARK-19927 derives from SPARK-13983, but SPARK-13983 still not merge
into master.
- SPARK-18086 has merged into master. however this issue only resolve
bin/spark-sql shell interface(code change in SparkSQLCLIDriver) problem but
not dealing with bin/beeline interface(without code change in
SparkSQLOperationManager).
that's why cmd: bin/beeline -f test.sql --hivevar db_name=online can not work
in spark 2.X.
so SPARK-19927's value is to deal with this problem.
> SparkThriftServer2 can not get ''--hivevar" variables in spark 2.1
> ------------------------------------------------------------------
>
> Key: SPARK-19927
> URL: https://issues.apache.org/jira/browse/SPARK-19927
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.1, 2.1.0
> 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
> Reporter: bruce xu
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
