My question is in the title. In addition, hive CLI
is not possible for my situation, with only the hive
editor in the hue
platform.
The reason why xlsx is not used is because only 30,000 records can be exported by xlsx.
Refer the below question. Lot of options are suggested by users.