While Hive does provide a SQL layer on top of Hadoop MapReduce, that does not make it a relational database. While much of SQL is available, not every SQL construct can be used.
Limitations of the adapter include:
This can be avoided by adding a comment:
ENGINE SQLHIV /*QUERY*/ SHOW TABLES ; END
Issues addressed in Hive 0.12 are:
WebFOCUS |