Table creation for logfile data

[Baahu]

Hi,
I have a messy log file which I want to use to create a table, I am only
interested to retrieve 3 columns (time,ADD,files),which are in bold.
Sample entry from log file
*: 13-11-23 06:23:45 [ADD] [file1.zip|file2.zip] *  junkjunk|2013-11-23
06:23:44:592 EST|file3.zip xyz|2013-11-23 06:23:44:592 EST|file3.zip

Can you please let me know how I should go about, regex seems to be way
out,but I am struggling with that as well !!

Thanks,
Baahu

SET PROPERTY FOR UDF

[Swagatika Tripathy]

Hi,

I want to customize the hive-site.xml to add some extra properties to be
used for a UDF.

The UDF is a part of the view to be created.

So , i tried setting the path through hivecli as below:

set hive.property.path=/Users/path of hive-testing.xml;

but it does not seem to take the path and gives me a Null pointer Exception.

Can u please suggest any alternative. This particular property was set
inside the UDF as below:
System.getProperty(hive.site.xml,hive-site.xml);

Regards,
Swagatika.