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.

Unable to sort by date column with timestamp data type

Unable to sort by date column with timestamp data type

New Contributor

Hi, may I know how do we sort by date column with timestamp data type in impala? I tried order by but it doesn't work. Your help is very much appreciated.

1 REPLY 1

Re: Unable to sort by date column with timestamp data type

Master Collaborator

You sort by timestamp the same way as any other column. If you provide more information about what you are doing, including SQL, table definitions and what you expect to happen vs what actually happened, we may be able to point you in the right direction.