How to input twitter logs into HIVE table

Anonymous — Sun, 11 Dec 2016 11:30:07 GMT

Hello, I am trying to extract data out from a twitter log and insert it into a HIVE table.
The data looks something like this:

I would like to split the data into something like this:
Day Month Date Time Timezone Year Name Tweet
"Tue" "Mar" "19" "00:59:55" "CET" "2013" "(Hailey1711)" "This history project is death"

However, I can see some issue that Talend might have when I try to delimit the data

Is there a way I can overcome this?

Thank you.

Re: How to input twitter logs into HIVE table

Anonymous — Mon, 19 Dec 2016 07:28:35 GMT

Hi,
What does your current job design look like? Did you use tExtractDelimitedField component?
Best regards
Sabrina

topic How to input twitter logs into HIVE table in Talend Studio

How to input twitter logs into HIVE table

Re: How to input twitter logs into HIVE table