I was also facing same issue like you. Then I had followed these steps  and it worked for me :   set hive.support.concurrency=true; set hive.enforce.bucketing=true; set hive.exec.dynamic.partition.mode=nonstrict; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; set hive.compactor.initiator.on=true; set hive.compactor.worker.threads=2;   Then I changed added hive.in.test property=true in the hive-site.xml file in /usr/lib/hive location.   After that I restarted the Hive from HUE and then ran the update command and it worked for me. ... View more

what did you do? did you have to edit /etc/resolv in on the individual instances? ... View more

Please check the link https://hortonworks.com/blog/update-hive-tables-easy-way/ hope this helps. ... View more

command  :   sudo -u hdfs hdfs  fsck -list-corruptfileblocks   For deleting corrupted files :   sudo -u hdfs hdfs  fsck / -delete     Thanks. ... View more

While you create external table  - mention the LOCATION ' '  ( i,e The default location of Hive table is overwritten by using LOCATION ) Then load data from HDFS using  ' inpath ' - if you drop the table it will only remove the pointer from the hdfs and will not delete the data in the hdfs.    CREATE EXTERNAL TABLE text1 ( wban INT, date STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘,’ LOCATION ‘ /hive/data/text1’; LOAD DATA INPATH ‘hdfs:/data/2000.txt’ INTO TABLE TABLE_NAME ; ... View more

Dear Romainr,   Please  share the HUE 4 User guide.   Thanks, Syam. ... View more