[jira] [Created] (SPARK-4131) support “insert overwrite LOCAL DIRECTORY ‘dir’ select * from tablename;”

["XiaoJing wang (JIRA)" <ji...@apache.org>]

XiaoJing wang created SPARK-4131:
------------------------------------

             Summary: support “insert overwrite LOCAL DIRECTORY ‘dir’ select * from tablename;”
                 Key: SPARK-4131
                 URL: https://issues.apache.org/jira/browse/SPARK-4131
             Project: Spark
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 1.1.0
            Reporter: XiaoJing wang
            Priority: Critical
             Fix For: 1.3.0


Writing data into the filesystem from queries,SparkSql is not support .
eg:
<code>insert overwrite LOCAL DIRECTORY  '/data1/wangxj/sql_spark' select * from page_views; </code>
out:
<code>
java.lang.RuntimeException: 
Unsupported language features in query: insert overwrite LOCAL DIRECTORY  '/data1/wangxj/sql_spark' select * from page_views
TOK_QUERY
  TOK_FROM
    TOK_TABREF
      TOK_TABNAME
        page_views
  TOK_INSERT
    TOK_DESTINATION
      TOK_LOCAL_DIR
        '/data1/wangxj/sql_spark'
    TOK_SELECT
      TOK_SELEXPR
        TOK_ALLCOLREF



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