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

List partition keys, sort and cluster keys

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.1.2
    • None
    • Database/Schema
    • None

    Description

      Is it possible to list the partition, cluster, and sort keys per table from Hive?

      I have to implement this in a Hive modeler called DbSchema.

      Also, I would ask why this fails: CREATE TABLE sample2 ( id int primary key, firstname varchar(100) , lastname varchar(100) ).

      If I look in this documentation it says it should work: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL

      Is another docu I should check?

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            dprutean Pruteanu Dragos
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: