@Per We run full transactional enabled Hive metadb on an Oracle DB.
I don't have statistics now but will collect from AWR reports no problem. @Jorn, The primary reason Oracle was chosen is because the company has global licenses for Oracle + MSSQL + SAP and they are classified as Enterprise Grade databases. None of MySQL and others are classified as such so they cannot be deployed in production. Besides, for us to have Hive metadata on Oracle makes sense as our infrastructure does all the support, HA etc for it and they have trained DBAs to look after it 24x7. Admittedly we are now relying on HDFS itself plus Hbase as well for persistent storage. So the situation might change. HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 24 October 2016 at 06:46, Per Ullberg <per.ullb...@klarna.com> wrote: > I thought the main gain was to get ACID on Hive performant enough. > > @Mich: Do you run with ACID-enabled tables? How many Create/Update/Deletes > do you do per second? > > best regards > /Pelle > > On Mon, Oct 24, 2016 at 7:39 AM, Jörn Franke <jornfra...@gmail.com> wrote: > >> I think the main gain is more about getting rid of a dedicated database >> including maintenance and potential license cost. >> For really large clusters and a lot of users this might be even more >> beneficial. You can avoid clustering the database etc. >> >> On 24 Oct 2016, at 00:46, Mich Talebzadeh <mich.talebza...@gmail.com> >> wrote: >> >> >> A while back there was some notes on having Hive metastore on Hbase as >> opposed to conventional RDBMSs >> >> I am currently involved with some hefty work with Hbase and Phoenix for >> batch ingestion of trade data. As long as you define your Hbase table >> through Phoenix and with secondary Phoenix indexes on Hbase, the speed is >> impressive. >> >> I am not sure how much having Hbase as Hive metastore is going to add to >> Hive performance. We use Oracle 12c as Hive metastore and the Hive >> database/schema is built on solid state disks. Never had any issues with >> lock and concurrency. >> >> Therefore I am not sure what one is going to gain by having Hbase as the >> Hive metastore? I trust that we can still use our existing schemas on >> Oracle. >> >> HTH >> >> >> >> Dr Mich Talebzadeh >> >> >> >> LinkedIn * >> https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >> >> >> >> http://talebzadehmich.wordpress.com >> >> >> *Disclaimer:* Use it at your own risk. Any and all responsibility for >> any loss, damage or destruction of data or any other property which may >> arise from relying on this email's technical content is explicitly >> disclaimed. The author will in no case be liable for any monetary damages >> arising from such loss, damage or destruction. >> >> >> >> > > > -- > > *Per Ullberg* > Data Vault Tech Lead > Odin Uppsala > +46 701612693 <+46+701612693> > > Klarna AB (publ) > Sveavägen 46, 111 34 Stockholm > Tel: +46 8 120 120 00 <+46812012000> > Reg no: 556737-0431 > klarna.com > >
