Hi Community, Can the timezone argument for DATETR...
# generall
Lakshmanan Velusamy
03/03/2022, 9:56 PMHi Community, Can the timezone argument for DATETRUNC come from an another column in the table?
Lakshmanan Velusamy
03/03/2022, 10:01 PMChecked 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 AMWe 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 ?
Lakshmanan Velusamy
03/04/2022, 7:27 PM@User filed this ticket : https://github.com/apache/pinot/issues/8299
🙏 1