Hi All I am using Hive3.1.5. I am getting below error for the update query where sub-queries are used.   Query: UPDATE tableA  SET ColA = "Value" WHERE year(DateColumn)>=(select (max(year(DateColumn))-1) from tableB);   Error: undefined:-1 Unsupported SubQuery Expression '1': Only SubQuery expressions that are top level conjuncts are allowed   Any leads on this. How this can be avoided ... View more