Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- REVISION 12 30364918 Anarchism 2005-12-06T17:44:47Z RJII 141644
- create external table testTable (
- tag string,
- a string,
- r string
- )
- row format SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
- WITH SERDEPROPERTIES(
- "input.regex" = "REVISIONs,[0-9]*,s,[0-9]*,s[a-zA-Z0-9]*s,[0-9]*-[0-9]*-[0-9]*T[0-9]*:[0-9]*:[0-9]*Z",
- "output.format.string" = "%1$s %2$s %3$s")
- stored as textfile
- location 'hdfs://location:8020/user/bd4-project1/enwiki-20080103-sample';
- create table ts_test2(
- tag string,
- a string,
- r string
- )
- row format SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
- WITH SERDEPROPERTIES(
- "input.regex" = "REVISION ([0-9]+) ([0-9]+) [a-zA-Z0-9]+ ([0-9]+-[0-9]+-[0-9]+T[0-9]+:[0-9]+:[0-9]+[Z]) RJII [0-9]+$",
- "output.format.string" = "%1$s %2$s %3$s");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement