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 i install impala shell in windows machine?

Can i install impala shell in windows machine?

New Contributor

Hi 

 

Can any one help me how to install impala shell in windows machine

5 REPLIES 5

Re: Can i install impala shell in windows machine?

Cloudera Employee
Highlighted

Re: Can i install impala shell in windows machine?

New Contributor

Thanks for quick responce

Re: Can i install impala shell in windows machine?

New Contributor

Yes, but you'd have to use Docker Toolbox.

 

Click DOCKER CLI, then type in:

docker run -t -i lancope/impala-shell

 

Should open up a shell prompt:

connect <your impala server>:21000;
show databases;
use <database>;
show tables;

Re: Can i install impala shell in windows machine?

New Contributor

Thanks. When I try to spawn the image and run it.

 

I am getting this error: "Error connecting: TTransportException, Could not connect to :21000"

 

docker@default:~$ docker run -t -i lancope/impala-shell
Starting Impala Shell without Kerberos authentication
Error connecting: TTransportException, Could not connect to 0a55686a0ca4:21000

Welcome to the Impala shell. Press TAB twice to see a list of available commands.
Copyright (c) 2012 Cloudera, Inc. All rights reserved.
(Shell build version: Impala Shell v1.4.0-cdh4-INTERNAL (08fa346) built on Mon Jul 14 15:52:52 PDT 2014) [Not connected] &gt; connect localhost:21000 &gt; ; Error connecting: TTransportException, Could not connect to localhost:21000

 

Do you know why I am getting this error?

 

/Kashan

Re: Can i install impala shell in windows machine?

New Contributor

If you like to connect Impala from Windows then use # SQuirreL SQL Client and Impala jdbc drivers. This works very well. 

 

Thanks 

-Bharat

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