Cloudera Community
amohit
user rank
New Contributor

Re: Hive: Set variable for Static Partitioning

by New Contributor in Support Questions
‎12-04-2017 12:18 AM
‎12-04-2017 12:18 AM
Sorry for late response:   INSERT INTO TABLE am_temp2 Partition (search_date="2017-11-18") this works    But the goal is to generate date which is failing . I assume that you were asking to enclose like (search_date='${hiveConf:var}')    the partition created with above solution becomes  /../search_date=date_sub(current_date-5)/      I worked on a work around where we generated the date using shell action and instead of counter we got the intended date and the used the approach which @Tomas79 suggested.   Thank you!! ... View more

Hive: Set variable for Static Partitioning

by New Contributor in Support Questions
‎11-22-2017 10:02 PM
‎11-22-2017 10:02 PM
Hello All, How to set variable in hive and insert value as partition? I'm passing {counter} as parameter.   Consider counter as 5 set hiveConf:var= date_sub(current_date-{counter}); Select ${hiveConf:var} ; Gives proper output i.e. 2017-11-18   But gives error when the same is used as below:   INSERT INTO TABLE am_temp2 Partition (search_date=${hiveConf:var}) SELECT * FROM am_temp1;   Error: NoViableAltException(16@[233:1: constant : ( Number | dateLiteral | timestampLiteral | StringLiteral | stringLiteralSequence | BigintLiteral | SmallintLiteral | TinyintLiteral | DecimalLiteral | charSetStringLiteral | booleanValue );]) FAILED: ParseException line 1:189 cannot recognize input near '$' '{' 'hiveconf' in constant   Please let know of any solution for static partitioning Thanks ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎02-19-2018 09:06 PM
Community Statistics
Member Since ‎11-22-2017 09:59 PM
Last Visited ‎02-19-2018 09:06 PM
Posts 2