Julian> If Hive doesn't want its ANDs re-ordered, i I'm afraid that is a non-starter for Hive use case. Replacing all ANDs with CASE would defeat simplified and it would defeat lots of rules.
Julian> * Make normalization less aggressive It still looks like a customization. There's one more option: admit that "AND operand shuffling" is a peephole optimization, and put the shuffling into a separate Hep phase. Then Calcite's normalization does not hurt, and the use case does not justify the need for a custom normalizer. Vladimir