Hello, I am new to hive. I want to write block of queries in Hive so that one query give result to another one like in SQL.
I have also visited one link given below: http://karmasphere.com/ksc/hive-user-defined-functions.html In above link I am looking for functions but I get below one and I dont understand following things: USING 'map_script'USING 'reduce_script' in following block: FROM ( FROM pv_users MAP ( pv_users.userid, pv_users.date ) USING 'map_script' AS c1, c2, c3 DISTRIBUTE BY c2 SORT BY c2, c1) map_output INSERT OVERWRITE TABLE pv_users_reduced REDUCE ( map_output.c1, map_output.c2, map_output.c3 ) USING 'reduce_script' AS date, count; Pls can anyone tell what is the use of scripts and how to write block of queries in hive? -- Regards, Bhavesh Shah
