Hive recipe to write multiple output datasets
Dilli
Registered Posts: 3 ✭✭✭
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.
Best Answer
-
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-InsertingdataintoHiveTablesfromqueries