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

Error while working with the sort recipe

Solved!
Srkanoje
Level 3
Error while working with the sort recipe

Hi,

I got below error when running the sort recipe,

Failed to compute execution plan
Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered'
ERRORERR_RECIPE_VALIDATION_FAILED
Validation failed
Failed to compute execution plan: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered', caused by: SemanticException: Line 22:15 Table not found 'riskrpt_poc_lookup_filtered'

 

can someone please suggest actions on this

0 Kudos
1 Solution
AlexT
Dataiker
Dataiker

Hi @Srkanoje 

The error suggests that a dependent dataset is not present.

 Table not found 'riskrpt_poc_lookup_filtered',

Can you please try rebuilding the riskrpt_poc_lookup_filtered dataset from your flow and let us know if you still encounter the same error.

Thanks,

View solution in original post

0 Kudos
1 Reply
AlexT
Dataiker
Dataiker

Hi @Srkanoje 

The error suggests that a dependent dataset is not present.

 Table not found 'riskrpt_poc_lookup_filtered',

Can you please try rebuilding the riskrpt_poc_lookup_filtered dataset from your flow and let us know if you still encounter the same error.

Thanks,

0 Kudos