depending on how you are submitting the statement to hive, you'll probably need
to escape the backslash...
try replacing every \ with \\
From: IT CTO [mailto:goi@gmail.com]
Sent: Thursday, October 01, 2015 6:25 AM
To: user@hive.apache.org
Subject: Re: Hive SerDe regex error
Your
Your Regex gives different results. I want the last part to capture the
rest of the string.
I also tried this
CREATE EXTERNAL TABLE syslog (
month STRING,
day STRING,
time STRING,
source STRING,
process STRING,
pid STRING,
uname STRING,
message STRING)
COMMENT 'This is the syslog s
Hi,
You didn't escape the ^ character at the end.
Try using this string instead: ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ([^
\[]*)\[([^ ]*)\]: \(([^ ]*)\) ([\^]*)
Daniel
On Thu, Oct 1, 2015 at 3:17 PM, IT CTO wrote:
> Hi,
> I am trying to create a table with Regex SerDe but failing with no good
> reaso
Hi,
I am trying to create a table with Regex SerDe but failing with no good
reason:
CREATE EXTERNAL TABLE syslog (
month STRING,
day STRING,
time STRING,
source STRING,
process STRING,
pid STRING,
uname STRING,
message STRING)
COMMENT 'This is the syslog sample table'
ROW FORMAT SER
