Is it possible to do a query like the following: INSERT OVERWRITE TABLE table1 PARTITION(...) FROM table2 SELECT TRANSFORM(table2.col1, table2.col2, ...) USING '/my/script' AS (col1, col2, ...) WHERE (...)
I can run the select transform segment of the query by itself fine and I get the results I expect. When I try and do the insert as well I'm getting errors with column type mismatches even though my script is outputting 3 columns with the exact same types in the exact order that they appear in table1. I tried doing this with both a mapper and reducer similar to what was shown in the Apache Con slides and it still didn't work. Am I doing something wrong query wise? I'm using the 0.19 release. Josh Ferguson
