Comparing Google Cloud Platform BiqQuery with Hive

2019-01-11 Thread Mich Talebzadeh
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

FW: Questions concerning from_utc_timestamp

2019-01-11 Thread jens.kloeker
Hi everybody, I have got some questions concerning from_utc_timestamp date function by using hive: 1.I have a datetime value which is meant to be in UTC time. By using from_utc_timestamp I want to get the correct unix timestamp out of this date. I would think, that I don't have to define