How to convert a List<Object[]> to Stream<Object>

Question

I have a native query which returns a List<Object[]>. I want to convert this List to a Stream<Object>. These Objects are different columns from different tables of my database.

What is the best solution to do that?

Create a DTO and convert a List<DTO> to Stream<DTO>? How can I do that?

Answer 1

Use flatMap:

List<Object[]> objectsList = new ArrayList<>();
Stream<Object> objectStream = objectsList.stream()
        .flatMap(Arrays::stream);

Answer 2

Assuming your DTO class has a proper constructor, you can write something like this:

List<Object[]> input = ...
Stream<DTO> dtos = input.stream().map(arr -> new DTO(arr[0], arr[1], ... , arr[n]);