spark git commit: [SPARK-16267][TEST] Replace deprecated `CREATE TEMPORARY TABLE ... USING` from testsuites.
Repository: spark
Updated Branches:
refs/heads/branch-2.0 e1bdf1e02 -> b52bd8070
[SPARK-16267][TEST] Replace deprecated `CREATE TEMPORARY TABLE ... USING` from
testsuites.
## What changes were proposed in this pull request?
After SPARK-15674, `DDLStrategy` prints out the following deprecation messages
in the testsuites.
```
12:10:53.284 WARN org.apache.spark.sql.execution.SparkStrategies$DDLStrategy:
CREATE TEMPORARY TABLE normal_orc_source USING... is deprecated,
please use CREATE TEMPORARY VIEW viewName USING... instead
```
Total : 40
- JDBCWriteSuite: 14
- DDLSuite: 6
- TableScanSuite: 6
- ParquetSourceSuite: 5
- OrcSourceSuite: 2
- SQLQuerySuite: 2
- HiveCommandSuite: 2
- JsonSuite: 1
- PrunedScanSuite: 1
- FilteredScanSuite 1
This PR replaces `CREATE TEMPORARY TABLE` with `CREATE TEMPORARY VIEW` in order
to remove the deprecation messages in the above testsuites except `DDLSuite`,
`SQLQuerySuite`, `HiveCommandSuite`.
The Jenkins results shows only remaining 10 messages.
https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/61422/consoleFull
## How was this patch tested?
This is a testsuite-only change.
Author: Dongjoon Hyun
Closes #13956 from dongjoon-hyun/SPARK-16267.
(cherry picked from commit 831a04f5d152d1839c0edfdf65bb728aa5957f16)
Signed-off-by: Reynold Xin
Project: http://git-wip-us.apache.org/repos/asf/spark/repo
Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/b52bd807
Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/b52bd807
Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/b52bd807
Branch: refs/heads/branch-2.0
Commit: b52bd8070dc852b419283f8a14595e42c179d3d0
Parents: e1bdf1e
Author: Dongjoon Hyun
Authored: Wed Jun 29 17:29:17 2016 -0700
Committer: Reynold Xin
Committed: Wed Jun 29 17:29:23 2016 -0700
--
.../sql/execution/datasources/json/JsonSuite.scala | 2 +-
.../org/apache/spark/sql/jdbc/JDBCWriteSuite.scala | 4 ++--
.../apache/spark/sql/sources/FilteredScanSuite.scala| 2 +-
.../org/apache/spark/sql/sources/PrunedScanSuite.scala | 2 +-
.../org/apache/spark/sql/sources/TableScanSuite.scala | 12 ++--
.../org/apache/spark/sql/hive/orc/OrcSourceSuite.scala | 4 ++--
.../scala/org/apache/spark/sql/hive/parquetSuites.scala | 10 +-
7 files changed, 18 insertions(+), 18 deletions(-)
--
http://git-wip-us.apache.org/repos/asf/spark/blob/b52bd807/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
--
diff --git
a/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
b/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
index 9f35c02..6c72019 100644
---
a/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
+++
b/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
@@ -847,7 +847,7 @@ class JsonSuite extends QueryTest with SharedSQLContext
with TestJsonData {
sql(
s"""
-|CREATE TEMPORARY TABLE jsonTableSQL
+|CREATE TEMPORARY VIEW jsonTableSQL
|USING org.apache.spark.sql.json
|OPTIONS (
| path '$path'
http://git-wip-us.apache.org/repos/asf/spark/blob/b52bd807/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
--
diff --git
a/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
b/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
index 48fa5f9..ff66f53 100644
--- a/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
+++ b/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
@@ -57,14 +57,14 @@ class JDBCWriteSuite extends SharedSQLContext with
BeforeAndAfter {
sql(
s"""
-|CREATE TEMPORARY TABLE PEOPLE
+|CREATE OR REPLACE TEMPORARY VIEW PEOPLE
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url1', dbtable 'TEST.PEOPLE', user 'testUser',
password 'testPass')
""".stripMargin.replaceAll("\n", " "))
sql(
s"""
-|CREATE TEMPORARY TABLE PEOPLE1
+|CREATE OR REPLACE TEMPORARY VIEW PEOPLE1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url1', dbtable 'TEST.PEOPLE1', user 'testUser',
password 'testPass')
""".stripMargin.replaceAll("\n", " "))
http://git-wip-us.apache.org/repos/asf/spark/blob/b52bd807/sql/core/src/test/scala/org/apache/spark/sql/sources/FilteredScanSuite.scala
--
diff --git
a/sql/core/src/test/scala/org/apache/spark/sql/sources/FilteredScanSuite.scala
b/sql/core/src/test/scala/org/apache/spark/sql/source
spark git commit: [SPARK-16267][TEST] Replace deprecated `CREATE TEMPORARY TABLE ... USING` from testsuites.
Repository: spark
Updated Branches:
refs/heads/master d063898be -> 831a04f5d
[SPARK-16267][TEST] Replace deprecated `CREATE TEMPORARY TABLE ... USING` from
testsuites.
## What changes were proposed in this pull request?
After SPARK-15674, `DDLStrategy` prints out the following deprecation messages
in the testsuites.
```
12:10:53.284 WARN org.apache.spark.sql.execution.SparkStrategies$DDLStrategy:
CREATE TEMPORARY TABLE normal_orc_source USING... is deprecated,
please use CREATE TEMPORARY VIEW viewName USING... instead
```
Total : 40
- JDBCWriteSuite: 14
- DDLSuite: 6
- TableScanSuite: 6
- ParquetSourceSuite: 5
- OrcSourceSuite: 2
- SQLQuerySuite: 2
- HiveCommandSuite: 2
- JsonSuite: 1
- PrunedScanSuite: 1
- FilteredScanSuite 1
This PR replaces `CREATE TEMPORARY TABLE` with `CREATE TEMPORARY VIEW` in order
to remove the deprecation messages in the above testsuites except `DDLSuite`,
`SQLQuerySuite`, `HiveCommandSuite`.
The Jenkins results shows only remaining 10 messages.
https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/61422/consoleFull
## How was this patch tested?
This is a testsuite-only change.
Author: Dongjoon Hyun
Closes #13956 from dongjoon-hyun/SPARK-16267.
Project: http://git-wip-us.apache.org/repos/asf/spark/repo
Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/831a04f5
Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/831a04f5
Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/831a04f5
Branch: refs/heads/master
Commit: 831a04f5d152d1839c0edfdf65bb728aa5957f16
Parents: d063898
Author: Dongjoon Hyun
Authored: Wed Jun 29 17:29:17 2016 -0700
Committer: Reynold Xin
Committed: Wed Jun 29 17:29:17 2016 -0700
--
.../sql/execution/datasources/json/JsonSuite.scala | 2 +-
.../org/apache/spark/sql/jdbc/JDBCWriteSuite.scala | 4 ++--
.../apache/spark/sql/sources/FilteredScanSuite.scala| 2 +-
.../org/apache/spark/sql/sources/PrunedScanSuite.scala | 2 +-
.../org/apache/spark/sql/sources/TableScanSuite.scala | 12 ++--
.../org/apache/spark/sql/hive/orc/OrcSourceSuite.scala | 4 ++--
.../scala/org/apache/spark/sql/hive/parquetSuites.scala | 10 +-
7 files changed, 18 insertions(+), 18 deletions(-)
--
http://git-wip-us.apache.org/repos/asf/spark/blob/831a04f5/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
--
diff --git
a/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
b/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
index 9f35c02..6c72019 100644
---
a/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
+++
b/sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/json/JsonSuite.scala
@@ -847,7 +847,7 @@ class JsonSuite extends QueryTest with SharedSQLContext
with TestJsonData {
sql(
s"""
-|CREATE TEMPORARY TABLE jsonTableSQL
+|CREATE TEMPORARY VIEW jsonTableSQL
|USING org.apache.spark.sql.json
|OPTIONS (
| path '$path'
http://git-wip-us.apache.org/repos/asf/spark/blob/831a04f5/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
--
diff --git
a/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
b/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
index 48fa5f9..ff66f53 100644
--- a/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
+++ b/sql/core/src/test/scala/org/apache/spark/sql/jdbc/JDBCWriteSuite.scala
@@ -57,14 +57,14 @@ class JDBCWriteSuite extends SharedSQLContext with
BeforeAndAfter {
sql(
s"""
-|CREATE TEMPORARY TABLE PEOPLE
+|CREATE OR REPLACE TEMPORARY VIEW PEOPLE
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url1', dbtable 'TEST.PEOPLE', user 'testUser',
password 'testPass')
""".stripMargin.replaceAll("\n", " "))
sql(
s"""
-|CREATE TEMPORARY TABLE PEOPLE1
+|CREATE OR REPLACE TEMPORARY VIEW PEOPLE1
|USING org.apache.spark.sql.jdbc
|OPTIONS (url '$url1', dbtable 'TEST.PEOPLE1', user 'testUser',
password 'testPass')
""".stripMargin.replaceAll("\n", " "))
http://git-wip-us.apache.org/repos/asf/spark/blob/831a04f5/sql/core/src/test/scala/org/apache/spark/sql/sources/FilteredScanSuite.scala
--
diff --git
a/sql/core/src/test/scala/org/apache/spark/sql/sources/FilteredScanSuite.scala
b/sql/core/src/test/scala/org/apache/spark/sql/sources/FilteredScanSuite.scala
index 45e737f..be56c96 100644
---
a/sql/core/src/test/scala/org/apache/spark/sq
