Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.