Re: log4j format logs in Hive table

2011-12-06 Thread Aniket Mokashi
tionId: 248] [Component: Crossplane] [Server: >>> server01] [Request: seats=5] [Response: yes] [Status: pass] - Entering >>> Method = getKey() >>> >>> How to specify the delimiter, while describing the table? >>> >>> Thanks, >>> Sang

Re: log4j format logs in Hive table

2011-12-06 Thread Abhishek Pratap Singh
] [CorelationId: 248] [Component: Crossplane] [Server: >> server01] [Request: seats=5] [Response: yes] [Status: pass] - Entering >> Method = getKey() >> >> How to specify the delimiter, while describing the table? >> >> Thanks, >> Sangeetha >> >>

Re: log4j format logs in Hive table

2011-12-06 Thread alo alt
nks, > Sangeetha > > *From:* alo alt > *To:* user@hive.apache.org; sangeetha k > *Sent:* Tuesday, December 6, 2011 2:01 PM > *Subject:* Re: log4j format logs in Hive table > > Hi, > > I hope I understood your question correct - did you describe your table? > Like >

Re: log4j format logs in Hive table

2011-12-06 Thread Mark Grover
tion www: oanda.com www: fxtrade.com e: mgro...@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. - Original Message - From: "sangeetha k" To: user@hive.apac

Re: log4j format logs in Hive table

2011-12-06 Thread sangeetha k
From: alo alt To: user@hive.apache.org; sangeetha k Sent: Tuesday, December 6, 2011 2:01 PM Subject: Re: log4j format logs in Hive table Hi, I hope I understood your question correct - did you describe your table? Like "create TABLE YOURTABLE (row1 STRING, row2 STRING, row3 STRING

Re: log4j format logs in Hive table

2011-12-06 Thread alo alt
Hi, I hope I understood your question correct - did you describe your table? Like "create TABLE YOURTABLE (row1 STRING, row2 STRING, row3 STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY 'YOUR TERMINATOR' STORED AS TEXTFILE;" row* = a name of your descision, Datatype look @documentation. After

log4j format logs in Hive table

2011-12-05 Thread sangeetha k
Hi,   I am new to Hive.   I am using Flume agent to collect log4j logs and sending to HDFS. Now i wanted to load the log4j format logs from HDFS to Hive tables. Each of the attributes in log statements like timestamp, level, classname etc... should be loaded in seperate columns in the Hive tables.