Here are some examples: [zs...@xxx /hive.root] find ./ql/src/test/queries/clientpositive -name '*.q' | xargs grep TRANSFORM ./ql/src/test/queries/clientpositive/input14_limit.q: SELECT TRANSFORM(src.key, src.value) ./ql/src/test/queries/clientpositive/input14_limit.q: SELECT TRANSFORM(src.key, src.value) ./ql/src/test/queries/clientpositive/input14.q: SELECT TRANSFORM(src.key, src.value) ./ql/src/test/queries/clientpositive/input14.q: SELECT TRANSFORM(src.key, src.value) ./ql/src/test/queries/clientpositive/input18.q: SELECT TRANSFORM(src.key, src.value, 1+2, 3+4) ./ql/src/test/queries/clientpositive/input18.q: SELECT TRANSFORM(src.key, src.value, 1+2, 3+4) ./ql/src/test/queries/clientpositive/scriptfile1.q: SELECT TRANSFORM(src.key, src.value) ./ql/src/test/queries/clientpositive/input5.q: SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring) ./ql/src/test/queries/clientpositive/input5.q: SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring) ./ql/src/test/queries/clientpositive/input17.q: SELECT TRANSFORM(src_thrift.aint + src_thrift.lint[0], src_thrift.lintstring[0]) ./ql/src/test/queries/clientpositive/input17.q: SELECT TRANSFORM(src_thrift.aint + src_thrift.lint[0], src_thrift.lintstring[0])
On Mon, Jan 12, 2009 at 8:58 PM, Josh Ferguson <j...@besquared.net> wrote: > Anyone have any word on why this might not work? Can someone give me an > example of a query they use to INSERT OVERWRITE a table from a map and/or > reduce job that I could use as a reference? > > Josh F. > > > On Jan 11, 2009, at 9:48 PM, Josh Ferguson wrote: > > I have a query that returns the proper results: >> >> SELECT TRANSFORM(actor_id) USING '/my/script.rb' AS (actor_id, percentile, >> count) FROM (SELECT actor_id FROM activities CLUSTER BY actor_id) actors; >> >> But when I do >> >> INSERT OVERWRITE TABLE percentiles >> SELECT TRANSFORM(actor_id) USING '/my/script.rb' AS (actor_id, percentile, >> count) FROM (SELECT actor_id FROM activities CLUSTER BY actor_id) actors; >> >> It says it loads data into the percentiles table but when I ask for data >> from that table I get: >> >> hive> SELECT actor_id, percentile, count FROM percentiles; >> FAILED: Error in semantic analysis: >> org.apache.hadoop.hive.ql.metadata.HiveException: Path >> /user/hive/warehouse/percentiles not a valid path >> >> $ hadoop fs -ls /user/hive/warehouse/percentiles/ >> Found 1 items >> -rw-r--r-- 1 Josh supergroup 0 2009-01-11 21:45 >> /user/hive/warehouse/percentiles/attempt_200901112100_0010_r_000000_0 >> >> It's nothing but an empty file. >> >> Am I doing something wrong? >> >> Josh Ferguson >> > > -- Yours, Zheng
