I confirm that this contribution is made under the terms of the license found in the root directory of this repository's source tree and that I have the authority necessary to make this contribution on behalf of its copyright owner.
Changes Summary
Add a feature for Presto query which supports to apply the timezone value which defined in additionalParameter in request to specific time column in hive query. This change is based on the changes in https://github.com/yahoo/maha/pull/1050.
(this change will make presto query has similar behavior as hive query to apply request specified timezone)
adding new presto derived expression TIME_FORMAT_WITH_TIMEZONE
using an internal function in TIME_FORMAT_WITH_TIMEZONE to dynamic render is when generating query for a request
added test cases
if not setting eg. "additionalParameters": {"TimeZone": "America/New_York"}, should use 'UTC' as default timezone
if set "additionalParameters": {"TimeZone": "America/New_York"}, should apply it in select columns part, filter part (if applicable) and group by part
above should be working for dimension column in both dimension table and fact table
if source column of the derived expression is a derived column, should be rendered correctly
I confirm that this contribution is made under the terms of the license found in the root directory of this repository's source tree and that I have the authority necessary to make this contribution on behalf of its copyright owner.
Changes Summary
Add a feature for Presto query which supports to apply the timezone value which defined in additionalParameter in request to specific time column in hive query. This change is based on the changes in https://github.com/yahoo/maha/pull/1050. (this change will make presto query has similar behavior as hive query to apply request specified timezone)
TIME_FORMAT_WITH_TIMEZONETIME_FORMAT_WITH_TIMEZONEto dynamic render is when generating query for a request"additionalParameters": {"TimeZone": "America/New_York"}, should use 'UTC' as default timezone"additionalParameters": {"TimeZone": "America/New_York"}, should apply it in select columns part, filter part (if applicable) and group by partmvn clean installfor maha is passed on local