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

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

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