Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Not A Problem
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Activity

      Gelesh created issue -
      Hide
      Gelesh added a comment -

      Query TBLS with TbleName you could get SD_ID,
      Query COLUMNS_V2 (or COLUNMS if hive version is less than 0.9) with SD_ID you could fetch out

      1) COMMENT VARCHAR(256) PARAM_KEY VARCHAR(256)
      /// could be null
      2) COLUMN_NAME VARCHAR(128)
      /// Name of the co;unm
      3)TYPE_NAME VARCHAR(4000)
      /// TYPE_NAME
      4)INTEGER_IDX INT(11)
      /// the zero based index of the feild in the file, which hive reffers

      1. this schema is as per hive-0.9 meta store, COLUMNS_V2 table,
      Show
      Gelesh added a comment - Query TBLS with TbleName you could get SD_ID, Query COLUMNS_V2 (or COLUNMS if hive version is less than 0.9) with SD_ID you could fetch out 1) COMMENT VARCHAR(256) PARAM_KEY VARCHAR(256) /// could be null 2) COLUMN_NAME VARCHAR(128) /// Name of the co;unm 3)TYPE_NAME VARCHAR(4000) /// TYPE_NAME 4)INTEGER_IDX INT(11) /// the zero based index of the feild in the file, which hive reffers this schema is as per hive-0.9 meta store, COLUMNS_V2 table,
      Hide
      Gelesh added a comment -

      Could some body help to connect this hive query over CLI with the MetaStore DB ?

      Show
      Gelesh added a comment - Could some body help to connect this hive query over CLI with the MetaStore DB ?
      Gelesh made changes -
      Field Original Value New Value
      Status Open [ 1 ] Resolved [ 5 ]
      Resolution Not A Problem [ 8 ]
      Transition Time In Source Status Execution Times Last Executer Last Execution Date
      Open Open Resolved Resolved
      3d 13h 43m 1 Gelesh 01/Jul/13 06:08

        People

        • Assignee:
          Unassigned
          Reporter:
          Gelesh
        • Votes:
          0 Vote for this issue
          Watchers:
          1 Start watching this issue

          Dates

          • Created:
            Updated:
            Resolved:

            Development