Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Left join of empty dataset

Solved!
tomas
Neuron
Neuron
Left join of empty dataset
Hi,

I have a join recipe (left join) where one of the joined table is empty (it is calculated sucesfully but empty). The recipe fails with an ERROR that the input dataset is not ready. How to avoid this error?

Thanks
0 Kudos
1 Solution
Clément_Stenac
Dataiker
Dataiker
Was it computed by Impala ? If it was, unfortunately, a behavior of Impala is that if there are 0 output rows, it doesn't even create an empty file, which leads DSS to think that the dataset isn't ready. There is no workaround apart from changing the engine which computed the empty dataset.

View solution in original post

0 Kudos
3 Replies
Clément_Stenac
Dataiker
Dataiker
Was it computed by Impala ? If it was, unfortunately, a behavior of Impala is that if there are 0 output rows, it doesn't even create an empty file, which leads DSS to think that the dataset isn't ready. There is no workaround apart from changing the engine which computed the empty dataset.
0 Kudos
tomas
Neuron
Neuron
Author
Yes it was.
0 Kudos
vic
Level 2

Is it the same reason why I have the same problem with a Hive recipe? no workarround possible?

0 Kudos

Labels

?
Labels (3)
A banner prompting to get Dataiku