Refresh Extract Error

[#1]

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

[#2]

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

[#3]

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.

[#4]

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

[#5]

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