0 Replies Latest reply on Oct 15, 2018 1:10 AM by Muhammad Asfandyar

    The Hadoop Hive engine was unable to execute the query.

    Muhammad Asfandyar

      Hi, I'm getting this error when i pull something on my tableau sheet. I opened the log files to check the error detail and found this:

      {"ts":"2018-10-14T20:08:27.431","pid":22088,"tid":"63fc","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k:"msg","v":"ODBCProtocolImpl::ExecutePreparedQuery: The query failed to execute or was cancelled.","ctx":{"client-type":"desktop","procid":"6476","tid":"1956","version":"20182.18.0925.2120"}}

      {"ts":"2018-10-14T20:08:27.432","pid":22088,"tid":"63fc","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"database-error","v":{"error-records":[],"file":"D:\\tc\\builds\\t182\\t182.18.0925.2120\\modules\\connectors\\tabmixins\\main\\db\\ODBCProtocolImpl.cpp","line":1950,"protocol":"1b169a2ce00","retcode":-1,"retcode-desc":"SQL_ERROR"},"ctx":{"client-type":"desktop","procid":"6476","tid":"1956","version":"20182.18.0925.2120"}}

      {"ts":"2018-10-14T20:08:27.432","pid":22088,"tid":"5670","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"excp","v":{"excp-msg":"The Hadoop Hive engine was unable to execute the query.\n","excp-type":"class DataSourceException","msg":"ODBCExecuteQueryTask: rethrow datasource exception"},"ctx":{"client-type":"desktop","procid":"6476","tid":"1956","version":"20182.18.0925.2120"}}

      {"ts":"2018-10-14T20:08:27.432","pid":22088,"tid":"5670","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"excp","v":{"class":"","dse-type":"Unknown","excp-msg":"The Hadoop Hive engine was unable to execute the query.\n","excp-type":"class DataSourceException","is-bad-request":false,"is-local-configuration-error":false,"is-remote-configuration-error":false,"msg":"DataSourceException::Throw"},"ctx":{"client-type":"desktop","procid":"6476","tid":"1956","version":"20182.18.0925.2120"}}

      {"ts":"2018-10-14T20:08:27.432","pid":22088,"tid":"5670","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"end-query","v":{"cols":0,"elapsed":8.509,"exception-msg":"The Hadoop Hive engine was unable to execute the query.\n","is-command":false,"protocol-class":"hortonworkshadoophive","protocol-id":-1,"query-category":"Data","query-hash":25687070,"query-trunc":"SELECT `agg_pmnm_hrly`.`cell_name` AS `cell_name`\nFROM `mergeco`.`agg_pmnm_hrly` `agg_pmnm_hrly`\nGROUP BY `agg_pmnm_hrly`.`cell_name`","rows":0},"ctx":{"client-type":"desktop","procid":"6476","tid":"1956","version":"20182.18.0925.2120"}}

      Hope I get a reply soon

      Regards,

      Muhammad Asfandyar