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.

Query output not exporting properly to csv

Highlighted

Query output not exporting properly to csv

New Contributor

I'm trying to export a query output (containing 1.5 million rows and 1 column) into a csv. 

For some reason,it wrote only 72k rows once and 91 k after that. I re-ran it the next day and it dumped all the records perfectly.

What could be the possible reason behind this?

2 REPLIES 2

Re: Query output not exporting properly to csv

Community Manager

@Kritidoneria Could you provide some additional details on how you are running the query including any components used? It would be useful to members looking to help you determine the cause of the issue. 



Cy Jervis, Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:
Community Guidelines
How to use the forum
Highlighted

Re: Query output not exporting properly to csv

New Contributor
Hi,
Thanks for the revert.Due to data privacy issues I can't share the log,but
the issue is as described above.
Hive -e select* from somet+ing> a.csv.
A.csv didn't contain the complete output.
##-- Please type your reply above this line -##
Don't have an account?
Coming from Hortonworks? Activate your account here