Re: which approach is better

2013-07-18 Thread Bennie Schut
The best way to restore is from a backup. We use distcp to keep this scalable : http://hadoop.apache.org/docs/r1.2.0/distcp2.html The data we feed to hdfs also gets pushed to this backup and the metadatabase from hive also gets pushed here. So this combination works well for us (had to use it

Re: Hive does not package a custom inputformat in the MR job jar when the custom inputformat class is add as aux jar.

2013-07-18 Thread Matouk IFTISSEN
that is what I search for a long time, and no responses. But if you are not in the cloud (AWS, Azure,...) you can add the jar for your all Datanodes in $HADOOP_HOME/lib , and then restart the service mapreduce-tasktracker like this /etc/init.d/*mapreduce-tasktracker stop

Hive - Alter column datatype

2013-07-18 Thread Manickam P
Hi experts, I have created a table in hive and loaded the data into it. now i want to change the datatype of one particular column. Do i need to drop and move the file again to hive?will it work fine if i just alter the data type alone in hive? Thanks,Manickam P

unsubscribe

2013-07-18 Thread Beau Rothrock

Re: unsubscribe

2013-07-18 Thread Ted Yu
You have to send a mail to user-unsubscr...@hive.apache.org On Thu, Jul 18, 2013 at 1:30 PM, Beau Rothrock beau.rothr...@lookout.comwrote:

Re: Hive Architecture - Execution on nodes

2013-07-18 Thread Alan Gates
On Jul 18, 2013, at 1:40 PM, Tzur Turkenitz wrote: Hello, Just finished reading the Hive-Architecture pdf, and failed to find the answers I was hoping for. So here I am, hoping this community will shed some light. I think I know what the answers will be, I need that bolted down and

hive query is very slow,why?

2013-07-18 Thread ch huang
i wait long time,no result ,why hive is so slow? hive select cookie,url,ip,source,vsid,token,residence,edate from hb_cookie_history where edate='1371398400500' and edate='1371400200500'; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks is set to 0 since there's no reduce

Re: hive query is very slow,why?

2013-07-18 Thread Stephen Boesch
one mapper. how big is the table? 2013/7/18 ch huang justlo...@gmail.com i wait long time,no result ,why hive is so slow? hive select cookie,url,ip,source,vsid,token,residence,edate from hb_cookie_history where edate='1371398400500' and edate='1371400200500'; Total MapReduce jobs = 1

can partition and bucket used on external table?

2013-07-18 Thread ch huang
ATT