how to alter location where database is point to

Hi All, Can somebody help me with alter command to change the hive database location in hive 11 I have tried below commands both are failing alter database set location ''; alter database location ''; Thanks in advance Hussain Jamali This message and the informat

RE: Hadoop and Hive Performance Tuning

I think first thing you should consider to change file format RC to ORC With Newer Hadoop version ORC file format is very optimized format compared to RC. It will give you far better compression and performance than RC file. Go for Zlib compression + ORC file format. Regards, Hussain Jamali