question Re: [Solved] Expected state FINISHED, but found ERROR when executing a query in Archives of Support Questions (Read Only)

[Solved] Expected state FINISHED, but found ERROR when executing a query

juan_manuel_nie — Tue, 21 Apr 2026 13:55:25 GMT

Hello I got just this error without logs when executing a query though HUE: Expected state FINISHED, but found ERROR.

This happens just with one user, when I try the same query with another user with the same groups etc I have no errors, when I check log tab, I found it empty.Any idea about how to solve this?

Update: When I execute the query from hive it works with all users so should be a problem with HUE

Re: [Solved] Expected state FINISHED, but found ERROR when executing a query

jstraub — Mon, 28 Dec 2015 22:51:59 GMT

whats the name of the user that is getting this error?

Re: [Solved] Expected state FINISHED, but found ERROR when executing a query

juan_manuel_nie — Mon, 28 Dec 2015 23:37:32 GMT

The username is pt0034 I'm currently trying with a new user called test-user with all the groups etc.. and doesnt work either.

Re: [Solved] Expected state FINISHED, but found ERROR when executing a query

aervits — Thu, 31 Dec 2015 10:23:22 GMT

can you provide the logs?

Re: [Solved] Expected state FINISHED, but found ERROR when executing a query

jstraub — Thu, 31 Dec 2015 16:22:23 GMT

did you change any config? how did you add the user pt0034?

Could you start the query again and monitor the hiveserver2.log file (/var/log/hive/...) and check whether some errors show up.

Re: [Solved] Expected state FINISHED, but found ERROR when executing a query

aervits — Tue, 02 Feb 2016 23:47:41 GMT

@Juan Manuel Nieto has this been resolved? Can you post your solution?

Re: [Solved] Expected state FINISHED, but found ERROR when executing a query

juan_manuel_nie — Thu, 04 Feb 2016 03:30:06 GMT

Finally the problem was solved... we dont really now what happened because the only change in the config was the yarn schedules, after changing it again the we think that was just a yarn schedules missconfig, but apparently the logs didn't say anything about it.

Thank you everyone and an apology for the delay in the answer.

Re: [Solved] Expected state FINISHED, but found ERROR when executing a query

nsabharwal — Thu, 04 Feb 2016 03:30:52 GMT

@Juan Manuel Nieto Thanks for the final followup!!