hadoop - sqoop export from hive to sql server error -
we trying export data hive sql server table
sqoop export -d mapred.child.java.opts='\-djava.security.egd=file:/dev/../dev/urandom' --connect 'jdbc:sqlserver://' --username $$$$ --password #### --table ib_c3 --columns bill_to_customer_name,contract_number,service_line_id,service_line_name,service_line_status,sts_code,instance_id,serial_number,item_name,quantity,inventory_item_id,warranty_type,warranty_end_date,ship_date,party_site_id,last_dos,ib_product_type,product_family,erp_item_type,sku_list_price -m 1 --input-fields-terminated-by '\001' --export-dir /app/dev/smartanalytics/apps/csp/hivewarehouse/csp.db/csp_ib_c3_export --input-null-string '\\n' --input-null-non-string '\\n' -- --schema staging
during export getting below error sqoop. can issue.
caused by: java.io.ioexception: com.microsoft.sqlserver.jdbc.sqlserverexception: current transaction cannot committed , cannot support operations write log file. roll transaction. @ org.apache.sqoop.mapreduce.asyncsqlrecordwriter.write(asyncsqlrecordwriter.java:220) @ org.apache.sqoop.mapreduce.asyncsqlrecordwriter.write(asyncsqlrecordwriter.java:46) @ org.apache.hadoop.mapred.maptask$newdirectoutputcollector.write(maptask.java:644) @ org.apache.hadoop.mapreduce.task.taskinputoutputcontextimpl.write(taskinputoutputcontextimpl.java:89) @ org.apache.hadoop.mapreduce.lib.map.wrappedmapper$context.write(wrappedmapper.java:112) @ org.apache.sqoop.mapreduce.textexportmapper.map(textexportmapper.java:84) ... 10 more caused by: com.microsoft.sqlserver.jdbc.sqlserverexception: current transaction cannot committed , cannot support operations write log file. roll transaction. @ com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdatabaseerror(sqlserverexception.java:216) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.getnextresult(sqlserverstatement.java:1515) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement.doexecutepreparedstatementbatch(sqlserverpreparedstatement.java:1299) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement$prepstmtbatchexeccmd.doexecute(sqlserverpreparedstatement.java:1209) @ com.microsoft.sqlserver.jdbc.tdscommand.execute(iobuffer.java:5696) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.executecommand(sqlserverconnection.java:1715) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executecommand(sqlserverstatement.java:180) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executestatement(sqlserverstatement.java:155) @ com.microsoft.sqlserver.jdbc.sqlserverpreparedstatement.executebatch(sqlserverpreparedstatement.java:1173) @ org.apache.sqoop.mapreduce.asyncsqloutputformat$asyncsqlexecthread.run(asyncsqloutputformat.java:231)
Comments
Post a Comment