Here's a look at different ways to query Hadoop via SQL, some of which are part of the latest edition of MapR's Hadoop distribution SQL: old and busted. Hadoop: new hotness. That’s the conventional ...
SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...
Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.