Am working on one requirement , it is simple loading the data from Hive to Postgresql using apache nifi. My processors are SelectHiveQL--->SplitAvro--->PutDatabaseRecord. SelectHiveQL get the data from Hive, in hive we have many columns but facing issues with Date Column and Timestamp Coloumns. In putDatabaseRecord am getting error as ":"PutDatabaseRecord[id=cecd3d18-f1d2-1d39-9e48-d4be96170480]
Failed to process
StandardFlowFileRecord[uuid=1bb1f4cf-3b06-4c0a-aaea-4156a3953ce9,claim=StandardContentClaim
[resourceClaim=StandardResourceClaim[id=1510654697269-11, container=default,
section=11], offset=186544,
length=4932],offset=0,name=64863335688318.avro,size=4932] due to
java.sql.BatchUpdateException: Batch entry 0 INSERT
INTO some XXXX Columns was
aborted: ERROR: column \"XXXdate\" is of type date but
expression is of type character varying\nHint: You will need to rewrite or cast the expression.\nPosition: 932Call getNextException to see other errors in the batch.:
","timestamp":"06:14:09
EST"}}],"generated":"06:16:37 EST"}} Would you please guide me to resolve the issue, do i need add any processor in the flow, how to come out of this issue Thanks in advance.
... View more
