Re: read-only mode for hive

2016-03-08 Thread Sabarish Sasidharan
Does views solve your purpose? Regards Sab On 09-Mar-2016 6:23 am, "PG User" wrote: > Yes, putting any database or any table to read-only mode will serve my > purpose. > > On Tue, Mar 8, 2016 at 3:15 PM, Mich Talebzadeh > wrote: > >> Hive much like MSSQL or SAP ASE has multiple databases. Are y

Re: Hive footprint

2016-04-20 Thread Sabarish Sasidharan
HBase is very good for direct key based lookups. And when you want to do scans for a range of keys (data is sorted by keys) Whereas Hive is not good for seeks (needle in haystack problem). You can optimize with ORCs, stripes, sorting etc. But still it is a needle in a haystack problem. Apache Kyl