[
https://issues.apache.org/jira/browse/SPARK-31955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17133298#comment-17133298
]
YoungGyu Chun commented on SPARK-31955:
---------------------------------------
[~denglg]
I cannot reproduce this locally. :
Whole data:
{code:java}
0: jdbc:hive2://localhost:10000> select * from info_dev.beeline_test;
+------------------+--------------------+--+
| beeline_test.id | beeline_test.name |
+------------------+--------------------+--+
| 1 | aaa |
| 2 | bbb |
| 3 | ccc |
| 1 | aaa |
+------------------+--------------------+--+
4 rows selected (0.239 seconds)
0: jdbc:hive2://localhost:10000>
{code}
test2.sql:
{code:java}
jun562@CHUNYLT:~/spark-2.4.4-bin-hadoop2.7/bin$ cat test2.sql
select * from info_dev.beeline_test where name='bbb'
jun562@CHUNYLT:~/spark-2.4.4-bin-hadoop2.7/bin$
{code}
Execute a test2.sql file on Beeline by running a "run" command:
{code:java}
Connected to: Apache Hive (version 1.2.1)
Driver: Hive JDBC (version 1.2.1.spark2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000> !run
/home/jun562/apache-hive-1.2.1-bin/bin/test2.sql
>>> select * from info_dev.beeline_test where name='bbb';
+------------------+--------------------+--+
| beeline_test.id | beeline_test.name |
+------------------+--------------------+--+
| 2 | bbb |
+------------------+--------------------+--+
1 row selected (0.406 seconds)
0: jdbc:hive2://localhost:10000>
{code}
Execute SQL on Beeline:
{code:java}
0: jdbc:hive2://localhost:10000> select * from info_dev.beeline_test where
name='bbb';
+------------------+--------------------+--+
| beeline_test.id | beeline_test.name |
+------------------+--------------------+--+
| 2 | bbb |
+------------------+--------------------+--+
1 row selected (0.233 seconds)
0: jdbc:hive2://localhost:10000>
{code}
cc [~dongjoon] [~hyukjin.kwon] [~srowen]
> Beeline discard the last line of the sql file when submited to thriftserver
> via beeline
> ----------------------------------------------------------------------------------------
>
> Key: SPARK-31955
> URL: https://issues.apache.org/jira/browse/SPARK-31955
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.3.4
> Reporter: Lin Gang Deng
> Priority: Major
>
> I submitted a sql file on beeline and the result returned is wrong. After
> many tests, it was found that the sql executed by Spark would discard the
> last line.This should be beeline's bug parsing sql file.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
