Return-Path: X-Original-To: apmail-hadoop-common-user-archive@www.apache.org Delivered-To: apmail-hadoop-common-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2A0F817BA4 for ; Wed, 15 Apr 2015 17:29:21 +0000 (UTC) Received: (qmail 64439 invoked by uid 500); 15 Apr 2015 17:29:03 -0000 Delivered-To: apmail-hadoop-common-user-archive@hadoop.apache.org Received: (qmail 64332 invoked by uid 500); 15 Apr 2015 17:29:03 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 64322 invoked by uid 99); 15 Apr 2015 17:29:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Apr 2015 17:29:03 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,HTML_OBFUSCATE_05_10,RCVD_IN_DNSWL_NONE,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of manoj.venkatesh@xoom.com designates 207.46.100.133 as permitted sender) Received: from [207.46.100.133] (HELO na01-by2-obe.outbound.protection.outlook.com) (207.46.100.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Apr 2015 17:28:38 +0000 Received: from DM2PR0201MB1037.namprd02.prod.outlook.com (25.160.219.147) by DM2PR0201MB0912.namprd02.prod.outlook.com (25.160.215.28) with Microsoft SMTP Server (TLS) id 15.1.130.23; Wed, 15 Apr 2015 17:28:20 +0000 Received: from DM2PR0201MB1038.namprd02.prod.outlook.com (25.160.219.148) by DM2PR0201MB1037.namprd02.prod.outlook.com (25.160.219.147) with Microsoft SMTP Server (TLS) id 15.1.136.25; Wed, 15 Apr 2015 17:28:18 +0000 Received: from DM2PR0201MB1038.namprd02.prod.outlook.com ([25.160.219.148]) by DM2PR0201MB1038.namprd02.prod.outlook.com ([25.160.219.148]) with mapi id 15.01.0136.026; Wed, 15 Apr 2015 17:28:18 +0000 From: Manoj Venkatesh To: "user@hadoop.apache.org" Subject: Add keys to column family in HBase using Python Thread-Topic: Add keys to column family in HBase using Python Thread-Index: AQHQd6GPGajauK6blUqWCqJ6szUH4A== Date: Wed, 15 Apr 2015 17:28:18 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: hadoop.apache.org; dkim=none (message not signed) header.d=none; x-ms-exchange-messagesentrepresentingtype: 1 x-originating-ip: [38.99.18.237] x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0201MB1037;UriScan:;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0201MB0912; x-forefront-antispam-report: BMV:1;SFV:NSPM;SFS:(10019020)(16236675004)(15395725005)(110136001)(2501003)(86362001)(2900100001)(92566002)(19617315012)(107886001)(2351001)(99286002)(229853001)(450100001)(36756003)(77156002)(62966003)(66066001)(19580395003)(50986999)(54356999)(106116001)(122556002)(15975445007)(40100003)(2656002)(87936001)(46102003)(102836002);DIR:OUT;SFP:1102;SCL:1;SRVR:DM2PR0201MB1037;H:DM2PR0201MB1038.namprd02.prod.outlook.com;FPR:;SPF:None;MLV:sfv;LANG:en; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(5002010)(5005006);SRVR:DM2PR0201MB1037;BCL:0;PCL:0;RULEID:;SRVR:DM2PR0201MB1037; x-forefront-prvs: 0547116B72 Content-Type: multipart/alternative; boundary="_000_D153EDBF7E98manojvenkateshxoomcom_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Apr 2015 17:28:18.1926 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6700918f-d5e0-40b1-b54f-6336bb2e48bf X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM2PR0201MB1037 X-OriginatorOrg: xoom.com X-Virus-Checked: Checked by ClamAV on apache.org --_000_D153EDBF7E98manojvenkateshxoomcom_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Hadoop experts, I have a Hadoop cluster which has Hive, HBase installed along with other Ha= doop components. I am currently exploring ways to automate a data migratio= n process from Hive to HBase which involves new columns of data added ever = so often. I was successful in creating a HBase table using Hive and load d= ata into the HBase table, on these lines I tried to add columns to the HBas= e table(from Hive) using the alter table syntax and I got the error message= , "ALTER TABLE cannot be used for a non-native table temp_testing". As an alternative to this I am also trying to do this programmatically usin= g Python, I have explored the libraries HappyBase and starbase. These libraries provide functionality for creating, deleting and othe= r features but none of these provide an option to add a key to a column fam= ily. Does anybody know of a better way of achieving this with Python, say l= ibraries or through other means. Thanks in advance, Manoj The information transmitted in this email is intended only for the person o= r entity to which it is addressed, and may contain material confidential to= Xoom Corporation, and/or its subsidiary, buyindiaonline.com Inc. Any revie= w, retransmission, dissemination or other use of, or taking of any action i= n reliance upon, this information by persons or entities other than the int= ended recipient(s) is prohibited. If you received this email in error, plea= se contact the sender and delete the material from your files. --_000_D153EDBF7E98manojvenkateshxoomcom_ Content-Type: text/html; charset="iso-8859-1" Content-ID: Content-Transfer-Encoding: quoted-printable
Dear Hadoop experts,

I have a Hadoop cluster which has Hive, HBase installed alon= g with other Hadoop components.  I am currently exploring ways to auto= mate a data migration process from Hive to HBase which involves new columns= of data added ever so often.  I was successful in creating a HBase table using Hive and load data into the HBas= e table, on these lines I tried to add columns to the HBase table(from Hive= ) using the alter table syntax and I got the error message, “ALTER TABLE cannot be used for a non-native table temp_testing”. 

As an alternative to this I am also trying to do this programmatically= using Python, I have explored the libraries HappyBas= e and starbase. These librarie= s provide functionality for creating, deleting and other features but none = of these provide an option to add a key to a column family. Does anybody kn= ow of a better way of achieving this with Python, say libraries or through other means. 

Thanks in advance,
Manoj

= The information transmitted in this email is intended only for the person o= r entity to which it is addressed, and may contain material confidential to= Xoom Corporation, and/or its subsidiary, buyindiaonline.com Inc. Any review, retransmission, dissemination or other= use of, or taking of any action in reliance upon, this information by pers= ons or entities other than the intended recipient(s) is prohibited. If you = received this email in error, please contact the sender and delete the material from your files.

--_000_D153EDBF7E98manojvenkateshxoomcom_--