CREATE TABLE `table`(`string` string) STORED AS TEXTFILE;

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

SELECT `table`, count(1)
FROM
(
  FROM `table`
  SELECT TRANSFORM (`table`.`string`)
  USING 'java -cp ../util/target/classes/ org.apache.hadoop.hive.scripts.extracturl' AS (`table`, count)
) subq
GROUP BY `table`;