Hi,
For a log file storing scenario using BAM2, I have a requirement to
generate separate log files for each date. For that I have created a Hive
Analytic query along with a Hive UDF as well.
I have the getFilePath function which should return a URL like this.
home/user/Desktop/logDir/logs/log_0_testServer_2012_07_22
The defined function works perfectly if I put *getFilePath(
"0","testServer" ) *into the *select* statement.
But I want to get that particular URL as the *local directory name*.
(The requirement is such that this should not be hard-coded in the hive
query. Rather should be generated in the custom UDF. )
So can I do something like I v shown below?
*set file_name= getFilePath( "0","testServer" ); *//Define a parameter.*
*
*.................*
*..............*
*INSERT OVERWRITE LOCAL DIRECTORY 'file:///${hiveconf:file_name}'
*//Assign the above parameter as the file URL
I tried this way. But the directory name is returned as
file:/getFilePath( "0" , "testServer" )
Does that mean I cannot use UDF to define the local directory name?
Or am I doing anything wrong in here?
--
~Regards
*Manisha Eleperuma*
Software Engineer
WSO2, Inc.: http://wso2.com
lean.enterprise.middleware
*
*
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
