hive multi delimiter data processing using regex serde example
in this video, i am explaining how to process different delimiter data using Hive using regex serde
drop table usertab1;
CREATE external TABLE usertab1(
userId int,
gender string,
age string,
occupation string,
zipcode string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
WITH serdeproperties("input.regex" = "(.+)!#(.+)!#(.+)!#(.+)!#(.+)", "output.format.string" = "%1$s %2$s %3$s %4$s %5$s") location 'hdfs/or/s3/path/' ;
Download this data from https://drive.google.com/file/d/12E7l...
if any doubts whatsapp me http
I think my videos useful to self-learners. As a self-learner if u r unable to understand I recommend take big data training +91-8500002025