If we get questions on Hive metastore(like create a table in hive meta store etc), should we suppose to login into Hive or should we suppose to execute them in spark-shell using sqlContext?
For example, there will be a question like, there is a Order table data in certain location in hdfs.
make sure this data is available in hive data store so that users can do select queries on this data.
2 ways to solve this:
- login into Hive. create external table using this location.
- using spark-shell, use saveAsTable.
Which one to choose?