Support Questions
Find answers, ask questions, and share your expertise

How to export hive table to JSON file format as output

How to export hive table to JSON file format as output

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

2 REPLIES 2

Re: How to export hive table to JSON file format as output

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

Re: How to export hive table to JSON file format as output

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.