search

airbnb / airpal

Web UI for PrestoDB.
http://airbnb.github.io/airpal
Apache License 2.0
2.76k stars 458 forks source link

Persto 0.157.1 in EMR is facing issues regarding client side encryption AWS KMS Master Key #212

Open gauravrathi92 opened 7 years ago

gauravrathi92 commented 7 years ago

I am getting NULL values in all the rows in result set in presto client in using s3 partitions.

  1. Data is stored in the S3 in the encripted form(client side encription) using AWS KMS master key.
  2. EMR Hive is able to decrypt the S3 data on select query.
  3. We have done below listed settings in the Presto.hive.properties but it is returning null values(screenshot is attached) against all the rows on making select [query.]

hive properties prestoqueryresult

Your help will be really appreciable. Gaurav

swaranga commented 7 years ago

Could be an issue with Presto and not Airpal. May be related: https://github.com/prestodb/presto/issues/7186