Error while working with the sort recipe

Srkanoje

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

Alexandru

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,