I mean, don't use the 'ADD' statement. Just directly specify the path in your SELECT statement.
SELECT TRANSFORM(a,b) USING '/path/to/script' AS c,d FROM table On 8/10/09 1:58 AM, "Saurabh Nanda" <[email protected]> wrote: > >> As a work around, can you copy the file locally on the server and use the >> complete path (local to the server) in the query? > > The file is available locally to the machine running "./bin/hive --service > hiveserver" Do you want me to try using the full file path? However, the error > message doesn't say "file not found". It says "cannot recognize input 'add'" > > Saurabh.
