Hi Daniel, You can use the RegexSerDe to extract the fields embedded in the text. Try looking at the examples in contrib/src/test/queries/clientpositive/serde_regex.q
Carl On Thu, Feb 25, 2010 at 8:44 AM, Daniel Joanes <[email protected]> wrote: > If I have a line like the following: > > <2010-02-09 18:00:16.123 UTC>:[48394803]:<MDS-CS_MDS1>:<DEBUG>:<LAYER = > EP2P, EVENT = Receiving, DEVICEPIN = 2032acb14, GMETAG = -1966209606, TYPE = > 22, METHOD = onInEp2p, DESTINATION = 24a69edf, CONFIRM = true, > EXP_TIMEOUT(S) = 3600, SIZE = 7312> > > What would be the best way to store it into a table like this: > > ts STRING "2010-02-09 18:00:16.123 UTC" > epochtime INT "345093824" // <-- I'm not sure how to do this > column either > requestId INT 48394803 > component STRING "MDS-CS_MDS1" > log_level STRING "DEBUG" > properties STRING "LAYER = EP2P, EVENT = Receiving, DEVICEPIN = > 2032acb14, GMETAG = -1966209606, TYPE = 22, METHOD = > onInEp2p, DESTINATION = 24a69edf, CONFIRM = true, > EXP_TIMEOUT(S) = 3600, SIZE = 7312" > > Thanks, > > Daniel >
