kudu-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Jacobs ...@cloudera.com>
Subject Re: KUDU INSERT SLOWLY
Date Tue, 22 Aug 2017 17:17:26 GMT
There are some improvements we hope to make in Impala to reduce the
planning overhead for these simple DML statements. You can track that
work with: https://issues.apache.org/jira/browse/IMPALA-5277

-Matt

On Tue, Aug 22, 2017 at 1:12 AM, Balázs Jeszenszky <balazsj@cloudera.com> wrote:
> [dev@ to bcc]
>
> Hello,
>
> Setting up a query has some overhead (in query planning). I expect it
> to be in the 100 ms range, multiplying that by 2k adds up to the time
> you report.
> Inserting all the values through one query would help.
>
> HTH
>
> On Tue, Aug 22, 2017 at 10:06 AM, sky <x_hsky@163.com> wrote:
>> Hi all,
>>     I do kudu insert sql  through the impala shell, it is very slowly.Approximately
4 minutes two thousand insert sqls. Is there any way to speed up kudu insert speed?
>>     Command:
>>         ./impala-shell.sh -f a.sql
>>     a.sql:
>>         insert into table t1 values("a1","b");
>>         insert into table t1 valuse("a2","b");
>>         ......
>
>
>
> --
> Balázs Jeszenszky
> Customer Operations Engineer
> Email:   balazsj@cloudera.com
> Data:    http://www.cloudera.com

Mime
View raw message