title: select query of any table using spark.sql giving zero records sometimes but same select query giving result in HIVE CLI
body: <pre><code>Val result=spark.sql("select * from employee")
  </code></pre>
  
  <p>is giving zero results sometimes even though the data present in the hive.</p>
  
  <p>while executing the same select query in HIVE CLI result's we are getting </p>