/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/describe_table.q

# · text · 19 lines · 16 code · 3 blank · 0 comment · 0 complexity · 6691a16104a5f6c2193eb3bb2d515c13 MD5 · raw file 

    

  1. describe srcpart;
    2. 

  2. describe srcpart.key;
    3. 

  3. describe srcpart PARTITION(ds='2008-04-08', hr='12');
    4. 

  4. 

  5. describe extended srcpart;
    6. 

  6. describe extended srcpart.key;
    7. 

  7. describe extended srcpart PARTITION(ds='2008-04-08', hr='12');
    8. 

  8. 

  9. describe formatted srcpart;
    10. 

  10. describe formatted srcpart.key;
    11. 

  11. describe formatted srcpart PARTITION(ds='2008-04-08', hr='12');
    12. 

  12. 

  13. create table srcpart_serdeprops like srcpart;
    14. 

  14. alter table srcpart_serdeprops set serdeproperties('xyz'='0');
    15. 

  15. alter table srcpart_serdeprops set serdeproperties('pqrs'='1');
    16. 

  16. alter table srcpart_serdeprops set serdeproperties('abcd'='2');
    17. 

  17. alter table srcpart_serdeprops set serdeproperties('A1234'='3');
    18. 

  18. describe formatted srcpart_serdeprops;
    19. 

  19. drop table srcpart_serdeprops;
    20.