Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to export hive table to JSON file format as output

Highlighted

How to export hive table to JSON file format as output

New Contributor

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.