Permission denied creating table population_census

KrrishChheda — Mon, 17 Aug 2020 19:20:01 GMT

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

Re: Permission denied creating table population_census

Cynthia_sas — Thu, 20 Aug 2020 15:31:08 GMT

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

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.

topic Re: Permission denied creating table population_census in SAS Academy for Data Science

Permission denied creating table population_census

Re: Permission denied creating table population_census