Yes, you are right words will be better. Word count isn't directly available in HiveSQL. The easiest fix I can think of is what @abh12345 suggested the other day, dividing the character count by 4 or 5. Other options will add more computation during query and may slow it down, that's why I didn't try yet. I will try different things to see if I can come up with a better solution. Thank you.
You are viewing a single comment's thread from: