I suggest you check out The End of an Architectural Era (It’s Time for a Complete Rewrite)[1].
The "failure" of non-relational databases was for specific application domains.
[1] http://nms.csail.mit.edu/~stavros/pubs/hstore.pdf