Hive has ODBC and JDBC drivers. What SQL functionality are you missing?