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

Show columns shouldn't sort output columns unless explicitly mentioned.

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

Details

    Description

      CREATE TABLE foo_n7(c INT, a INT, b INT);

      show columns in foo_n7;

      // current output
      a
      b 
      c
      // expected
      c
      a 
      b

      HIVE-18373 changed the original behaviour to sorted output.

      Suggesting to provide an optional keyword sorted to sort the show columns output

      eg., 

      show sorted columns in foo_n7;
      a
      b 
      c
      show columns in foo_n7
      c
      a 
      b

       

      Attachments

        Activity

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

          People

            nareshpr Naresh P R Assign to me
            nareshpr Naresh P R
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0h
              0h
              Logged:
              Time Spent - 0.5h
              0.5h

              Slack

                Issue deployment