Thank you for the advice, never occurred to me to look in the logs. The logs showed a permission denied error. As specified in the installation instruction I configured the ODBC driver to log on as user hadoop but this user has no write access. I changed the user to hdfs and the query works. Thanks again!