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.

Can Impala read json file stored in HDFS?

Highlighted

Can Impala read json file stored in HDFS?

New Contributor

Hi all,

I read a recent article that announces that "Cloudera recently added support for JSON in Impala, which shows you how the state-of-the-art is evolving."

 

So I searched something about it, but I found nothing. So, the question is: is now possible read json files from Impala?

 

Here the link to the article:

http://www.datanami.com/2016/01/13/picking-the-right-sql-on-hadoop-tool-for-the-job/?replytocom=2482...

 

Thanks

 

Michele Pinto

2 REPLIES 2

Re: Can Impala read json file stored in HDFS?

New Contributor

Good Day!

You may use the free, open-source Apache Drill if you feel Cloudera's Impala doesn't query

your JSON sources to your satisfaction.

 

Source:

https://drill.apache.org

https://en.wikipedia.org/w/index.php?title=Apache_Drill&action=edit&section=2

(Just be careful as to not accidentally edit this field - just for reference purposes only okay?)

 

 

Scott McNeil

Big Data Manipulator

 

 

Re: Can Impala read json file stored in HDFS?

Champion

I am not aware but you can write your custom udf and load it to impala based on your use case