Return-Path: X-Original-To: apmail-kudu-user-archive@minotaur.apache.org Delivered-To: apmail-kudu-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 20FA519E28 for ; Wed, 20 Apr 2016 15:33:00 +0000 (UTC) Received: (qmail 12895 invoked by uid 500); 20 Apr 2016 15:33:00 -0000 Delivered-To: apmail-kudu-user-archive@kudu.apache.org Received: (qmail 12860 invoked by uid 500); 20 Apr 2016 15:33:00 -0000 Mailing-List: contact user-help@kudu.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@kudu.incubator.apache.org Delivered-To: mailing list user@kudu.incubator.apache.org Received: (qmail 12840 invoked by uid 99); 20 Apr 2016 15:33:00 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Apr 2016 15:33:00 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 92AE7C0845 for ; Wed, 20 Apr 2016 15:32:59 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.498 X-Spam-Level: ** X-Spam-Status: No, score=2.498 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, KAM_LINEPADDING=1.2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=cloudera-com.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id AXoje22Szpcb for ; Wed, 20 Apr 2016 15:32:57 +0000 (UTC) Received: from mail-ob0-f176.google.com (mail-ob0-f176.google.com [209.85.214.176]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 0EF1B5FAE6 for ; Wed, 20 Apr 2016 15:32:57 +0000 (UTC) Received: by mail-ob0-f176.google.com with SMTP id bg3so33822588obb.1 for ; Wed, 20 Apr 2016 08:32:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cloudera-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=KoVlMG87GUA8B0VDc7HKkCxPi3mQTJANlw4MI9ad6Yk=; b=Z3qFvj1rczJZMl9USJeTfD6fSIzCtdeAzg92mrpiOv5N7JSbaXtNMVN54SlLoH32Xl oA6t+TJ6nOyEYan7PYqAK5cnJgHWqS8eQqK3wYDfTgF8a1XwsGlKwprjgwZtgJuN8e3x d8IR0hf3lOC70t1G3dg39icX/C/+xNu+X2c68KLbcT2EYzifMUeaStOeeTMYyfaS/rit N8RCqKHUD5BMvaZnGr3sNGDqXdto+EElPbIVOaGKOUhcIv4albUYi4ioa4DeL7/0nA48 uQAhB1BX84tbwhw1L86fq8o4XxZIc1+zN8QQL/beXWyzuYgQrRKoO9zbRMyHmnDuS9LX fEEA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=KoVlMG87GUA8B0VDc7HKkCxPi3mQTJANlw4MI9ad6Yk=; b=LSs2KCnSNIQVHg/DLURpgApDgxHETYxpYWehwOXQMcI+ZZMEfdG1GmzlGsYHwEEveR ZBYVZV7BtqVf9jssunfJ5CRsuc94gC8EXwAeI2BxEWqFAzjbFfK/cEYQi7FLyH1nFoOD AOrsKM00dYv288ERVJFxWfHM7J2y6yB4wK1iPrOosthDxYhXQEZy42tCTkx+/4eAVcRZ vxPS/ime0FBpthuYvXzTc/WvoTet6wmAkoJiJ3ZuCbouh5+8i1FpjA/Tf6ZbdtgFbrMy PeEdrx4olzvJ/PAp5D4SBj2aoOtcsWYc5zjCPnzxH48j5JHpYXkwGfePAL7lee6tJtMQ lXfw== X-Gm-Message-State: AOPr4FXziHHOpgP4Uykq5HkMAaIOsxE24yKAryMwUs/pZ/h6BjjSp4axI8sRsnxPPqwNeQozyx77ZyXGmqGHQQXB X-Received: by 10.182.24.8 with SMTP id q8mr4025414obf.67.1461166376294; Wed, 20 Apr 2016 08:32:56 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.14.115 with HTTP; Wed, 20 Apr 2016 08:32:36 -0700 (PDT) In-Reply-To: References: From: Misty Stanley-Jones Date: Wed, 20 Apr 2016 08:32:36 -0700 Message-ID: Subject: Re: kudu question To: user@kudu.incubator.apache.org Cc: =?UTF-8?B?5p2O5Lmm5piO?= <18769721812@163.com> Content-Type: multipart/alternative; boundary=001a11c24b38d138780530ec4e47 --001a11c24b38d138780530ec4e47 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You might find this link (and the following few sections) more helpful if you aren't using Cloudera Manager: http://getkudu.io/docs/kudu_impala_integration.html#_internal_and_external_= impala_tables Thanks, Misty On Tue, Apr 19, 2016 at 11:54 PM, Casey Ching wrote: > Hello, answers below > > > On April 19, 2016 at 11:40:26 PM, =E6=9D=8E=E4=B9=A6=E6=98=8E (1876972181= 2@163.com) wrote: > > Error while flushing kudu session: > Already present:entry already present in memrowset > > when I insert into a kudu table. > > I create table from impala-shell=EF=BC=8Cbut result display a EXTERNALtab= le=E3=80=82The > kudu data is not delete when I drop table from impala-shell=E3=80=82 > How can I create a internal table from impala-shell=EF=BC=9F > > The syntax is > > CREATE TABLE (id INT, ...) TBLPROPERTIES( > 'storage_handler' =3D 'com.cloudera.kudu.hive.KuduStorageHandler', > 'kudu.table_name' =3D =E2=80=98', > 'kudu.master_addresses' =3D =E2=80=98[:]', 'kudu.key_columns'= =3D 'id' ) > > More information is at > http://www.cloudera.com/documentation/betas/kudu/latest/topics/kudu_impal= a.html#concept_ykj_tnk_ft > > > How can I delete kudu data use kudu command=EF=BC=9F > > Kudu provides a command line utility =E2=80=9Ckudu-admin=E2=80=9D that al= lows for deleting > tables. > > $ kudu-admin delete_table > > > Thanks! > > > > > > > > > --001a11c24b38d138780530ec4e47 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You might find this link (and the following few sections) = more helpful if you aren't using Cloudera Manager:=C2=A0http://getkudu.io/docs/kudu_impala_integration.html#_internal_an= d_external_impala_tables

Thanks,
Misty

On Tue, A= pr 19, 2016 at 11:54 PM, Casey Ching <casey@cloudera.com> w= rote:
Hello, answers below


On April 19, 2016 at 11:40:26 PM, =E6=9D=8E=E4= =B9=A6=E6=98=8E (1= 8769721812@163.com) wrote:

Error while flushing kudu session:
Alread= y present:entry already present in memrowset

when I insert into a ku= du table.

I create table from impala-shell=EF=BC=8C= but result display a=C2=A0EXTERNALtable=E3=80=82The kudu= data is not delete when I drop table from impala-shell=E3=80=82
How can= I create a internal table from impala-shell=EF=BC=9F

The syntax is

CREATE TABLE <impala table name> (id INT, ...) TBLPROPERTIES( 'storage_handler' =3D 'com.cloudera.kudu.hive.KuduStorageHandle= r', 'kudu.table_name' =3D =E2=80=98<kudu table name (can be the same= as impala)>', 'kudu.master_addresses' =3D =E2=80=98<host>[:<port>]= 9;, 'kudu.key_columns' =3D 'id' )

More information is at=C2=A0http://www.cloudera.com/documentation/betas/kudu/lat= est/topics/kudu_impala.html#concept_ykj_tnk_ft


How can I = delete kudu data use kudu command=EF=BC=9F

Kudu provides a command line utility =E2= =80=9Ckudu-admin=E2=80=9D that allows for deleting tables.

$ kudu-adm= in delete_table <table name>


Thanks!


=C2=A0




=C2=A0


--001a11c24b38d138780530ec4e47--