Hydrodynamic magneto-transport in holographic charge density wave states