Hi    Just fire the below command in the terminal  if you are using QuickStartVm   sudo su   Quickstart Sudo ... View more

@medloh Any time mate .  ... View more

@NguyenBac I am glad that it worked  ... View more

@AlexMulti   Deletes can only be performed on tables that support ACID. More over your tables's file format should be ORC Below are the properties that needs to be set .   hive.support.concurrency true (default is false) hive.enforce.bucketing true (default is false) (Not required as of Hive 2.0) hive.exec.dynamic.partition.mode nonstrict (default is strict) Also i would suggest you to take look into  kudu.    Reference https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-NewConfigurationParametersforTransactions ... View more

check if there are multiple supervisor runining on that host using the below command .    ps aux |grep supervisor   if so  you will  need to kill it and then start the cloudera -scm  agent and kick off the hive metastore .  ... View more

Based on the response , I would go for Parquet with splittable Snappy . more over  Hive - default Compression is DeflateCodec Impala - default Compression is Snappy    i would put a link of my response to a similar post in the community that will give you little more info.     http://community.cloudera.com/t5/Batch-SQL-Apache-Hive/Parquet-table-snappy-compressed-by-default/m-p/51914#M1822   please let me know if that helps ... View more

Can anyone please suggest me where should I start?   Well I started it off with Apache Hadoop binary on Ubuntu  Then moved on to manual installation of Cloudera hadoop  finally landed in Cloudera manager .  to start with I would suggest you from apache hadoop manual deployment and then side by side Cloudera Quickstart to explore other cdh eco systesm like hive , impala , many more .    Do you recommend taking training courses with cloud era in order to eventually build an career in this area?    That totally depends on to be frank to bring up a cluster i mean single node cluster :)) it took me a good20 days because i am from Java J2ee development guy had to roll up my sleeves to  vmare , Linux Os then hang on to hadoop. Cloudera community is pretty active so we have your back on any troubleshooting  :)))                                             Welcome  to the  Cloudera Hadoop  Community .    ... View more

did you try runining the query in the hive shell or beeline ?  was your hiveserver2 up and runining during the query execution time ?    you may want to take peek in this current settings in your cluster    hive.server2.session.check.interval hive.server2.idle.operation.timeout hive.server2.idle.session.timeout ... View more

are you looking for fast compression or decompression ?  are you looking for disk space consumption ?   ... View more