Function to Parse Browser/OS from User Agent.

2012-04-20 Thread Gopi Kodumur
Is there a Function/UDF available to parseĀ  browser and OS from the User Agent String. Thanks Gopi

Re: Can we define external table Fields enclosed in "

2012-04-18 Thread Gopi Kodumur
w_stg(viewTime INT, userid BIGINT, page_url STRING, referrer_url STRING, ip STRING COMMENT 'IP Address of the User', country STRING COMMENT 'country of origination') COMMENT 'This is the staging page view table' ROW FORMAT DELIMITED FIELDS TERMINATED BY '44'

Can we define external table Fields enclosed in "

2012-04-17 Thread Gopi Kodumur
Is it possible to specify enclosed by character " for fields , while defining external table Thanks Gopi