[jira] [Created] (SPARK-18897) Fix SparkR SQL Test to drop test table

["Dongjoon Hyun (JIRA)" <ji...@apache.org>]

Dongjoon Hyun created SPARK-18897:
-------------------------------------

             Summary: Fix SparkR SQL Test to drop test table
                 Key: SPARK-18897
                 URL: https://issues.apache.org/jira/browse/SPARK-18897
             Project: Spark
          Issue Type: Bug
          Components: SparkR
    Affects Versions: 2.0.2
            Reporter: Dongjoon Hyun


Currently, SparkR tests, `R/run-tests.sh` succeeds only once because `test_sparkSQL.R` does not clean up the test table `people`.

As a result, the test data is accumulated at every run and the test cases fail.

The following is the failure result for the second run.
{code}
Failed -------------------------------------------------------------------------
1. Failure: create DataFrame from RDD (@test_sparkSQL.R#204) -------------------
collect(sql("SELECT age from people WHERE name = 'Bob'"))$age not equal to c(16).
Lengths differ: 2 vs 1


2. Failure: create DataFrame from RDD (@test_sparkSQL.R#206) -------------------
collect(sql("SELECT height from people WHERE name ='Bob'"))$height not equal to c(176.5).
Lengths differ: 2 vs 1
{code}



--
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