Access to MYSQL and HIVE

Hi Team,
I am new to labs. i wanted to connect to MYSQL and Hive, can you please share credentials for the same and please let me know where can i find sample datasets

@Anil_Sunkara,

All the datasets are present under data folder in your home dir. (cd data).

for connecting to mysql use
mysql -u retail_user -h ms.itversity.com -p
give itversity as password .

for lauching hive CLI type hive from your home dir. after getting in, create your own database and use it.

thanks shubham,

i didn’t find folder data. please refer the attached screen shot

okay,

there is public folder in hdfs location(hadoop fs -ls /public) where all the data are present.
by using copyToLocal you can copy the data in your local home dir, after that use copyFromLocal to copy data in your hdfs location