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.

Impala and D3JS

Solved Go to solution

Impala and D3JS

New Contributor

Hi,

 

We plan to visualize data stored in HDFS using Impala and D3JS. We need help on how to integrate the two. Please give me some suggestions.

 

Thanks

Sanjay

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Impala and D3JS

New Contributor

Hi straightdrive -

 

This really depends on the web framework powering this. The short answer is that you'll visualize data using D3JS the same way you would if the data came from MySQL, or Postgres, etc. Your client will make API calls to your web server, which will in return make SQL calls to Impala,MySQL,Postgres,etc, and then send the data back to the client (JSON, XML, etc) so that it can be visualized. The client (D3JS) will typically never talk to the database (Impala) directly. 

 

If you're writing your web server in Java, you'll want to look at JDBC. If you're writing it in C#/ASP.NET, or something that can talk ODBC, then you should use the Impala ODBC driver. If you want to use Python or Ruby, take a look out on Github...there's some libraries to help you out there too:

 

Impyla

Impala-ruby

 

 

5 REPLIES 5

Re: Impala and D3JS

New Contributor

Hi straightdrive -

 

This really depends on the web framework powering this. The short answer is that you'll visualize data using D3JS the same way you would if the data came from MySQL, or Postgres, etc. Your client will make API calls to your web server, which will in return make SQL calls to Impala,MySQL,Postgres,etc, and then send the data back to the client (JSON, XML, etc) so that it can be visualized. The client (D3JS) will typically never talk to the database (Impala) directly. 

 

If you're writing your web server in Java, you'll want to look at JDBC. If you're writing it in C#/ASP.NET, or something that can talk ODBC, then you should use the Impala ODBC driver. If you want to use Python or Ruby, take a look out on Github...there's some libraries to help you out there too:

 

Impyla

Impala-ruby

 

 

Re: Impala and D3JS

Cloudera Employee

That is one of the exercises that we do in the new Designing and Building Big Data Applications course. Check the link for locations and dates for the class.

Highlighted

Re: Impala and D3JS

New Contributor

Thanks Jesse. That answers my question. BTW, the link to the class is broken.

Re: Impala and D3JS

Master Collaborator

I fixed the links in Ricky's message.

Re: Impala and D3JS

New Contributor

HI, 

The link is not working. Can someone please send me the updated link on working Impala with D3 JS. 

 

Thanks,

Phani. 

Don't have an account?
Coming from Hortonworks? Activate your account here