Error while working with the sort recipe

Srkanoje
Srkanoje Registered Posts: 32 ✭✭✭✭

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

Best Answer

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,215 Dataiker
    Answer ✓

    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,

Setup Info
    Tags
      Help me…