export the fluid cache as single alembic. make sure it has no polygon with more than 4 sides.
you can use @numvtx>4 in a houdini group expression node to figure out such polygons and triangulate them. unreal does not import geometry with polygons that has more than 4 sides. either triangles or quads accepted.
Water look example :
1. Lumen On
2. Forward Shading Off