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

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

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...

0 Kudos