[SPARK-2594][SQL] Add CACHE TABLE <name> AS SELECT ... (Updated as per review comments)

Updated as per the review comments of Admin.
Previous pull request is https://github.com/apache/spark/pull/2381
This should be removed, as mentioned by @marmbrus in [this comment](https://github.com/apache/spark/pull/2381#discussion_r17513645).