Re: LOAD HDFS into Hive

2013-01-25 Thread venkatramanan
hi Bejoy KS, This is working perfectly... thanks On Friday 25 January 2013 06:43 PM, venkatramanan wrote: thanks for your reply i will try and get back to you thanks, Venkat On Friday

Re: LOAD HDFS into Hive

2013-01-25 Thread venkatramanan
operation here. Regards Bejoy KS Sent from remote device, Please excuse typos *From: * venkatramanan *Date: *Fri, 25 Jan 2013 18:30:29 +0530 *To: * *ReplyTo: * user@hive.apache.org *Subject: *LOAD HDFS into Hive Hi, I need to

LOAD HDFS into Hive

2013-01-25 Thread venkatramanan
Hi, I need to load the hdfs data into the Hive table. For example, Am having the twitter data and its updated daily using the streaming API. These twitter responses are stored into the HDFS Path named like ('TwitterData'). After that i try to load the data into the Hive. using the 'LOAD DATA

Re: Configure Hive in Cluster

2013-01-22 Thread venkatramanan
t 12:57 PM, venkatramanan mailto:venkatraman...@smartek21.com>> wrote: Hi, I got the following error while executing the "select count(1) from tweettrend;" Below are the exact log msg from the jobtracker Web Interface *Hive Cli Error:* Exce

Fwd: Re: Configure Hive in Cluster

2013-01-22 Thread venkatramanan
17 Jan 2013 17:23:03 +0530 From: venkatramanan Reply-To: To: Can you suggest me the mandatory hive parameters and clustering configuration steps On Thursday 17 January 2013 12:56 PM, Nitin Pawar wrote: looks like a very small cluster with very limited memory to run mapreduce

Re: Configure Hive in Cluster

2013-01-17 Thread venkatramanan
map is running. but still 15 min is a lot of time for 600MB memory On Thu, Jan 17, 2013 at 12:47 PM, venkatramanan mailto:venkatraman...@smartek21.com>> wrote: Below details are the cluster configuration Configured Capacity : 82.8 GB DF

Re: Configure Hive in Cluster

2013-01-16 Thread venkatramanan
ny mapreduce job so its just taking time to show data on your screen if you are using that query On Thu, Jan 17, 2013 at 12:24 PM, venkatramanan mailto:venkatraman...@smartek21.com>> wrote: I didnt set any hive parameters and my total table size is 610 MB only On Thursday 17

Re: Configure Hive in Cluster

2013-01-16 Thread venkatramanan
I didnt set any hive parameters and my total table size is 610 MB only On Thursday 17 January 2013 12:11 PM, Nitin Pawar wrote: a bit more details on size of table and select query will help also did you set any hive parameters ? On Thu, Jan 17, 2013 at 12:12 PM, venkatramanan

Configure Hive in Cluster

2013-01-16 Thread venkatramanan
Hi All, Am Newbie in apache hive. I have create a table and thats points to the HDFS Folder path and its takes 15 min to execute the simple "*select*" stmt, Can anyone suggest me for a best practices and performance improvement on hive. Thanks in Advance Venkat