How to input twitter logs into HIVE table

[Anonymous]

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.

[Anonymous]

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