[
https://issues.apache.org/jira/browse/SPARK-18107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15610429#comment-15610429
]
J.P Feng edited comment on SPARK-18107 at 10/27/16 2:51 AM:
------------------------------------------------------------
sure, the source table and the target table are both Hive table, like this:
source table:
CREATE TABLE `tbllog_login`(`server` string,`role_id` bigint, `account_name`
string, `happened_time` int)
PARTITIONED BY (`pt` string, `dt` string)
stored as orc;
target table:
CREATE TABLE `login4game`(`account_name` string, `role_id` string, `server_id`
string, `recdate` string)
PARTITIONED BY (`pt` string, `dt` string) stored as orc;
to confirm my guess, i also do some tests between insert overwrite and insert
into statement, where insert overwrite sometimes can be separated into drop
selected partition and then insert into table , so there are my steps:
was (Author: snodawn):
sure, the source table and the target table are both Hive table, like this:
> Insert overwrite statement runs much slower in spark-sql than it does in
> hive-client
> ------------------------------------------------------------------------------------
>
> Key: SPARK-18107
> URL: https://issues.apache.org/jira/browse/SPARK-18107
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0
> Environment: spark 2.0.0
> hive 2.0.1
> Reporter: J.P Feng
>
> I find insert overwrite statement running in spark-sql or spark-shell spends
> much more time than it does in hive-client (i start it in
> apache-hive-2.0.1-bin/bin/hive ), where spark costs about ten minutes but
> hive-client just costs less than 20 seconds.
> These are the steps I took.
> Test sql is :
> insert overwrite table login4game partition(pt='mix_en',dt='2016-10-21')
> select distinct account_name,role_id,server,'1476979200' as recdate, 'mix' as
> platform, 'mix' as pid, 'mix' as dev from tbllog_login where pt='mix_en' and
> dt='2016-10-21' ;
> there are 257128 lines of data in tbllog_login with
> partition(pt='mix_en',dt='2016-10-21')
> ps:
> I'm sure it must be "insert overwrite" costing a lot of time in spark, may be
> when doing overwrite, it need to spend a lot of time in io or in something
> else.
> I also compare the executing time between insert overwrite statement and
> insert into statement.
> 1. insert overwrite statement and insert into statement in spark:
> insert overwrite statement costs about 10 minutes
> insert into statement costs about 30 seconds
> 2. insert into statement in spark and insert into statement in hive-client:
> spark costs about 30 seconds
> hive-client costs about 20 seconds
> the difference is little that we can ignore
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
