RE: Hive HBase integeration use case

2013-02-01 Thread Vivek Mishra
You may want to try by creating UDF/UDTF hive function -Vivek From: G.S.Vijay raajaa [gsvijayraa...@gmail.com] Sent: 01 February 2013 18:55 To: user@hive.apache.org Subject: Hive HBase integeration use case Hi, I would like to have HBase as a data storage

RE: Running commands at hive cli or hive thirft startup

2012-12-14 Thread Vivek Mishra
UDFs are tricky. The only way I can think of is to add them to the function registry (https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java) and recompile Hive. ` What about

RE: Load data in (external table) from symbolic link

2012-12-08 Thread Vivek Mishra
Looks like MapR is complaining for mounted directory and somehow it is not accessible. -Vivek From: Hadoop Inquirer [hadoop.inqui...@gmail.com] Sent: 08 December 2012 04:47 To: user@hive.apache.org Subject: Load data in (external table) from symbolic link Hi, I

RE: handling null argument in custom udf

2012-12-05 Thread Vivek Mishra
Could you please look into and share your task log/attemptlog for complete error trace or actual error behind this? -Vivek From: Søren [s...@syntonetic.com] Sent: 04 December 2012 20:28 To: user@hive.apache.org Subject: Re: handling null argument in

RE: handling null argument in custom udf

2012-12-05 Thread Vivek Mishra
From: Vivek Mishra Sent: 05 December 2012 15:36 To: user@hive.apache.org Subject: RE: handling null argument in custom udf Could you please look into and share your task log/attemptlog for complete error trace or actual error behind this? -Vivek

RE: MapJoin error: .hashtable file not found

2012-11-27 Thread Vivek Mishra
From: Mark Grover [grover.markgro...@gmail.com] Sent: 28 November 2012 11:41 To: user@hive.apache.org Subject: Re: MapJoin error: .hashtable file not found Vivek, What version of Hive are you using? And, on what OS? Mark On Tue, Nov 27, 2012 at 9:34 PM, Vivek Mishra vivek.mis

RE: MapJoin error: .hashtable file not found

2012-11-27 Thread Vivek Mishra
or hive-0.10 branch. Lots of work has gone in since 0.9 to make Hive work better on Windows. Ashutosh On Tue, Nov 27, 2012 at 11:08 PM, Vivek Mishra vivek.mis...@impetus.co.inmailto:vivek.mis...@impetus.co.in wrote: Hi, I am using 0.9.0 hive with Windows 2008 server. I did try debugging

MapJoin error: .hashtable file not found

2012-11-23 Thread Vivek Mishra
Hi, I am trying to run a MapJoin query and somehow getting below error. I can see that file is not there in specified directory. Did some debugging but no luck as well. Here is the error: nOperator:Load back 1 hashtable file from tmp file

RE: hive select count(*) query exception

2011-12-18 Thread Vivek Mishra
select count(*) query exception I am using hadoop-0.20.2-cdh3u1 from Cloudera Jing On Sat, Dec 17, 2011 at 12:18 AM, Vivek Mishra vivek.mis...@impetus.co.inmailto:vivek.mis...@impetus.co.in wrote: Which version of hadoop you re experimenting with? AFAIK, only 0.20.X works fine. i tried versions

RE: Hive server not starting...on EC2 Ubuntu 10.04 instance

2011-12-18 Thread Vivek Mishra
@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# hive --service hiveserver Starting Hive Thrift Server ^Croot@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# -PD On Sun, Dec 18, 2011 at 4:34 AM, Vivek Mishra vivek.mis

RE: hive select count(*) query exception

2011-12-17 Thread Vivek Mishra
Which version of hadoop you re experimenting with? AFAIK, only 0.20.X works fine. i tried versions 0.20.x but no luck. Vivek From: alo alt [wget.n...@googlemail.com] Sent: 16 December 2011 14:59 To: user@hive.apache.org Subject: Re: hive select count(*)

RE: Hive not reflecting hdfs data

2011-03-10 Thread Vivek Mishra
Please check for metastore_db location. That should help Vivek From: abhishek pathak [mailto:forever_yours_a...@yahoo.co.in] Sent: Thursday, March 10, 2011 5:05 PM To: Hive mailing list Subject: Hive not reflecting hdfs data Hi, I am a hive newbie.I am managing a setup where data is regularly

Hive import issue

2010-12-10 Thread Vivek Mishra
Hi, I am a newbie to hive. When I am trying to import data to HBase via a table managed by Hive. I am getting following errors: mismatched input 'Timestamp' expecting Identifier in column specification mismatched input 'data' expecting Identifier in column specification Remvoing or

Running a HiveClient with create external table HBase

2010-12-03 Thread Vivek Mishra
Hi, Currently I am facing random behavior while trying to create a java client for Hive hbase integration. Case: I am trying to create a hive table for existing HBase table. So i have started hiveserver via /hive -service hiveserver. In logs I can see it is printing by my sql with CREATE

RE: Hive/HBase integration issue.

2010-11-24 Thread Vivek Mishra
Added 1 post at: http://mevivs.wordpress.com/2010/11/24/hivehbase-integration/ Sharing it if is useful. Vivek -Original Message- From: Vivek Mishra Sent: Friday, November 19, 2010 10:36 AM To: user@hive.apache.org Subject: RE: Hive/HBase integration issue. Hi, Just found