Meanwhile, while there are several projects in the Hadoop ecosystem that provide a SQL interface to data stored in Hadoop (such as Hadapt, Hive, and Impala), they require the user to create a schema before the data can be analyzed via SQL, which eliminates a major reason why the NoSQL database was used in the first place.