Try StarRocks. I am totally not affiliated with them but I have investigated them deeply in the past.

That said, I have never seen 1 million columns.