Support Questions

Find answers, ask questions, and share your expertise

Export Hive Tables Using Putty

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' > /home/yourfile.csv), nothing happened when i run it. Im using sandbox hdp 2.5.

Thanks!

1 ACCEPTED SOLUTION

@regie canada

You can use hive export table command. (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport#LanguageManualImportExport-ExportSyntax)

View solution in original post

1 REPLY 1

@regie canada

You can use hive export table command. (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport#LanguageManualImportExport-ExportSyntax)

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.