You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "xinzhang (Jira)" <ji...@apache.org> on 2021/02/01 09:51:00 UTC
[jira] [Commented] (SPARK-12497) thriftServer does not support
semicolon in sql
[ https://issues.apache.org/jira/browse/SPARK-12497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17276207#comment-17276207 ]
xinzhang commented on SPARK-12497:
----------------------------------
It's still a bug with spark 3.0.0 .
Start spark thriftserver with default port 10000, use spark's beeline connect.
Setp 1:
[root@172-25-48-173 spark]# sh spark-3.0.0-bin-hadoop2.7/sbin/start-thriftserver.sh
...
Setp 2:
[root@172-25-48-173 spark]# sh spark-3.0.0-bin-hadoop2.7/bin/beeline
Beeline version 1.2.1.spark2 by Apache Hive
beeline> !connect jdbc:hive2://172.25.48.173:10000
Connecting to jdbc:hive2://172.25.48.173:10000
Enter username for jdbc:hive2://172.25.48.173:10000:
Enter password for jdbc:hive2://172.25.48.173:10000:
log4j:WARN No appenders could be found for logger (org.apache.hive.jdbc.Utils).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Connected to: Spark SQL (version 2.4.7)
Driver: Hive JDBC (version 1.2.1.spark2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://172.25.48.173:10000> select '\;';
Error: org.apache.spark.sql.catalyst.parser.ParseException:
no viable alternative at input 'select ''(line 1, pos 7)
== SQL ==
select '\
-------^^^ (state=,code=0)
0: jdbc:hive2://172.25.48.173:10000>
Am i missing something?
> thriftServer does not support semicolon in sql
> -----------------------------------------------
>
> Key: SPARK-12497
> URL: https://issues.apache.org/jira/browse/SPARK-12497
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.5.2
> Reporter: nilonealex
> Priority: Major
>
> 0: jdbc:hive2://192.168.128.130:14005> SELECT ';' from tx_1 limit 1 ;
> Error: org.apache.spark.sql.AnalysisException: cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in select clause; line 1 pos 8 (state=,code=0)
> 0: jdbc:hive2://192.168.128.130:14005>
> 0: jdbc:hive2://192.168.128.130:14005> select '\;' from tx_1 limit 1 ;
> Error: org.apache.spark.sql.AnalysisException: cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in select clause; line 1 pos 9 (state=,code=0)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org