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 46F54EA75 for ; Wed, 16 Jan 2013 13:45:34 +0000 (UTC) Received: (qmail 59133 invoked by uid 500); 16 Jan 2013 13:45:29 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 58615 invoked by uid 500); 16 Jan 2013 13:45:26 -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 58583 invoked by uid 99); 16 Jan 2013 13:45:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jan 2013 13:45:25 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=FREEMAIL_REPLY,HTML_MESSAGE,MIME_QP_LONG_LINE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of yuzhihong@gmail.com designates 209.85.220.46 as permitted sender) Received: from [209.85.220.46] (HELO mail-pa0-f46.google.com) (209.85.220.46) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jan 2013 13:45:20 +0000 Received: by mail-pa0-f46.google.com with SMTP id bh2so791353pad.5 for ; Wed, 16 Jan 2013 05:45:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:references:mime-version:in-reply-to:content-type :content-transfer-encoding:message-id:cc:x-mailer:from:subject:date :to; bh=sByRA+HreNiijJ1FJ5yn0Fdseluw9jj08Jhemeu5Ekc=; b=gEnrfvxURou49KdNURTcWrVIRzOcWHKIv5wPo1BnvzTufnR8DmI8l0Ne0fH5f5LWdk upVnApv3OFUDCwte80MR9niqRHX8kgZiDzQpOn8qzLqddfb/JP2CGNzoqLKN4EGICx4B Qqib9jjckm/BRbCOmV6RVyAtE+LGaBuEGcrwNxvPi6wEoMZI7T/aq4AXBBrt5moo9Ux0 Fw92qHhunHNkb5pVZGI/BxEqBMYRUUZvakpZ0DpRIQyuoQ/CtgZLz7pQuYPGlq6d9KH5 bOim3GDa8ag5dBYlN5ifd6WQ+Z3rDK05NsJag6mIiy2bWHeBb1pnEOAgJJqcTY6rcfBU uDww== X-Received: by 10.68.216.134 with SMTP id oq6mr2692176pbc.162.1358343900101; Wed, 16 Jan 2013 05:45:00 -0800 (PST) Received: from [192.168.0.21] (c-24-130-233-55.hsd1.ca.comcast.net. [24.130.233.55]) by mx.google.com with ESMTPS id a4sm13020053pax.25.2013.01.16.05.44.57 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Wed, 16 Jan 2013 05:44:59 -0800 (PST) References: <0CE69E9126D0344088798A3B7F7F80863AEBB6D5@SZXEML553-MBX.china.huawei.com> Mime-Version: 1.0 (1.0) In-Reply-To: Content-Type: multipart/alternative; boundary=Apple-Mail-C8F70867-D515-43FC-AEFC-EE859DE6C509 Content-Transfer-Encoding: 7bit Message-Id: <9699B523-D794-4E9E-9F20-C441F81DF17F@gmail.com> Cc: "user@hbase.apache.org" X-Mailer: iPhone Mail (10A525) From: Ted Subject: Re: Hbase as mongodb Date: Wed, 16 Jan 2013 05:44:54 -0800 To: "user@hbase.apache.org" X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-C8F70867-D515-43FC-AEFC-EE859DE6C509 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Project Panthera seems to serve your use case well.=20 You can refer to http://mail-archives.apache.org/mod_mbox/hadoop-common-user= /201209.mbox/%3C521452FCF7ACDE4795C7E150D240AFCA0FDE1395@SHSMSX102.ccr.corp.= intel.com%3E On Jan 16, 2013, at 5:38 AM, Mohammad Tariq wrote: > @Anoop sir : Does it make sense to extract the timestamp of JSON > object beforehand and use it as the rowkey? After that serialize the > JSON object and store it in the Hbase cell. Gets would a lot faster > then??? >=20 > Warm Regards, > Tariq > https://mtariq.jux.com/ > cloudfront.blogspot.com >=20 >=20 > On Wed, Jan 16, 2013 at 7:02 PM, Imran M Yousuf wrote= : >=20 >> We have used Jackson library for converting Java Object to JSON String >> and eventually to byte[] and vice-versa; but that is not scan/query >> friendly, so we integrated Apache Solr to the stack to get that done. >> http://smart-cms.org >>=20 >> Thank you, >>=20 >> Imran >>=20 >> On Wed, Jan 16, 2013 at 7:27 PM, Anoop Sam John >> wrote: >>>> Such as I can directly say Mongodb to get me >>> all the objects having timestamp value of xxx date where timestamp is a >>> field in Json objects stored in Mongodb >>>=20 >>> It is possible to store any data in HBase which can be converted into >> byte[]. Yes using filters one can perform above kind of query. There is n= o >> built in filter for above kind of need but custom one can be created. Bu= t >> remember that there is no built in secondary indexing capability in HBase= . >> Here by I can see you have a need for indexing a part of column value. >> [timestamp is a field in Json objects ] >>>=20 >>> -Anoop- >>> ________________________________________ >>> From: Panshul Whisper [ouchwhisper@gmail.com] >>> Sent: Wednesday, January 16, 2013 6:36 PM >>> To: user@hbase.apache.org >>> Subject: Re: Hbase as mongodb >>>=20 >>> Hello Tariq, >>>=20 >>> Thank you for the reply. >>>=20 >>> My concern is that I have been working with MongoDB, but now I am >> switching >>> over to Hadoop and I want to use HBase for certain reasons. I was >> wondering >>> if I can store Json files in Hbase in a way that I can query the Json >> files >>> in Hbase as I can in Mongodb. Such as I can directly say Mongodb to get >> me >>> all the objects having timestamp value of xxx date where timestamp is a >>> field in Json objects stored in Mongodb. Can I perform similar operation= s >>> on Hbase or does it have another approach for doing similar operations. >>> I do not have much knowledge on Hbase yet. I am beginning to learn it, >> but >>> I just want to be sure i am investing my time in the right direction. >>>=20 >>> Thank you so much for the help, >>>=20 >>> Regards, >>> Panshul. >>>=20 >>>=20 >>> On Wed, Jan 16, 2013 at 11:45 AM, Mohammad Tariq >> wrote: >>>=20 >>>> Hello Panshul, >>>>=20 >>>> Hbase and MongoDB are built to serve different purposes. You >> can't >>>> replace one with the other. They have different strengths and >> weaknesses. >>>> So, if you are using Hbase for something, think well before switching t= o >>>> MongoDB or vice verca. >>>>=20 >>>> Coming back to the actual question, you can store anything which can be= >>>> converted into a sequence of bytes into Hbase and query it. Could you >>>> please elaborate your problem a bit?It will help us to answer your >> question >>>> in a better manner. >>>>=20 >>>> Warm Regards, >>>> Tariq >>>> https://mtariq.jux.com/ >>>> cloudfront.blogspot.com >>>>=20 >>>>=20 >>>> On Wed, Jan 16, 2013 at 4:03 PM, Panshul Whisper >>>> wrote: >>>>=20 >>>>> Hello, >>>>>=20 >>>>> Is it possible to use hbase to query json documents in a same way as >> we >>>> can >>>>> do with Mongodb >>>>>=20 >>>>> Suggestions please. >>>>> If we can then a small example as how.. not the query but the process >>>>> flow.. >>>>> Thanku so much >>>>> Regards, >>>>> Panshul. >>>=20 >>>=20 >>>=20 >>> -- >>> Regards, >>> Ouch Whisper >>> 010101010101 >>=20 >>=20 >>=20 >> -- >> Imran M Yousuf >> Entrepreneur & CEO >> Smart IT Engineering Ltd. >> Dhaka, Bangladesh >> Twitter: @imyousuf - http://twitter.com/imyousuf >> Blog: http://imyousuf-tech.blogs.smartitengineering.com/ >> Mobile: +880-1711402557 >> +880-1746119494 >>=20 --Apple-Mail-C8F70867-D515-43FC-AEFC-EE859DE6C509--