You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by elango vaidyanathan <el...@gmail.com> on 2017/08/01 05:54:39 UTC

Cursor implementation in hive

Hi all,



I need to convert a SQL functionality that is in oracle now to hive



Existing pl/sql sudo code:



/* using cursor, column1 value is updated based on various if condition
checks */

Open cursor<>

If (<condition>)

Update table column1 with value 1

Else if (<conditon>)

Update table column1 with value 2

Some value= somefunction()

If(somevalue)

Update table column1 with value 3

Close cursor<>



How do I implement this in hive? Can anyone help me with this?



Thanks,

Elango



Thanks,
Elango