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;