Setting quota will work. Queries will fail with quota errors.  ... View more

I don't think that it (Cloudera ODBC driver doesn't support insert) is true. By defining table as transcational table, you can insert data.   CREATE TABLE insert_test( column1 string, column2 string) clustered by (column1) into 3 buckets stored as orcfile TBLPROPERTIES ('transactional'='true');   insert into table efvci_lnd_edw_dev.insert_test values('1', 'One'); insert into table efvci_lnd_edw_dev.insert_test values('2', 'Two');   Thanks, Chirag Patel   ... View more

passing hive-site.xml to the workflow resolves this. ... View more

I can't see the relationship between yarn.scheduler.minimum-allocation-mb and the error is reported. According to hive documentation, yarn.scheduler.minimum-allocation-mb is the "container memory minimum". But in this case, the container is running of memory, so it makes sense to increase the "maximum-allocation" instead.   Anyway, as it was answered, increasing "mapreduce.map.memory.mb" and "mapreduce.reduce.memory.mb" must work, as those parameters controls how much memory is used by the map-reduce task is run by Hive. ... View more

Hi,   After clearing all the caches and Force quitting the Chrome, executing the following command works fine with Mac Chrome:   /Applications/Google\ Chrome.app/Contents/MacOS/Google\ Chrome --auth-server-whitelist="*.example.com"   The difference in this command and the one in the documentation is that, here the command has "*.example.com" and in the documentation it is "hostname/domain"   Hope that helps.   Regards, Thina ... View more

I use the below trick in shell scripts for known queries that don't have an impact if killed.    I call the impala-shell from bash/cron using the below line   timeout 600 impala-shell -i $IMPALA_ADDRESS -q "compute stats hive_db.table_name;"    The all important part is "timeout 600" which will end the session after 10 mins.  ... View more

Any luck on the solution?  ... View more

Thanks for sharing, it's helpful. ... View more

Thank you so munch！ I change the group of '/tmp/logs' to hadoop , and  restart the JobHistoryServer role, everything being OK.        So happy ! ... View more

How can i login to a master node of cluster via terminal ??? I looked for it every where but it made me more confuse. I appreciate your help.    Thanks, Roshan  ... View more