TFetchResultsResp(status=TStatus(errorCode=None, errorMessage=‘UDF ERROR: Decimal express

error¶

When using impala to query, when using the cast function to convert the data to decimal type, an error will be reported:

Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True,
 modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='\xc8\xc1j\xfe\xd6.B\xa2\x9e\xc8\x1a63\xfb\x15\xf2'
 , guid='\xf8\x82.\x81^\xabE\x7f\x00\x00\x00\x00\xda\xf8\xa9\xa1')), orientation=4, maxRows=100)
 : TFetchResultsResp(status=TStatus(errorCode=None, errorMessage='UDF ERROR: Decimal expression 
 overflowed\n', sqlState='HY000', infoMessages=None, statusCode=3), results=None, hasMoreRows=None)

I checked it and found that it was a bug in impala. . . .
Bug link: https://issues.apache.org/jira/browse/IMPALA-6405

Up to now, this bug seems to still exist. Below is a screenshot of my test:

solution¶

Do not convert to decimal, or convert in other ways.