Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Export Hive Tables Using Putty

Solved Go to solution

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

Accepted Solutions
Highlighted

Re: Export Hive Tables Using Putty

@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
Highlighted

Re: Export Hive Tables Using Putty

@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

Don't have an account?
Coming from Hortonworks? Activate your account here