[ https://issues.apache.org/jira/browse/SPARK-27462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jiaan.geng updated SPARK-27462: ------------------------------- Issue Type: Sub-task (was: New Feature) Parent: SPARK-27943 > Spark hive can not choose some columns in target table flexibly, when running > insert into. > ------------------------------------------------------------------------------------------ > > Key: SPARK-27462 > URL: https://issues.apache.org/jira/browse/SPARK-27462 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 2.3.0, 2.4.0 > Reporter: jiaan.geng > Priority: Major > > Spark SQL can not support the feature to choose some columns in target table > flexibly, when running > {code:java} > insert into tableA select ... from tableB;{code} > This feature is supported by Hive, so I think this grammar should be > consistent with Hive。 > Hive support some feature about 'insert into' as follows: > {code:java} > insert into gja_test_spark select * from gja_test; > insert into gja_test_spark(key, value, other) select key, value, other from > gja_test; > insert into gja_test_spark(key, value) select value, other from gja_test; > insert into gja_test_spark(key, other) select value, other from gja_test; > insert into gja_test_spark(value, other) select value, other from > gja_test;{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org