issue case:
aaa = rhive.big.query("select *,
CASE
WHEN petallength < 2.45 THEN 'first'
WHEN petallength >= 2.45 THEN 'second'
END as separation
from iris_3")
expected output:
1 5.1 3.5 1.4 0.2 setosa first
2 4.9 3.0 1.4 0.2 setosa first
.
.
50 5.0 3.3 1.4 0.2 setosa first
51 7.0 3.2 4.7 1.4 versicolor second
.
.
issue case: aaa = rhive.big.query("select *, CASE WHEN petallength < 2.45 THEN 'first' WHEN petallength >= 2.45 THEN 'second'
END as separation from iris_3")
expected output: 1 5.1 3.5 1.4 0.2 setosa first 2 4.9 3.0 1.4 0.2 setosa first . . 50 5.0 3.3 1.4 0.2 setosa first 51 7.0 3.2 4.7 1.4 versicolor second . .