question Re: Hive export encrypted table in Support Questions https://community.cloudera.com/t5/Support-Questions/Hive-export-encrypted-table/m-p/292663#M216238 <P>Should have mentioned: this is my export command (beeline)</P><P>0: jdbc:hive2://myhiveserver,d&gt; export table mydatabase.mytable to '/warehouse/tablespace/hive-export/username/tablename';</P><P>&nbsp;</P><P>The HDFS encryption zone is on /warehouse/tablespace</P> Thu, 26 Mar 2020 18:47:47 GMT Eric_Richardson 2020-03-26T18:47:47Z Hive export encrypted table https://community.cloudera.com/t5/Support-Questions/Hive-export-encrypted-table/m-p/292662#M216237 <P>Trying to export a hive table from an encrypted HDFS.</P><P>The distcp portion of the export fails. Every file segment throws one of these...</P><LI-CODE lang="markup">2020-03-26 14:36:17,124 ERROR [IPC Server handler 25 on 37768] org.apache.hadoop.mapred.TaskAttemptListenerImpl: Task: attempt_1585157114387_3676_m_000000_0 - exited : java.io.IOException: File copy failed: hdfs://myserver/warehouse/tablespace/tmp/hive/e18e8f44-9d0e-4f10-9490-2703bbdc84e9/_tmp_space.db/7579e917-2de7-4923-887a-df739f3a98e1/000006_0 --&gt; hdfs://myserver/warehouse/tablespace/hive-export/username/tablename/data/000006_0 at org.apache.hadoop.tools.mapred.CopyMapper.copyFileWithRetry(CopyMapper.java:263) at org.apache.hadoop.tools.mapred.CopyMapper.map(CopyMapper.java:220) at org.apache.hadoop.tools.mapred.CopyMapper.map(CopyMapper.java:48) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:799) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168) Caused by: java.io.IOException: Couldn't run retriable-command: Copying hdfs://myserver/warehouse/tablespace/tmp/hive/e18e8f44-9d0e-4f10-9490-2703bbdc84e9/_tmp_space.db/7579e917-2de7-4923-887a-df739f3a98e1/000006_0 to hdfs://myserver/warehouse/tablespace/hive-export/username/tablename/data/000006_0 at org.apache.hadoop.tools.util.RetriableCommand.execute(RetriableCommand.java:101) at org.apache.hadoop.tools.mapred.CopyMapper.copyFileWithRetry(CopyMapper.java:259) ... 10 more Caused by: java.io.IOException: Checksum mismatch between hdfs://myserver/warehouse/tablespace/tmp/hive/e18e8f44-9d0e-4f10-9490-2703bbdc84e9/_tmp_space.db/7579e917-2de7-4923-887a-df739f3a98e1/000006_0 and hdfs://myserver/warehouse/tablespace/hive-export/username/tablename/data/.distcp.tmp.attempt_1585157114387_3676_m_000000_0. at org.apache.hadoop.tools.mapred.RetriableFileCopyCommand.compareCheckSums(RetriableFileCopyCommand.java:261) at org.apache.hadoop.tools.mapred.RetriableFileCopyCommand.doCopy(RetriableFileCopyCommand.java:153) at org.apache.hadoop.tools.mapred.RetriableFileCopyCommand.doExecute(RetriableFileCopyCommand.java:115) at org.apache.hadoop.tools.util.RetriableCommand.execute(RetriableCommand.java:87) ... 11 more</LI-CODE><P>&nbsp;</P> Fri, 16 Sep 2022 14:36:11 GMT https://community.cloudera.com/t5/Support-Questions/Hive-export-encrypted-table/m-p/292662#M216237 Eric_Richardson 2022-09-16T14:36:11Z Re: Hive export encrypted table https://community.cloudera.com/t5/Support-Questions/Hive-export-encrypted-table/m-p/292663#M216238 <P>Should have mentioned: this is my export command (beeline)</P><P>0: jdbc:hive2://myhiveserver,d&gt; export table mydatabase.mytable to '/warehouse/tablespace/hive-export/username/tablename';</P><P>&nbsp;</P><P>The HDFS encryption zone is on /warehouse/tablespace</P> Thu, 26 Mar 2020 18:47:47 GMT https://community.cloudera.com/t5/Support-Questions/Hive-export-encrypted-table/m-p/292663#M216238 Eric_Richardson 2020-03-26T18:47:47Z Re: Hive export encrypted table https://community.cloudera.com/t5/Support-Questions/Hive-export-encrypted-table/m-p/292668#M216243 <P>hive &gt; set distcp.options.skipcrccheck=;</P><P>hive &gt; export ...blah, blah blah;</P><P>success!</P><P>Thanks to Cloudera Support, M. Green.&nbsp; Super fast!</P> Thu, 26 Mar 2020 20:20:21 GMT https://community.cloudera.com/t5/Support-Questions/Hive-export-encrypted-table/m-p/292668#M216243 Eric_Richardson 2020-03-26T20:20:21Z