[jira] [Commented] (SPARK-9344) Spark SQL documentation does not clarify INSERT INTO behavior

["Josh Rosen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-9344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14939130#comment-14939130 ] 

Josh Rosen commented on SPARK-9344:
-----------------------------------

I think this is the relevant part of the stacktrace:

{code}
org.apache.spark.sql.AnalysisException: no such table test_data1; 
{code}

The Data Sources {{save}} method does not automatically register / create tables or temp tables.  Did you mean to use {{saveAsTable}} instead? See  https://spark.apache.org/docs/latest/sql-programming-guide.html#saving-to-persistent-tables

> Spark SQL documentation does not clarify INSERT INTO behavior
> -------------------------------------------------------------
>
>                 Key: SPARK-9344
>                 URL: https://issues.apache.org/jira/browse/SPARK-9344
>             Project: Spark
>          Issue Type: Documentation
>          Components: Documentation, SQL
>    Affects Versions: 1.4.1
>            Reporter: Simeon Simeonov
>            Priority: Minor
>              Labels: documentation, sql
>
> The Spark SQL documentation does not address {{INSERT INTO}} behavior. The section on Hive compatibility is misleading as it claims support for "the vast majority of Hive features". The user mailing list has conflicting information, including posts that claim {{INSERT INTO}} support targeting 1.0.
> In 1.4.1, using Hive {{INSERT INTO}} syntax generates parse errors.



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