https://pinot.apache.org/ logo
#general
Title
# general
l

Lakshmanan Velusamy

03/03/2022, 9:56 PM
Hi Community, Can the timezone argument for DATETRUNC come from an another column in the table?
Checked the datatruc transform function code, doesn't seem to support column as argument for timezone filed (expects optional timezone string)
m

Mayank

03/03/2022, 10:24 PM
Yeah. But seems like a good feature to have. Mind filing an issue?
🙌 1
k

Kartik Khare

03/04/2022, 6:12 AM
We already support that via Scalar function. The issue is our DateTruncTransformFunction class is overriding the Scalar functions present in DateTimeFunctions.class. We just need to disable the duplicate/deprecated versions.
l

Lakshmanan Velusamy

03/04/2022, 7:27 PM
@User could you elaborate with a sample query ?
🙏 1