Reply
New Contributor
Posts: 3
Registered: ‎10-20-2015

Can Impala read json file stored in HDFS?

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

New Contributor
Posts: 1
Registered: ‎12-01-2017

Re: Can Impala read json file stored in HDFS?

[ Edited ]

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

 

 

Champion
Posts: 601
Registered: ‎05-16-2016

Re: Can Impala read json file stored in HDFS?

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

Announcements