Re: Hive Query on Hbase snapshot error

2015-09-24 Thread Sandeep Nemuri
hbase org.apache.hadoop.hbase.snapshot.SnapshotInfo -snapshot test_snapshot -stats -schema On Thu, Sep 24, 2015 at 3:43 PM, Sandeep Nemuri wrote: > You can check snapshot state if it is healthy or not using below command. > > > On Thu, Sep 24, 2015 at 2:55 PM, 核弹头す <510688..

Re: Hive Query on Hbase snapshot error

2015-09-24 Thread Sandeep Nemuri
/hbase-huser/hbase/.hbase-snapshot/goods_v3_hbase_snap0/.snapshotinfo > > at > org.apache.hadoop.hbase.snapshot.SnapshotDescriptionUtils.readSnapshotInfo(SnapshotDescriptionUtils.java:307) > > at > org.apache.hadoop.hbase.snapshot.RestoreSnapshotHelper.copySnapshotForScanner(RestoreSnapshotHelper.java:727) > > at > org.apache.hadoop.hbase.mapreduce.TableSnapshotInputFormatImpl.setInput(TableSnapshotInputFormatImpl.java:364) > > at > org.apache.hadoop.hive.hbase.HBaseTableSnapshotInputFormatUtil.configureJob(HBaseTableSnapshotInputFormatUtil.java:77) > > at > org.apache.hadoop.hive.hbase.HBaseStorageHandler.configureTableJobProperties(HBaseStorageHandler.java:387) > > ... 29 more > -- * Regards* * Sandeep Nemuri*

Re: HDFS file system size issue

2014-04-14 Thread Sandeep Nemuri
n its >> receipt. >> >> >> > > _ > The information contained in this communication is intended solely for the > use of the individual or entity to whom it is addressed and others > authorized to receive it. It may contain confidential or legally privileged > information. If you are not the intended recipient you are hereby notified > that any disclosure, copying, distribution or taking any action in reliance > on the contents of this information is strictly prohibited and may be > unlawful. If you have received this communication in error, please notify > us immediately by responding to this email and then delete it from your > system. The firm is neither liable for the proper and complete transmission > of the information contained in this communication nor for any delay in its > receipt. > -- --Regards Sandeep Nemuri

Re: Hive + mongoDB

2013-09-13 Thread Sandeep Nemuri
On Thu, Sep 12, 2013 at 6:23 PM, Nitin Pawar wrote: > try creating table with your existing mongo db and collection see the data > can be read by the user or not. > What you need to do is mongo collection column mapping exactly with same > names into hive column definition. > > if

Re: Hive + mongoDB

2013-09-12 Thread Sandeep Nemuri
; On Thu, Sep 12, 2013 at 5:02 PM, Nitin Pawar wrote: > If you are importing from hive to mongo, why can't you just select from > mongo table and insert into hive table? > > > On Thu, Sep 12, 2013 at 4:24 PM, Sandeep Nemuri wrote: > >> Hi Nitin Pawar, >>

Re: Hive + mongoDB

2013-09-12 Thread Sandeep Nemuri
ive-mongo). > > Its pretty easy to use as well. If you want to start with analytics > directly. > > > On Thu, Sep 12, 2013 at 2:02 PM, Sandeep Nemuri wrote: > >> Thanks all >> i am trying to import data with this program >> but when i compied this code i got er

Re: Hive + mongoDB

2013-09-12 Thread Sandeep Nemuri
se pig mongodb combination to get >> the data from mongodb through pig, then after you can create a table >> in hive that will points to the pig output file on hdfs. >> >> https://github.com/mongodb/mongo-hadoop/blob/master/pig/README.md >> >>

Hive + mongoDB

2013-09-11 Thread Sandeep Nemuri
Hi every one , I am trying to import data from mongodb to hive . i got some jar files to connect mongo and hive . now how to import the data from mongodb to hive ? Thanks in advance. -- --Regards Sandeep Nemuri

Re: joining 2 tables

2013-08-22 Thread Sandeep Nemuri
B: >> >> id2 var3 var4 >> 3 ef >> 4 gh >> >> Expected Output is : >> >> id1 var1 var2 id2 var3 var4 >> 1 ab 3e f >> 2 cd 4g h >> >> >> Thanks in advance. >> -- >> --Regards >> Sandeep Nemuri >> > > -- --Regards Sandeep Nemuri

Re: How to perform arithmetic operations in hive

2013-08-22 Thread Sandeep Nemuri
: Re: How to perform arithmetic operations in hive > > Try > > select emp_name, (emp_no * 10) from emp_table; > > Sent from my iPhone > > On Aug 22, 2013, at 8:14 AM, Sandeep Nemuri wrote: > > Hi all , > Can we perform arithmetic operator on *select

How to perform arithmetic operations in hive

2013-08-22 Thread Sandeep Nemuri
. --Regards Sandeep Nemuri

joining 2 tables

2013-08-21 Thread Sandeep Nemuri
Hi all , I want to join two tables ** I have table_A: id1 var1 var2 1 ab 2 cd Table_B: id2 var3 var4 3 ef 4 gh Expected Output is : id1 var1 var2 id2 var3 var4 1 ab 3e f 2 cd 4g h Thanks in advance. -- --Regards Sandeep Nemuri