Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-15106

Hive 1.0 returning only date part of a timestamp

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.0.0
    • None
    • Hive
    • None
    • Amazon EMR 4.8

    Description

      Hive 1.0 is returning only the date part of a timestamp.

      This is working properly on Hive 0.13 and Hive 2.1.0

      Reproduction steps:

      In Hive 0.13 and Hive 2.1.0:
      hive> create table test_order as select timestamp('2016-11-07 09:29:59.000000') as event_ts;
      hive> select * from test_order;
      2016-11-07 09:29:59

      hive> select event_ts from test_order where CAST(event_ts AS DATE ) = CAST('2016-11-07' AS DATE );
      2016-11-07 09:29:59

      But, in Hive 1.0:
      hive> select event_ts from test_order where CAST(event_ts AS DATE ) = CAST('2016-11-07' AS DATE );
      2016-11-07 00:00:00

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            hvivani Hernan Vivani

            Dates

              Created:
              Updated:

              Slack

                Issue deployment