@saisvk    Please read my previous response one more time . I told you that you dont have to mention column when you use LIKE and also it will create table with NO DATA hence you have to insert .   Now your query should be like this . copy paste it in your terminal .    The below will only CREATE  - Does not LOAD DATA . ( LIKE )  CREATE TABLE maxminonly2013 LIKE maxmin2013 STORED AS RCFILE LOCATION '/user/hive/warehouse/d2013.db/'   The below will create and LOAD the data  (AS)  CREATE TABLE maxminonly2013 STORED AS TEXTFILE LOCATION '/user/hive/warehouse/dissertation.db/' AS SELECT * FROM maxmin2013 ;   please let me know if that helps .  ... View more

if you are able to bring up the cloudera manager then it is a good sign there is no such thing as default eithe you use cloudera manager express edition or enterprise edition , both comes with the preconfigured resource threshold precentage that it will check to see if the nodes are runining with adequate resouce , since you are accomdating it with a little RAM it is showing the health as bad . You have to manually go to the each servicec in the Cloudera manager UI change the resource threshold accordingly for example hdfs disk space , namenode heap size,secondarynamenode heap size , cloudera management's database free space , event server heap size etc . this is really going to be pain in the back Or as suggested you can manual manage the CDH by totally avoiding the cloudera manager and deploy Single Linux Node in Pseudo-distributed Mode .  ... View more