[ https://issues.apache.org/jira/browse/SPARK-15538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrew Or updated SPARK-15538: ------------------------------ Description: Truncate table does not seem to work on data source tables. Repro: {code} val df = Seq((1 , "john", "CA") ,(2,"Mike", "NY"), (3, "Robert", "CA")).toDF("id", "name", "state") df.write.format("parquet").partitionBy("state").saveAsTable("emp") scala> sql("truncate table emp") res8: org.apache.spark.sql.DataFrame = [] scala> sql("select * from emp").show() // FileNotFoundException {code} was: Truncate table does not seems to work on data source table. It returns success without any error , but table is not truncated. Repro: {code} val df = Seq((1 , "john", "CA") ,(2,"Mike", "NY"), (3, "Robert", "CA")).toDF("id", "name", "state") df.write.format("parquet").partitionBy("state").saveAsTable("emp") scala> sql("truncate table emp") res8: org.apache.spark.sql.DataFrame = [] scala> sql("select * from emp").show() // FileNotFoundException {code} > Truncate table does not work on data source table > ------------------------------------------------- > > Key: SPARK-15538 > URL: https://issues.apache.org/jira/browse/SPARK-15538 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.0.0 > Reporter: Suresh Thalamati > Assignee: Andrew Or > Priority: Minor > > Truncate table does not seem to work on data source tables. > Repro: > {code} > val df = Seq((1 , "john", "CA") ,(2,"Mike", "NY"), (3, "Robert", > "CA")).toDF("id", "name", "state") > df.write.format("parquet").partitionBy("state").saveAsTable("emp") > scala> sql("truncate table emp") > res8: org.apache.spark.sql.DataFrame = [] > scala> sql("select * from emp").show() // FileNotFoundException > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org