Support Questions
Find answers, ask questions, and share your expertise

Fail to run hive query using "where" clause with the error

New Contributor

Tez:ERROR : Status: Failed ERROR : Vertex failed, DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0

query=select action ,suittype from spark.country_details where suittype='outbound';

3 REPLIES 3

Re: Fail to run hive query using "where" clause with the error

Expert Contributor

Can you check Tez view for that query.

You can get application ID from Tez view / Resource Manager.

Then check- yarn logs -applicationId 'AppId'

That should give you more information.

Re: Fail to run hive query using "where" clause with the error

Could you try running the query after setting property tez.runtime.shuffle.ssl.enable=false and let us know the result?

Re: Fail to run hive query using "where" clause with the error

@Wasim Shaikh

If you are running the query from Hive Cli, launch the Hive Cli in debug mode as below and share the complete query run output:

hive --hiveconf hive.root.logger=Debug,console