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

CREATE TYPE and use the TYPE in CREATE TABLE

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      From Namit:

      create type addata (adid int, location string);
      
      CREATE TABLE abc (
      pageid INT,
      ads addata,
      userid INT
      );
      

      That way the same type can be used across multiple tables - you can select from one and insert into another etc.
      Type will be a first class citizen, it can be passed to udfs, can be described etc

        Attachments

        1. hive-779-2009-08-27.patch
          27 kB
          He Yongqiang
        2. hive-779-2009-08-21.patch
          25 kB
          He Yongqiang

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                zshao Zheng Shao
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated: