Re:Re: KUDU INSERT SLOWLY

[sky]

Thank you for your method.
Is there any other way to quickly load text files into kudu table ?








At 2017-08-22 16:12:47, "Balázs Jeszenszky" <bala...@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_h...@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:   bala...@cloudera.com
>Data:http://www.cloudera.com

KUDU INSERT SLOWLY

[sky]

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");
..

Re:Re: KUDU Space is not Released

[sky]

No,it is a internal table, comand is "create table .. stored as kudu"








At 2017-08-15 23:33:55, "Matthew Jacobs" <m...@cloudera.com> wrote:
>Was it an external table?
>
>On Tue, Aug 15, 2017 at 1:29 AM sky <x_h...@163.com> wrote:
>
>> Hi all,
>> When deleted the kudu table via impala-shell, I find that the local
>> disk space is not released. How do I free up the space?
>
>-- 
>Sent from my iPhone

KUDU Space is not Released

[sky]

Hi all,
When deleted the kudu table via impala-shell, I find that the local disk 
space is not released. How do I free up the space?

Kudu Scanner not Found

[sky]

Hi all,
Using command “create table  . stored as kudu select  from table” 
to create kudu table , I get the errors:
Query progress can be monitored at: 
http://node.sky.org:25000/query_plan?query_id=b243c1b8987db9dd
:b520b3be
WARNINGS: 
Unable to advance iterator: Timed out: Scan RPC to 192.168.1.27:7065 timed out 
after 0.000s (SENT)
: Not found: Scanner not found
Unable to advance iterator: Timed out: Scan RPC to 192.168.1.27:7065 timed out 
after 0.000s (SENT)
: Not found: Scanner not found


How to do it ?

Excessive use of CPU

[sky]

Hi all,
I found kudu has been using CPU 20% or so, but I did not do SQL operation. 
What are the other built-in operations in kudu ?