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 import via "insert (overwrite) table YOURTABLE" - alex On Tue, Dec 6, 2011 at 8:56 AM, sangeetha k <[email protected]> wrote: > 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. > > I tried creating table in Hive and loaded the entire log in one column, > but dont know how to load the above mentioned data in seperate columns. > > Please send me your suggestions, any links, tutorials on this. > > Thanks, > Sangeetha > -- Alexander Lorenz http://mapredit.blogspot.com *P **Think of the environment: please don't print this email unless you really need to.*
