[ https://issues.apache.org/jira/browse/SPARK-29174?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933203#comment-16933203 ]
Ajith S commented on SPARK-29174: --------------------------------- Had checked with original author for this https://github.com/apache/spark/pull/18975#issuecomment-523261355 > LOCAL is not supported in INSERT OVERWRITE DIRECTORY to data source > ------------------------------------------------------------------- > > Key: SPARK-29174 > URL: https://issues.apache.org/jira/browse/SPARK-29174 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.0.0 > Reporter: ABHISHEK KUMAR GUPTA > Priority: Major > > *using does not work for insert overwrite when in local but works when > insert overwrite in HDFS directory* > ** > > 0: jdbc:hive2://10.18.18.214:23040/default> insert overwrite directory > '/user/trash2/' using parquet select * from trash1 a where a.country='PAK'; > +---------+--+ > | Result | > +---------+--+ > +---------+--+ > No rows selected (0.448 seconds) > 0: jdbc:hive2://10.18.18.214:23040/default> insert overwrite local directory > '/opt/trash2/' using parquet select * from trash1 a where a.country='PAK'; > Error: org.apache.spark.sql.catalyst.parser.ParseException: > LOCAL is not supported in INSERT OVERWRITE DIRECTORY to data source(line 1, > pos 0) > > == SQL == > insert overwrite local directory '/opt/trash2/' using parquet select * from > trash1 a where a.country='PAK' > ^^^ (state=,code=0) > 0: jdbc:hive2://10.18.18.214:23040/default> insert overwrite local directory > '/opt/trash2/' stored as parquet select * from trash1 a where a.country='PAK'; > +---------+--+ > | Result | > +---------+--+ > | | | > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org