BookmarkSubscribeRSS Feed
🔒 This topic is locked. We are no longer accepting replies to this topic. Need further help? Please sign in and ask a new question.
KrrishChheda
Calcite | Level 5
CREATE EXTERNAL TABLE IF NOT EXISTS population_census
   (county string, population int)
   ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
   LOCATION '/user/student/dihdm/population_census';

Wrote the above code

When Press entered Error And Permision Denied Is Writen in terminal

 

when saw in Hue Only Population_census directory was created and not the table

 

Also I have to manually change the url from server04.demo.sas.com:8889 to 8888

1 REPLY 1
Cynthia_sas
SAS Super FREQ

Hi:
Sorry for missing this on Monday. Can you clarify exactly where you're working in the SAS Academy classes so we can ask the instructors to try to replicate your issue:
=== ===
Platform: SAS Academy for Data Science
Format: e-learning
Class title:
Lesson title:
Practice or demo title:
Step where your experience deviates from video or instructions:
Browser used:
Connection type: (wired or wireless)
Reservation type: (Fresh or Saved image)
=== ===
Did you look at the Troubleshooting document? If you are in the SAS and Hadoop class in the Data Curation level, you'll find it here:

Cynthia_sas_0-1597929842549.png

 

Cynthia

 

Also, just another piece of information -- I don't know whether this is your issue or not. However, if you work from a SAVED image in the Virtual Lab, you might be seeing an error that says something like "Name node is in safe mode." This happens because when the SAVED image starts up, you will always start the session in safe mode. Please use the information in the Troubleshooting Issues with the Virtual Lab document to restart the Hadoop cluster. This should resolve the issue and takes about 15 minutes.  You'll find the document when you first enter the SAS and Hadoop e-learning lab, as shown above. If you don't want to restart the cluster, you can make a new reservation for a FRESH image.