March 2017
Beginner to intermediate
356 pages
7h 11m
English
Spark provides SparkSQL CLI to work with the Hive metastore service in local mode and execute queries input from the command line.
You can start the Spark-SQL CLI as follows:
./bin/spark-sqlConfiguration of Hive is done by placing your hive-site.xml, core-site.xml, and hdfs-site.xml files in conf/. You may run ./bin/spark-sql --help for a complete list of all available options.
We have seen how you can work with Hive, which is fast becoming a defacto data warehouse option in the open source community. However, most of the data in the enterprises beginning with Hadoop or Spark journey is to stored in traditional databases including Oracle, Teradata, Greenplum, and Netezza. Spark provides you with the option ...
Read now
Unlock full access