Re: Unable to issue count(*) query versus movielens data

2012-12-16 Thread Mark Grover
Sekine, You may want to go to the jobtracker web interface and look at the failed task logs for more info. Mark On Sun, Dec 16, 2012 at 1:36 PM, Sékine Coulibaly wrote: > Hi there, > > I loaded data from the movielens database into hive, into a u_data table. I > wish I could count the total numb

Unable to issue count(*) query versus movielens data

2012-12-16 Thread Sékine Coulibaly
Hi there, I loaded data from the movielens database into hive, into a u_data table. I wish I could count the total number of rows in that table. Although mapreduce task starts, it ends with a Null Pointer Exception. I must admit I don't know what to do next, how to investigate this issue. The sta

Re: HiveHistory and HiveHistoryViewer

2012-12-16 Thread Qiang Wang
glad to receive your reply! here is my point: Firstly, I think HiveHistoryViewer is inconsistent with HiveHistory. Secondly, hive server may be deloyed on linux, but client can be anywhere. hql from client will be logged into history file and hql may contails '\r' 2012/12/16 afancy > I don\t t

Re: HiveHistory and HiveHistoryViewer

2012-12-16 Thread afancy
I don\t think it is a bug. If the program in hive writes logs to HiveHistory.log using '\n' to indicate the end of a line. Then, it is OK to use *val = val.replace('\n', ' ');. Anyway, ** new line depends what on your OS: Hive is typically deployed