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 hive query which supports to apply the timezone value which defined in additionalParameter in request to specific time column in hive query. The change should be reusable for other engines.
adding new hive 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 hive query which supports to apply the timezone value which defined in additionalParameter in request to specific time column in hive query. The change should be reusable for other engines.
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