Query is not running in Mysql server in itversity - labs

mysql

#1

Hi All,
I am using big data labs for preparing the certification. Since yesterday am facing the issues in my sql server.
I can able to connect my sql server & databases using the below command in putty.
mysql -u retail_dba -h nn01.itversity.com -p
but when am running the query in databases am facing the below issues. Could you pls do the need ful.

No connection. Trying to reconnect…
Connection id: 1
Current database: retail_import

ERROR 2013 (HY000): Lost connection to MySQL server during query


#2

@cmahendran To connect Mysql refer below link


#3

Hi, I was not able to start spark-shell in ITVERSITY LAB as i was thrown with the error port number already in use.How to resolve this issue?
I used
spark-shell --master yarn --packages com.databricks:spark-avro_2.10:2.0.1


#4

You can try again with below command, let us know if you are able to launch the shell

spark-shell --master yarn --packages com.databricks:spark-avro_2.10:2.0.1 --conf spark.ui.port=12336