Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Getting weird output for DATE & TIMESTAMP data type columns while selecting data from PARQUET file in DRILL.

Getting weird output for DATE & TIMESTAMP data type columns while selecting data from PARQUET file in DRILL.

New Contributor

Hi,

I am getting unexpected output while selecting DATE & TIMESTAMP data type columns from PARQUET file in DRILL.

But while selecting the same record from HIVE table getting expected output.(From HIVE console & DRILL console)

I am not able to find root cause of the issue.Experts please share your experience on the same.

Thanks and regards, Asif Akram

1 REPLY 1
Highlighted

Re: Getting weird output for DATE & TIMESTAMP data type columns while selecting data from PARQUET file in DRILL.

Mentor

Review the timezone and locale settings for Drill.

Don't have an account?
Coming from Hortonworks? Activate your account here