[ https://issues.apache.org/jira/browse/SPARK-33317?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17225150#comment-17225150 ]
Hyukjin Kwon edited comment on SPARK-33317 at 11/3/20, 6:00 AM: ---------------------------------------------------------------- [~dongjoon], feel free to reopen if you think this ticket should be accessed further. I tend to take an action to JIRAs a bit aggressively so any correction to my action is welcome :-). was (Author: hyukjin.kwon): [~dongjoon], feel free to reopen if you think this ticket should be accessed further. I tend to take an action to JIRAs a bit aggressively so welcome to any correction to my action :-). > 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: Major > Attachments: farmers.csv, image-2020-11-03-13-30-12-049.png > > > 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org