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
Best Answer
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,215 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,