Hive and Scala is not working - reported long back noone is addressing

[ranjith_kumar]

@CloublabxTeam,

If you people don’t support infrastructure issues then who is accountable? Feel waste of money to subscribe to cloudlabx.

[sgiri]

These commands are working fine.

There is something wrong in your account. Looks like Java path issue - may be because of installation of some package.

Will it be okay if we delete the current account and recreate it?

[sgiri]

I have moved all of your files into a folder “existing_data”. Now, hive and scala are working.

[vishnupriya_suthanth]

HI

I am going through Hive- Hands On topic, In that i have come across below issues,

1. Hue is not working but as per your advice started working on web console.

2.Not able to identify default database as per the video.

3. Not able to identify NYSE_File and load the same.

4. I have followed the instructions posted by satyajit but am getting error(NYSE table not found) as i attached in my previous mails.

Steps mentioned by satyajit in comments section(slide 4 - Hive hands on)

[sgiri]

Hi Vishnupriya,

Could you post as separate post instead of on existing thread?

[satyajit_das]

Hi, Vishnupriya.

1. The database named default is present in hive.
   a) login to hive and type show databases; and search for the default database.
   b) use default;
   c) show tables.
2. The error is self-explanatory that you have not created the nyse table in the hive database.

Below are the steps to copy the NYSE_daily to local and load it to the table in hive database.

Steps to load the nyse file :-

1. hadoop fs -copyToLocal /data/NYSE_daily

2. hive> use your_hive_databasename; # database name

3. hive> load data local inpath ‘NYSE_daily’ overwrite into table nyse;

4. hive> SELECT symbol1, AVG(price_open) AS avg_price FROM nyse GROUP BY symbol1;

5. hive> insert overwrite local directory ‘/home/your_cloudxlab_username/onlycmc’

   select * from nyse where symbol1 = ‘CMC’; # this will move to the local directory.

6. hive> insert overwrite directory ‘onlycmc’ select * from nyse where symbol1=‘CMC’ # this will overwrite the nyse table

7. go to local user> ls

8. local user > cd onlycmc

9. local user> cat 000000_0

It worked for me so I am posting to you.

Kindly keep in mind the below while doing anything.

1. Though my steps are right but don’t follow the steps blindly and do some Engineering as some directory have been updated and the paths too.
2. Try to understand the error( they are your best friends in your work).
3. Try to understand the instructions again if you are getting some error.
4. If something (path of the directories) or data is not available, kindly use Hue to see the data and its path.
5. Sometimes you have to go beyond the boundaries of what you see and put some extra efforts.
6. Try to send the screenshots of the error you faced.

Now I think you will be able to do it.

Also feel free to refer to the screenshots for your perusal.

All the best!