[Backport 2.x] Support multi ranges traversal when doing date histogram rewrite optimization (#13317)

[Backport 2.x] Support multi ranges traversal when doing date histogram rewrite optimization (#13317) #29986