[jira] [Updated] (SPARK-33317) Spark Hive SQL returning empty dataframe

["Debadutta (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-33317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Debadutta updated SPARK-33317:
------------------------------
    Attachment: farmers.csv

> Spark Hive SQL returning empty dataframe
> ----------------------------------------
>
>                 Key: SPARK-33317
>                 URL: https://issues.apache.org/jira/browse/SPARK-33317
>             Project: Spark
>          Issue Type: Bug
>          Components: Spark Core, Spark Shell
>    Affects Versions: 2.4.6
>            Reporter: Debadutta
>            Priority: Blocker
>         Attachments: farmers.csv
>
>
> I am trying to run a sql query on a hive table using hive connector in spark but I am getting an empty dataframe. The query I am trying to run:-
> {{sparkSession.sql("select fmid from farmers where fmid between ' 1000405134' and '1000772585'")}}
> This is failing but if I remove the leading whitespaces it works.
> {{sparkSession.sql("select fmid from farmers where fmid between '1000405134' and '1000772585'")}}
> Currently, I am removing leading and trailing whitespaces as a workaround. But the same query with whitespaces works fine in hive console.



--
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