Re: Hbase Timestamp Queries

2015-06-10 Thread Krishna Kalyan
? I can't find it in 0.98 or hbase-1 branches. Cheers On Tue, Jun 9, 2015 at 3:51 AM, Krishna Kalyan krishnakaly...@gmail.com wrote: Yes you can. Have a look at the HBaseStorage class. On 9 Jun 2015 1:04 pm, Talat Uyarer ta...@uyarer.com wrote: Hi, Can I use HBase's

Re: Hbase Timestamp Queries

2015-06-09 Thread Krishna Kalyan
Yes you can. Have a look at the HBaseStorage class. On 9 Jun 2015 1:04 pm, Talat Uyarer ta...@uyarer.com wrote: Hi, Can I use HBase's timestamps to gettting rows greater/smaller than this timestamp . Is it possible ? Thanks -- Talat UYARER Websitesi: http://talat.uyarer.com Twitter:

Re: Questions related to HBase general use

2015-05-13 Thread Krishna Kalyan
I know that BigInsights comes with BigSQL which interacts with HBase as well, have you considered that option. We have a similar use case using BigInsights 2.1.2. On Thu, May 14, 2015 at 4:56 AM, Nick Dimiduk ndimi...@gmail.com wrote: + Swarnim, who's expert on HBase/Hive integration. Yes,

Incorrect Dump using HBase Storage Class

2014-12-28 Thread Krishna Kalyan
Hi, Happy holidays :). I have 2 different pig scripts with the statement below (1) GeoRef_IP = LOAD '$TBL_GEOGRAPHY' USING org.apache.pig.backend.hadoop.hbase.HBaseStorage('cf_data:cq_geog_id cf_data:cq_pc_sector cf_data:cq_district_code cf_data:cq_postal_town cf_data:cq_postal_county

Re: Unable to fetch data from HBase.

2014-11-27 Thread Krishna Kalyan
Restart your zookeeper. Restart your HBase. This might be a short term fix. Thanks, Krishna On Thu, Nov 27, 2014 at 7:57 PM, dhamodharan.ramalin...@tcs.com wrote: Hi, The issue reported earlier is resolved, I now have a new issue. When I execute list command from the hbase shell, I am

Version in HBase

2014-11-11 Thread Krishna Kalyan
Hi, Is it possible to do a select * from table_name where version = somedate ; using HBase APIs?. (Scanning for values where version = somedate ) Could you please direct me to appropriate links to achieve this?. Regards, Krishna

Re: Version in HBase

2014-11-11 Thread Krishna Kalyan
based scans?. Thanks and Regards, Krishna On Wed, Nov 12, 2014 at 10:56 AM, Krishna Kalyan krishnakaly...@gmail.com wrote: Hi, Is it possible to do a select * from table_name where version = somedate ; using HBase APIs?. (Scanning for values where version = somedate ) Could you please

Re: how to design hbase schema?

2014-11-02 Thread Krishna Kalyan
Some Resources http://hbase.apache.org/book/schema.casestudies.html http://www.slideshare.net/cloudera/5-h-base-schemahbasecon2012 http://www.evanconkle.com/2011/11/hbase-tutorial-creating-table/ http://www.slideshare.net/hmisty/20090713-hbase-schema-design-case-studies On Sun, Nov 2, 2014 at

Duplicate Value Inserts in HBase

2014-10-21 Thread Krishna Kalyan
Hi, I have a HBase table which is populated from pig using PigStorage. While inserting, suppose for rowkey i have a duplicate value. Is there a way to prevent an update?. I want to maintain the version history for my values which are unique. Regards, Krishna

Re: Duplicate Value Inserts in HBase

2014-10-21 Thread Krishna Kalyan
...@spaggiari.org wrote: Hi Krishna, HBase will store them in the same row, same cell but you will have 2 versions. If you want to keep just one, setup the version=1 on the table side and only one will be stored. Is that what yo mean? JM 2014-10-21 8:29 GMT-04:00 Krishna Kalyan krishnakaly...@gmail.com

Re: Duplicate Value Inserts in HBase

2014-10-21 Thread Krishna Kalyan
Spaggiari jean-m...@spaggiari.org Date:10/21/2014 9:02 AM (GMT-05:00) To: user user@hbase.apache.org Cc: Subject: Re: Duplicate Value Inserts in HBase You can do check and puts to validate if value is already there, but it's slower... 2014-10-21 8:50 GMT-04:00 Krishna Kalyan krishnakaly

Re: Pig HBase integration

2014-09-29 Thread Krishna Kalyan
directly in join. 2014-09-28 17:02 GMT+04:00 Krishna Kalyan krishnakaly...@gmail.com: We actually have 2 data sets in HDFS, location (3-5 GB, approx 10 columns in each record) and weblog (2-3 TB, approx 50 columns in each record). We need to join the data sets using the locationId, which

Re: Pig HBase integration

2014-09-28 Thread Krishna Kalyan
general recommendation. I have no idea about your task details 2014-09-27 7:32 GMT+04:00 Krishna Kalyan krishnakaly...@gmail.com: Hi, We have a use case that involves ETL on data coming from several different sources using pig. We plan to store the final output table in HBase. What

Re: Pig HBase integration

2014-09-28 Thread Krishna Kalyan
500.000.000 records to 10-nodes hbase with presplitted table. 2014-09-28 16:04 GMT+04:00 Krishna Kalyan krishnakaly...@gmail.com: Thanks Serega, Our usecase details: We have a location table which will be stored in HBase with locationID as the rowkey / Joinkey. We intend to join this table

Pig HBase integration

2014-09-26 Thread Krishna Kalyan
Hi, We have a use case that involves ETL on data coming from several different sources using pig. We plan to store the final output table in HBase. What will be the performance impact if we do a join with an external CSV table using pig?. Regards, Krishna