My Oracle Support Banner

Error while executing a HIVE type connector which has source timestamp datatype in the mapping (Doc ID 2718662.1)

Last updated on OCTOBER 14, 2020

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7 version, Connector Execution_OFSS

 Error while executing a HIVE type connector which contain mapping with timestamp datatype in the source. 

Error message in execution log :

[15-04-20 16:19:06.257][INFO ] [ScenarioExecutor$1][write] Error msg -ODI-1228: Task Load data-LKM SQL to SQL- fails on the target connection OFSINFODOM.

Caused By: java.sql.SQLException: [Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement. Error Code: 10293, SQL state: TStatus(statusCode:ERROR_STATUS,

infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values:17:16,org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:185, *org.apache.hadoop.hive.ql.parse.SemanticException:Expression of type TOK_FUNCTION not supported in insert/values:27:1, org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:unparseExprForValuesClause:SemanticAnalyzer.java:914,org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genValuesTempTable:SemanticAnalyzer.java:842], sqlState:42000, errorCode:10293, errorMessage:Error while compiling statement: FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values), Query: INSERT INTO TABLE `hivedatadom`.`c_0i_21292_filter` VALUES ( CAST( '2018-12-24 00:00:00.0' AS TIMESTAMP) , 'AED' , 'CNO' , 761 ).



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.