| USE default; | |
| -- null input.regex, raise an exception | |
| CREATE TABLE serde_regex( | |
| host STRING, | |
| identity STRING, | |
| user STRING, | |
| time STRING, | |
| request STRING, | |
| status STRING, | |
| size STRING, | |
| referer STRING, | |
| agent STRING) | |
| ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe' | |
| STORED AS TEXTFILE; |