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

show partitions when using schema does not work

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • 0.12.0
    • None
    • CLI
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: