question Re: Refresh Extract Error in Support Questions

Refresh Extract Error

mpla217 — Tue, 21 Apr 2026 06:44:03 GMT

I am getting the following error message when running a refresh. Do I have an invalid date field causing the issue?

Unable to complete action
Not all extracts were refreshed
An error occurred while refreshing outputtable
[Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement. Error Code: 40000, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:7 cannot recognize input near '{' 'fn' 'TIMESTAMPADD' in select clause:38:37, org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:335, org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:199, org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:260, org.apache.hive.service.cli.operation.Operation:run:Operation.java:247, org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:541, org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:HiveSessionImpl.java:527, org.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:312, org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIServi

Re: Refresh Extract Error

DianaTorres — Fri, 12 Jan 2024 19:00:48 GMT

@mpla217 Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Hive experts @Shmoo @mszurap who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Re: Refresh Extract Error

mszurap — Sat, 13 Jan 2024 11:16:42 GMT

Hi @mpla217 , can you share exactly what query are you executing? Per the error message the query is syntactically incorrect around the "TIMESTAMPADD" part.

If that TIMESTAMPADD function is not used, then maybe the Hive JDBC driver is optimizing the query (converting it) to use that function instead of plus signs (just guessing).

As per the output, you are using Cloudera Hive JDBC driver. Make sure you are using the latest version

https://www.cloudera.com/downloads/connectors/hive/jdbc

also you may try to use the "UseNativeQuery=1" connection url property to disable the optimizations done by the driver. (which are sometimes incorrect)

Thanks

Miklos

Re: Refresh Extract Error

DianaTorres — Mon, 15 Jan 2024 21:15:12 GMT

@mpla217 Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. If you are still experiencing the issue, can you provide the information @mszurap has requested? Thanks.

Re: Refresh Extract Error

mpla217 — Tue, 26 Mar 2024 15:24:33 GMT

The error message was related to a date field being used in a Parameter. I set up a Parameter to update to the newest date when the workbook opened. The date addition caused an issue with the refresh.