question Quering hive table from spark-shell in Support Questions

question Quering hive table from spark-shell in Support Questions https://community.cloudera.com/t5/Support-Questions/Quering-hive-table-from-spark-shell/m-p/293776#M216869 I tried to run a select query on a hive table through spark shell. this is my code : <LI-CODE lang="markup">scala >import org.apache.spark.sql.hive.HiveContext scala >val sqlContext = new HiveContext(sc) scala >val df = sqlContext.sql("select count(*) from bdp.serie") scala >df.head </LI-CODE> but I got an error when I execute any read command (df.head, df.count, df.show) . this is the error :  <LI-CODE lang="markup">org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree: Exchange SinglePartition +- *(1) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#13L]) +- HiveTableScan HiveTableRelation `bdp`.`serie`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [data#0, temperature#1, hum#2] at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:119) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) ... 49 elided Caused by: java.io.IOException: Not a file: hdfs://sandbox- hdp.hortonworks.com:8020/warehouse/tablespace/managed/hive/bdp.db/serie/delta_0000001_0000001_0000 at org.apache.hadoop.mapred.FileInputFormat.getSplits(FileInputFormat.java:337) at org.apache.spark.rdd.HadoopRDD.getPartitions(HadoopRDD.scala:200) at org.apache.spark.rdd.RDD$$anonfun$partitions$2.apply(RDD.scala:253) at org.apache.spark.rdd.RDD$$anonfun$partitions$2.apply(RDD.scala:251) ... 73 more </LI-CODE>  ps : when I execute the show tables query I get the result without error.show create table serie : <img src="https://community.cloudera.com/t5/image/serverpage/image-id/27097i57A7B60CEE2BB979/image-size/medium?v=v2&px=400" role="button" title="stack1.PNG" alt="stack1.PNG" />and hdfs dfs -ls ../../warehouse/tablespace/managed/hive/bdp.db/serie  : <img src="https://community.cloudera.com/t5/image/serverpage/image-id/27098i4B6F0995648B6EA5/image-size/medium?v=v2&px=400" role="button" title="stck2.PNG" alt="stck2.PNG" /> Sun, 12 Apr 2020 10:24:33 GMT hicha 2020-04-12T10:24:33Z