Not able to access Hive for SQL


#1

Getting this error whenever I run SQL query in Hive.

Could not connect to cxln2.c.thelab-240901.internal:10000 (code THRIFTTRANSPORT): TTransportException(‘Could not connect to cxln2.c.thelab-240901.internal:10000’,)

Please help in this.


#2

Hi, It looks like to be a connections error, kindly check the correct Host name/IP address and the path for Mysql.

The updated IP address is :-
mysql -h ip-10.142.1.2
Mysql : NHkkP876rp

Path for MySql :-
/data/jars/mysql-connector-java-5.1.36-bin.jar

All the best!


#3

Thanks for the help.

But now I am getting this error.
504 Gateway Time-out 504 Gateway Time-out nginx/1.12.2

what should I do now, I have to complete the course within a month.


#4

Please use Hive terminal, you should be able to do your task,
It worked for me.
All the best.