question How to set variable in hive partition ? in Archives of Support Questions (Read Only)

How to set variable in hive partition ?

jeanette75007 — Thu, 13 Jul 2017 00:43:27 GMT

Hello all,

How to set variable in hive and insert value as partition? I have below commands and the partition is not getting from the variable that I set but getting constant "var" instead datetime.

set hiveVar:var= from_unixtime(unix_timestamp()-1*60*60*4, 'yyyyMMddHH');

INSERT INTO TABLE tmp Partition (datehour='${hiveVar:var}') SELECT * FROM tmp2;

Please help.

Thanks

Re: How to set variable in hive partition ?

rbiswas1 — Thu, 13 Jul 2017 03:17:24 GMT

@JT Ng

Just omit the quotes and fire the insert.

INSERT INTO TABLE tmp Partition (datehour=${hiveVar:var}) SELECT * FROM tmp2;

You can also test before firing the insert like this:

select ${hiveVar:var};

You should be good.

Thanks

Re: How to set variable in hive partition ?

rbiswas1 — Wed, 19 Jul 2017 23:42:42 GMT

@JT Ng

You might want to close the thread by accepting the answer.