Awesome, that worked. From what I can tell the columns in my table have to be strings.. how would I use other data types?
On Thu, Feb 25, 2010 at 1:49 PM, Carl Steinbach <[email protected]> wrote: > 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 >> > >
