hadoop - Assignment in Hive query -

hadoop - Assignment in Hive query -

i have below query in need assign 1 table column value table column.

query:

select a.aval,b.bval,b.bval1 bring together b on (a.aval = b.bval)

how assign 1 table column value table column in hive?

have tried

select a.aval,b.bval,b.bval1, a.aval = b.bval1 bring together b on (a.aval = b.bval)

in results:

a.aval = b.bval1, returning false since not assigning a.aval.

i guess want write in table ?

so have create table (for illustration c) contains fields need. , :

insert [overwrite] table c select a.aval,b.bval,b.bval1, a.aval bring together b on (a.aval = b.bval)

the result of select inserted in table c

hadoop hive hiveql