[Errno 104] Connection reset by peer

Lab Support
#1

how reset all data completely and then how create new tables and data and load data from exteernal source and how add data like csv file and get data load in tables and it shows error 104 every time

#2

Hi, Sandeep.

  1. Creating the tables(external and managed) is already given in Hive tutorial.

  2. You can load the data as follows :-
    LOAD DATA INPATH ‘hdfs:///user/your_username/u.data’ overwrite into table u_data;

  3. To load the files to CloudXLab environment you can use scp client https://cloudxlab.com/faq/20/how-should-i-upload-files-from-my-local-machine-to-cloudxlab
    If you are getting error kindly share the screenshots of the same.

All the best!

#3

hue is not working
u r reply that to upload but data i already upload it

Screenshot (43)
Screenshot (43)1920×1080 180 KB

but it not working in excute not giving answer when i use this first but after that is not working
today is last of submission of project this lab is not working

#4

Hi, Sandeep.

I understood your problem, there is Nginx error in Hue.
I recommend you to use Hive terminal from the web-console for all your Hive task and you will be able to complete it.

All the best!

#5

please give me idea that i m send u pic in which how load in terminal and access it from it

#6

You just have to go to web-console.

  1. type hive.
  2. show databases; and search for your database that you created.
  3. use your_database; and do CRUD operations.
  4. for loading from external source use winscp or scp client refer this :- https://cloudxlab.com/faq/20/how-should-i-upload-files-from-my-local-machine-to-cloudxlab

All the best!