AnsweredAssumed Answered

Transform MapR data structure in Hive

Question asked by gauravsahu on Jun 16, 2016
Latest reply on Jun 17, 2016 by Hao Zhu

Present

Student name

English Mark

Tamil Mark

Maths Mark

English Result

Tamil Result

Maths Result

Soma

30

60

100

Fail

Pass

Pass

Gaurav

60

70

90

Pass

Pass

Pass

 

I have a table in Hive as depicted in above table, the requirement is that I need to convert in to below mentioned format.

 

Needed

Student name

Subjects

Mark

Result

Soma

English

30

Fail

Soma

Tamil

60

Pass

Soma

Maths

100

Pass

Gaurav

English

60

Pass

Gaurav

Tamil

70

Pass

Gaurav

Maths

90

Pass

 

Kindly let me know the best possible way to do this. Any sort of help will be appreciated.

Outcomes