The output path in this query is already parameterized-
*INSERT OVERWRITE LOCAL DIRECTORY 'file:///${hiveconf:file_name}'*
Though UDF is not going to be invoked here.
Thanks,
Vinod
2012/7/23 Manisha Gayathri <[email protected]>
> Hi
>
> Is there any possibility of defining the output directory of a hive
> query using a Hive UDF?
>
> In my UDF, I am passing 2 parameters (as follows) and this generates a
> file-system URL
> *getFilePath( "0","testServer" );*
>
> Can I use the above getFilePath( "0","testServer" ) value, as the Local
> Directory location as follows?
> *INSERT OVERWRITE LOCAL DIRECTORY 'file:///${hiveconf:file_name}'*
>
> If above is not the correct way, could you please show me how to do it?
> Your help is much appreciated!
>
> Thanks
>
> ~Regards
> *Manisha Eleperuma*
> Software Engineer
>
> *
> *
>
>