One of Wall Street’s biggest bulls is growing increasingly worried about a stock market meltup

"The problem with meltups is that they do need to meltdown," market veteran Ed Yardeni told CNBC on Wednesday.