Ngone51 commented on a change in pull request #26736: [SPARK-30098][SQL] Use default datasource as provider for CREATE TABLE syntax URL: https://github.com/apache/spark/pull/26736#discussion_r353186380
########## File path: sql/core/src/test/resources/sql-tests/inputs/postgreSQL/create_view.sql ########## @@ -41,7 +41,7 @@ DROP TABLE emp; -- These views are left around mainly to exercise special cases in pg_dump. -- [SPARK-19842] Informational Referential Integrity Constraints Support in Spark -CREATE TABLE view_base_table (key int /* PRIMARY KEY */, data varchar(20)); +CREATE TABLE view_base_table (key int /* PRIMARY KEY */, data varchar(20)) STORED AS parquet; Review comment: The output of this query is: ``` org.apache.spark.sql.AnalysisException Hive support is required to CREATE Hive TABLE (AS SELECT); ``` Without `STORED AS parquet`, this query now uses `parquet` as table provider, so it doesn't need hive support anymore. Maybe, we shall use `USING hive` ? But it throws something like `dataSource not found: hive`. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
