Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Combine multiple rows with in a single day into one (Using RDD API)

Highlighted

Combine multiple rows with in a single day into one (Using RDD API)

New Contributor

Combine multiple rows with in a single day into one (Using RDD API)

input:

chanellID starttime endtime

100 17/08/2018:10:00:00 17/08/2018:11:00:00

100 17/08/2018:10:20:00 17/08/2018:10:40:00

100 17/08/2018:10:15:00 17/08/2018:11:30:00

100 18/08/2018:05:20:00 18/08/2018:06:00:00

101 18/08/2018:05:40:00 18/08/2018:06:00:00

output:

chanellID starttime endtime

100 17/08/2018:10:00:00 17/08/2018:11:30:00

100 18/08/2018:05:20:00 18/08/2018:06:00:00

101 18/08/2018:05:40:00 18/08/2018:06:00:00

Don't have an account?
Coming from Hortonworks? Activate your account here