I faced similar issue. fortunatly for me , the destination dir was not present. once i create it. the error got resolved. ... View more

Hi Geoffrey , Thanks for the suggestion . I am using ORC format for both table. it is only the sequence of the column that is causing the issue . EG: A(name string,sal decimal(3,2),DOB timestamp) B(name String , DOB Date, sal decimal(3,2)) When i insert data from B to A using a select query i am getting this error. if i drop table A and create it in the same sequence as of B it works fine. Is there a solution which can be applied here to force hive to insert data based on name of column instead their Sequence . ... View more

Thanks Matt , one more good article from you. If my nifi went down or processor stopped somehow. After restart what will be the value of the columns present ? (reset or will it keep the updated value) also eagerly waiting for this processor to handle the actual cdc data from database change log file.that will solve many use cases i hope and may reduce the cost of other CDC based tools. ... View more