https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210473#M172415 Fri, 03 Aug 2018 22:00:12 GMT chiranjeevivenk 2018-08-03T22:00:12Z https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210473#M172415 Fri, 03 Aug 2018 22:00:12 GMT https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210473#M172415 chiranjeevivenk 2018-08-03T22:00:12Z https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210474#M172416 <P>You can use the below command which generates the tsv file: </P><PRE>hive -e 'select * from table' &gt; output.tsv</PRE> Fri, 03 Aug 2018 22:09:34 GMT https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210474#M172416 sandyy006 2018-08-03T22:09:34Z https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210475#M172417 <P>My file should be in the extension of .xslx <A rel="user" href="https://community.cloudera.com/users/10159/snemuri.html" nodeid="10159">@Sandeep Nemuri</A></P> Fri, 03 Aug 2018 22:12:24 GMT https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210475#M172417 chiranjeevivenk 2018-08-03T22:12:24Z https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210476#M172418 <P>I don't think we have a way to write a .xslx file, However you can write csv or tsv which are compatible with excel. </P> Fri, 03 Aug 2018 22:17:02 GMT https://community.cloudera.com/t5/Support-Questions/How-to-create-excel-file-from-Hive-query-output/m-p/210476#M172418 sandyy006 2018-08-03T22:17:02Z