When requesting a Hadoop cluster on http://www.hadooponazure.com/, select the option: Use SQL Azure for Hive Metastore to use a SQL Azure database as a Hive metastore.