Skip to main content
mpla217
mpla217
Silver ⭐️
January 12, 2024
Question

Refresh Extract Error

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

4 replies

DianaTorres
Community Manager
DianaTorres
Community Manager
January 12, 2024

@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.

Translate
Regards, Diana Torres, Senior Community Moderator
mpla217
mpla217Author
Silver ⭐️
March 26, 2024

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.

Translate
mszurap
Platinum ⭐️
mszurap
Platinum ⭐️
January 13, 2024

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

Translate
DianaTorres
Community Manager
DianaTorres
Community Manager
January 15, 2024

@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.

Translate
Regards, Diana Torres, Senior Community Moderator
Terms & ConditionsAccessibility statement