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

Add more constraints on showing partitions

    XMLWordPrintableJSON

Details

    Description

      When we showing partitions of a table with thousands of partitions,  all the partitions will be returned and it's not easy to catch the specified one from them, this make showing partitions hard to use. We can add where/limit/order by constraints to show partitions like:

       show partitions table_name [partition_specs] where partition_key >= value order by partition_key desc limit n;

       

      Attachments

        1. HIVE-22458.branch-1.patch
          55 kB
          Zhihua Deng
        2. HIVE-22458.branch-1.02.patch
          57 kB
          Zhihua Deng
        3. HIVE-22458.patch
          61 kB
          Zhihua Deng
        4. HIVE-22458.2.patch
          306 kB
          Zhihua Deng
        5. HIVE-22458.3.patch
          311 kB
          Zhihua Deng
        6. HIVE-22458.4.patch
          320 kB
          Zhihua Deng
        7. HIVE-22458.5.patch
          320 kB
          Zhihua Deng
        8. HIVE-22458.6.patch
          415 kB
          Zhihua Deng

        Issue Links

          Activity

            People

              dengzh Zhihua Deng
              dengzh Zhihua Deng
              Votes:
              0 Vote for this issue
              Watchers:
              3 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 - 1h 20m
                  1h 20m