Home > database >  HiveSQL filter conditions require a=10 and (20 and b=c=30) such circumstance how to write SQL? O bos
HiveSQL filter conditions require a=10 and (20 and b=c=30) such circumstance how to write SQL? O bos

Time:09-16

B and c is a condition that must be satisfied at the same time, my SQL if brackets can be here

CodePudding user response:

Didn't quite understand your question, a, b, c three conditions must be meet at the same time, is not to need to add parentheses,

CodePudding user response:

A where clause to write directly inside the where a and b==10 and 20 c=30 can support the HQL

CodePudding user response:

B=20 and 30, c=in the where clause and group by... Hiving clause, is satisfied at the same time, do not need to add brackets; In the join... Need to add brackets on clause
  • Related