I'm having trouble getting date information into my workflow from a coordinator to schedule a Hive query periodically.  I'm using the GUI. For Hive: My destination_table has a partition on the 'dt' column of type DATE. The query, which I've of course tested separately without the parameterization: insert into table destination_table partition(dt='${dt}')  # note dt is string select * from source where day=${d}  # note day, month, year are integers and month=${m} and year=${y} In my worflow, I created four parameters: d=${DAY} m=${MONTH} y=${YEAR} dt=${YEAR}-${MONTH}-${DAY} In my coordinator, under Workflow Parameters, I select DAY, MONTH and YEAR in the picklists, and then have respectively for each:   ${coord:formatTime(coord:nominalTime(), 'dd')} ${coord:formatTime(coord:nominalTime(), 'MM')} ${coord:formatTime(coord:nominalTime(), 'yyyy')} I think something's wrong with my workflow/coordinator parameters as the query runs without error, but doesn't result in any inserts. Thanks. ... View more