[DRILL-3222] Need a zip function to combine coordinated lists

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Ted Dunning
• Created: 30/May/15 08:58
• Updated: 24/Jun/16 21:50

Description

It is often very useful to be able to turn a pair (or more) of lists into a single list of pairs. Thus zip([a,b], [1,2]) => [[a,1], [b,2]].

The handling of short lists, more than two lists and so on is TBD, but the base function is an important one.

One use case is in time series where storing times as one list and values as another is very handy but processing these results would be much better done by using flatten(zip(times, values)).