Very nice, we have what we used to have again..., thanks @geekgirl!
EDIT: Words might be better than characters?
You are viewing a single comment's thread from:
Very nice, we have what we used to have again..., thanks @geekgirl!
EDIT: Words might be better than characters?
.
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.