Hi, Has anyone got some benchmarks on comparing Hive with Google Cloud Platform (GCP) BiqQuery (BQ)?
>From my experience experience BQ supports both Avro and ORC file types. There is no support for compressed ORC or AVRO. So if you want to load a Hive table into BQ, you will need to create a table with no compression. In short you need to perform ETL to move a Hive table to BQ. On the other hand BQ seems to support all analytical functions available in Hive so your queries should run without any modification in BQ. On the other hand Dataproc tool in GCP also supports Hive (though I have not tried it myself). So the question is are there any advantages taking a Hive table into BQ itself? Thanks, 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.
