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 SERDE "org.apache.hadoop.hive.serde2.RegexSerDe" WITH SERDEPROPERTIES ( "input.regex" = "([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ([^ \[]*)\[([^ ]*)\]: \(([^ ]*)\) ([^]*)" ) STORED AS TEXTFILE LOCATION 'dfs://localhost:8020/data/flumeTest/flume-test-spoolDir';
The regex iself works on regex tester so I don't understand why I am getting: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.util.regex.PatternSyntaxException: Unclosed character class near index 66 ([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*) ([^ []*)[([^ ]*)]: (([^ ]*)) ([^]*) Any help? -- Eran | "You don't need eyes to see, you need vision" (Faithless)
