Using WITH statement in HIVE recipes

AnnaProba

Hi, Why can't we use WITH statements in HIVE recipes? It works in HIVE notebooks. According to documentation, WITH statements are allowed in HIve sincd 2015. I get this message when using WITH in Dataiku 12.6.5

Validation failed: The query contains 'WITH...' statements, which cannot be automatically handled by DSS. Put the 'INSERT OVERWRITE...' manually in the query or use a nested subquery

Will this ever be changed?

Turribeach

I have not used Hive but it probably relates to the difference between SQL query recipes and SQL scripts recipes:

https://doc.dataiku.com/dss/latest/code_recipes/sql.html