In the near future (aka the present), both are in demand. Nobody can predict what will happen in the far future.
I think you are better off learning Hadoop first. You already have the database background which puts you ahead of a lot of developers. Making it more likely you can become a Hadoop expert at some point.
I think the point being made is that you can't know what's going to be big, you can only know that it's not going to be the same that's big today, because that's going to be dead. That's why you need to be prepared for constant learning, and it makes the fundamentals more important than any single product or technology.
Aijaz Mallick wrote:
Yes thats true that in technology nothing stays forever. But still on positive notes which will gain more momentum.
This can't be predicted. One thing that can be predicted is that there will be demand for good programmers. Forget the technology, focus on the basics. If you want to get into Java, focus on getting strong on OOP fundamentals.
SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!