Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-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 0D64518701 for ; Mon, 14 Dec 2015 10:00:21 +0000 (UTC) Received: (qmail 86457 invoked by uid 500); 14 Dec 2015 10:00:19 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 86390 invoked by uid 500); 14 Dec 2015 10:00:19 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 86372 invoked by uid 99); 14 Dec 2015 10:00:18 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Dec 2015 10:00:18 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5DC0A180461 for ; Mon, 14 Dec 2015 10:00:18 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 6.1 X-Spam-Level: ****** X-Spam-Status: No, score=6.1 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=3, URIBL_BLOCKED=0.001, URI_OBFU_WWW=3.099] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=spaggiari-org.20150623.gappssmtp.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id AY3UK-2bc_Qn for ; Mon, 14 Dec 2015 10:00:05 +0000 (UTC) Received: from mail-qk0-f179.google.com (mail-qk0-f179.google.com [209.85.220.179]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id DEF2925B5B for ; Mon, 14 Dec 2015 10:00:04 +0000 (UTC) Received: by qkfb125 with SMTP id b125so126666538qkf.2 for ; Mon, 14 Dec 2015 01:59:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=spaggiari-org.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=O5KVJUeLkMVj7ha4hCcGuVfyFqGj7oqevnXre6jNptg=; b=mr/Ma5FBhr+QnU5ec9eFuODwouX9MsOsJAv40ZpAIPTZArqD2SGqZWDFagcsVIgyNT KkIqlcEzKICi+m4vLrVworII4KfvfhGVI5ZsOsPRM+qBlWjbLwlbswXi22ylAhzD40MK Jq21P7a+1AvjBTxG4u4apio4cu6U4wyXBZ+kJXbJ5oupyqSzneN9pk6Wj7Joqc6UM46Z dMH8gNd5RL94O6OLomNHGo0KkKBtNUZM8UETD8hkxM2MP65MFyQt4T8UalpP1AEhXmIn Fv+QHouSyek22yKYnmSvCVHjjx8JDha/iwHj+M9psor1J+kpu2IcIAvIEuQ4QDMKan5V veow== 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:content-type; bh=O5KVJUeLkMVj7ha4hCcGuVfyFqGj7oqevnXre6jNptg=; b=Eyr4dB/A8lgwOpnP9TiaOBG1ZNwzgkAmGVZB5wLDnT+IKJnSSDZue721+/LHRVC8yB 2coIFx+RVRTCl7I6eXZ1cdhOWlG9WEPglAcVSD2kIJsE+2lAqpNrrgS4V2b3356xdSqW fl0JL4mpSpH7i2cq9XEM37DFjVuJJCpORjHMAtXF1khwgU1SHjhfLPZsqpWFzCEju2FC wBL9UTwmc95Gifz6Qqe1++jYaJnw6jVEbyd0AQTKhRZ9E8GF8pBvQQkFvCgvb0xXoxDn ZCA/zh58+1lipahI84gUlRN+JPGw8U51xDBSIhpdJrc7/Mc6axwh9zi2OpJz81a1DLhH 3j/Q== X-Gm-Message-State: ALoCoQlLKMEXmxiLh8W0n6KBKuL2LsZGDNHI/5JAGLKJ0r0jR0FvN2OX21y0wZhxLT3sEMdDqGdaVoUVqhGPdoR5bG28EZj7CA== X-Received: by 10.140.232.4 with SMTP id d4mr1011089qhc.27.1450087198288; Mon, 14 Dec 2015 01:59:58 -0800 (PST) MIME-Version: 1.0 Received: by 10.140.27.131 with HTTP; Mon, 14 Dec 2015 01:59:38 -0800 (PST) In-Reply-To: References: From: Jean-Marc Spaggiari Date: Mon, 14 Dec 2015 04:59:38 -0500 Message-ID: Subject: Re: Flat-wide table Hbase To: user Content-Type: multipart/alternative; boundary=001a1135529459104b0526d8bc87 --001a1135529459104b0526d8bc87 Content-Type: text/plain; charset=UTF-8 Hi, HBase is a key value sotre. So what you are pushing here will be stored as: 1002 | xxx | www.sample.com | xx:xx:xx 1003 | yyy | www.url,com | xx:xx:yy 1002 | xxx | url.com | yy:yy:yy 1002 | xxx | urrl2.com | zz:zz:zz HOWEVER.... HBase will never split a region withing a key and keys are always ordered. So at the end, what you will have exactly is: -------------------------------------------------------------- 1002 | xxx | url.com | yy:yy:yy 1002 | xxx | urrl2.com | zz:zz:zz 1002 | xxx | www.sample.com | xx:xx:xx -------------------------------------------------------------- 1003 | yyy | www.url,com | xx:xx:yy -------------------------------------------------------------- The only places where HBase will splis are marked with "-----" This is if 1002-xxx is your key and "url.com" is your column qualifier. HTH JMS 2015-12-14 3:39 GMT-05:00 Rajeshkumar J : > Hi, > > I am going to use flat-wide tables in Hbase for my usecase and I have > some doubts regarding this. > > 1. As per my knowledge flat-wide stores one column value as key and > others as its values in a key-value pair relationship ( correct me if I am > wrong). > > I am having row as follows > > id | name | url | time > > 1002 | xxx | www.sample.com | xx:xx:xx > 1003 | yyy | www.url,com | xx:xx:yy > 1002 | xxx | url.com | yy:yy:yy > 1002 | xxx | urrl2.com | zz:zz:zz > > > > I need to store it in flat-wide table as follows > > 1002 | xxx | www.sample.com | xx:xx:xx | 1002 | xxx | url.com | yy:yy:yy > | > 1002 | xxx | urrl2.com | zz:zz:zz > 1003 | yyy | www.url,com | xx:xx:yy > > How to store it like this? > Can any on help me in this? > --001a1135529459104b0526d8bc87--