O'Reilly logo
  • david p moore thinks this is interesting:

CREATE DATABASE

From

Cover of Spark: The Definitive Guide

Note

It doesn't mention it here, but the CREATE DATABASE command actually creates a directory in the underlying file system. You can specify a location for the database with a the location key word followed by the path. If you don't specify a location it will default to the Hive warehouse directory.