Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

Hive recipe to write multiple output datasets

Solved!
Dilli
Level 1
Hive recipe to write multiple output datasets

I have hive script for positive case one dataset and for the negative case, want to write into another separate dataset. How can I achieve this.

 

One Hive recipe with mutiple input and multiple output.

0 Kudos
1 Solution
fchataigner2
Dataiker
Dataiker

Hi,

if you want several outputs in a Hive recipe, you need to write the full SQL, including the "INSERT OVERWRITE TABLE ..." part, that DSS automatically adds before the SELECT ...  when there's only one output. See the Hive doc : https://cwiki.apache.org/confluence/display/hive/languagemanual+dml#LanguageManualDML-Insertingdatai...

View solution in original post

0 Kudos
1 Reply
fchataigner2
Dataiker
Dataiker

Hi,

if you want several outputs in a Hive recipe, you need to write the full SQL, including the "INSERT OVERWRITE TABLE ..." part, that DSS automatically adds before the SELECT ...  when there's only one output. See the Hive doc : https://cwiki.apache.org/confluence/display/hive/languagemanual+dml#LanguageManualDML-Insertingdatai...

View solution in original post

0 Kudos
A banner prompting to get Dataiku DSS