Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi all,
The partition variables such as CURRENT_DAY are apparently available but it it impossible to find how to get 1_DAYS_BEFORE to work in SQL Recipes for manual partition specification.
The log shows that they are available though:
"DKU_DST_YEAR": "2019",
"DKU_DST_MONTH_7DAYSBEFORE": "03",
"DKU_DST_DATE_1DAYBEFORE": "2019-03-18",
"DKU_DST_DATE": "2019-03-19",
"tbl:hourly_summary": "\"dataiku\".\"ZIZZI_UK_hourly_summary\"",
"DKU_DST_MONTH_1DAYAFTER": "03",
"schema:hourly_summary": "\"dataiku\"",
"DKU_DST_partition_first_day_of_week": "2019-03-19",
"DKU_DST_MONTH_1DAYBEFORE": "03",
"DKU_DST_DAY_1DAYBEFORE": "18",
"DKU_DST_DAY_7DAYSBEFORE": "12",
"DKU_DST_DATE_7DAYSBEFORE": "2019-03-12",
"schema:transactions_table_restaurants": "\"dataiku\"",
"DKU_DST_DAY": "19",
"DKU_DST_DATE_1DAYAFTER": "2019-03-20",
"DKU_DST_DAY_1DAYAFTER": "20",
"DKU_DST_MONTH": "03",
"DKU_DST_YEAR_1DAYAFTER": "2019",
"DKU_DST_YEAR_1DAYBEFORE": "2019",
"DKU_DST_YEAR_7DAYSBEFORE": "2019",
Any guidance on that?
Cheers,
Dany