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

hive query not working with where clause

New Contributor

Hive queries are failing when using where clause , for e.g

hive> select * from orderaction where subscriberkey = 123;

FAILED: IllegalStateException Unexpected type of ExprNodeDesc: null

any help would be appreciated ?

Version : HDP 2.2

2 REPLIES 2

Re: hive query not working with where clause

Master Collaborator

Do you have more of the stack trace? It should be in the /tmp/<user>/hive.log.

Also can you try running the same query with:

set hive.vectorized.execution.enabled = false

Re: hive query not working with where clause

@Deepesh What does vectorization has to do with the question?