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

show partitions when using schema does not work

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 0.12.0
    • Fix Version/s: None
    • Component/s: CLI
    • Labels:
      None

      Description

      SHOW PARTITIONS command when used with the schema option throws an error "ParseException line 1:24 missing EOF". User would need to every time go into the schema to see the partitions.

      Details of the issue/hive commands:
      ----------------------------------------------

      hive (kh_work)> show partitions closeout.pos_retaileritem;
      FAILED: ParseException line 1:24 missing EOF at '.' near 'closeout'

      hive (kh_work)> use closeout;
      OK
      Time taken: 0.0060 seconds
      hive (closeout)> show partitions pos_retaileritem;
      OK
      partition
      pk_business=tec/pk_data_source=pos/pk_frequency=cat/pk_data_state=c07132
      Time taken: 0.183 seconds, Fetched: 1 row(s)
      hive (closeout)>

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                khussain Khaja Hussain
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: