Support Questions
Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Advanced Search
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.

Labels:
asifakram1990
New Contributor

Created ‎09-30-2016 06:32 AM

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

Reply
443 Views
0 Kudos
1 REPLY 1
Highlighted

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

aervits
Mentor

Created ‎10-02-2016 12:37 AM

Review the timezone and locale settings for Drill.

Reply
90 Views
0 Kudos
Don't have an account?
Register
Coming from Hortonworks? Activate your account here