https://community.cloudera.com/t5/Archives-of-Support-Questions/Export-Hive-Tables-Using-Putty/m-p/131966#M51724 <P>My table in hive have more than 80 million records. Now we have to make a back-up of it. Do you have a best practice to do this? i tried to use my data flow in nifi but it is hanging. Now im trying PUTTY (hive -e 'select * from your_Table' | sed 's/[\t]/,/g' &gt; /home/yourfile.csv), nothing happened when i run it. Im using sandbox hdp 2.5.</P><P>Thanks! </P> Tue, 17 Jan 2017 17:47:47 GMT regie_canada 2017-01-17T17:47:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Export-Hive-Tables-Using-Putty/m-p/131966#M51724 <P>My table in hive have more than 80 million records. Now we have to make a back-up of it. Do you have a best practice to do this? i tried to use my data flow in nifi but it is hanging. Now im trying PUTTY (hive -e 'select * from your_Table' | sed 's/[\t]/,/g' &gt; /home/yourfile.csv), nothing happened when i run it. Im using sandbox hdp 2.5.</P><P>Thanks! </P> Tue, 17 Jan 2017 17:47:47 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Export-Hive-Tables-Using-Putty/m-p/131966#M51724 regie_canada 2017-01-17T17:47:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Export-Hive-Tables-Using-Putty/m-p/131967#M51725 <A rel="user" href="https://community.cloudera.com/users/14397/regiecanada.html" nodeid="14397">@regie canada</A><P>You can use hive export table command. (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport#LanguageManualImportExport-ExportSyntax) </P> Tue, 17 Jan 2017 17:51:29 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Export-Hive-Tables-Using-Putty/m-p/131967#M51725 sandyy006 2017-01-17T17:51:29Z