spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xinzhang (Jira)" <j...@apache.org>
Subject [jira] [Commented] (SPARK-12497) thriftServer does not support semicolon in sql
Date Mon, 01 Feb 2021 09:51:00 GMT

    [ 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


Mime
View raw message