about User scripte in HiveQL

2011-02-28 Thread Jianhua Wang
Hi all, Recently, i have met a problem, and i can not solve it after some efforts. So I wanna look for help here, and any help will be appreciated. Thanks! My case is depicted as below: I want to execute the HiveQL command : select transform(a.col) using

Re: about User scripte in HiveQL

2011-02-28 Thread Roberto Congiu
You have to add the file to the query like in the example http://wiki.apache.org/hadoop/Hive/GettingStarted look at the part in red. CREATE TABLE u_data_new ( userid INT, movieid INT, rating INT, weekday INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'; add FILE weekday_mapper.py;