[jira] [Resolved] (SPARK-19120) Returned an Empty Result after Loading a Hive Table

["Wenchen Fan (JIRA)" <ji...@apache.org>]

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

Wenchen Fan resolved SPARK-19120.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 2.2.0
                   2.1.1

Issue resolved by pull request 16500
[https://github.com/apache/spark/pull/16500]

> Returned an Empty Result after Loading a Hive Table
> ---------------------------------------------------
>
>                 Key: SPARK-19120
>                 URL: https://issues.apache.org/jira/browse/SPARK-19120
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.1.0
>            Reporter: Xiao Li
>            Assignee: Xiao Li
>            Priority: Critical
>              Labels: correctness
>             Fix For: 2.1.1, 2.2.0
>
>
> {noformat}
>         sql(
>           """
>             |CREATE TABLE test (a STRING)
>             |STORED AS PARQUET
>           """.stripMargin)
>        spark.table("test").show()
>         sql(
>           s"""
>              |LOAD DATA LOCAL INPATH '$newPartitionDir' OVERWRITE
>              |INTO TABLE test
>            """.stripMargin)
>         spark.table("test").show()
> {noformat}
> The returned result is empty after table loading. We should refresh the metadata cache after loading the data to the table. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org