create table documents(contents string) stored as textfile;

LOAD DATA LOCAL INPATH '../../data/files/docurl.txt' INTO TABLE documents;


select url, count(1) 
FROM
(
  FROM documents
  MAP documents.contents
  USING 'java -cp ../util/target/classes/ org.apache.hadoop.hive.scripts.extracturl' AS (url, count)
) subq
group by url;