mercredi 23 janvier 2019

How to calculate columns based on other columns codes in hive

enter image description here

We have a sale table with different sale amount and sale code. I want to calculate the sale total amount base on different code.

The formula is Total sale = code1 -code2 +code3 -code 4.

How can I get the result by a hive query?

Aucun commentaire:

Enregistrer un commentaire