Support Questions

Find answers, ask questions, and share your expertise

How to export hive table to JSON file format as output

avatar
Contributor

I want to export hive table to Json file for doing analysis

2 REPLIES 2

avatar

If your hive table is in ORC format, you can give this a try; https://orc.apache.org/docs/java-tools.html

avatar

Assign to @Jonathan Sneep, You can also create a new temp table with JSON file format and use "insert into json table form existing table;" Post creating the new table, the files can be read form hdfs in json format.