hive.snippets 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. snippet tbl
  2. create table ${1:table_name} (
  3. ${2:columns}
  4. );
  5. snippet s*
  6. select * from ${1:table_name}
  7. snippet showcolumns
  8. SHOW COLUMNS (FROM|IN) table_name [(FROM|IN) db_name];
  9. snippet showcompactions
  10. SHOW COMPACTIONS;
  11. snippet showconf
  12. SHOW CONF <configuration_name>;
  13. snippet showcreate
  14. SHOW CREATE TABLE ([db_name.]table_name|view_name);
  15. snippet showcurrentroles
  16. SHOW CURRENT ROLES;
  17. snippet showdatabases
  18. SHOW (DATABASES|SCHEMAS) [LIKE 'identifier_with_wildcards'];
  19. snippet showdblocks
  20. SHOW LOCKS (DATABASE|SCHEMA) database_name;
  21. snippet showfunctions
  22. SHOW FUNCTIONS "a.*";
  23. snippet showgrant
  24. SHOW GRANT;
  25. snippet showindex
  26. SHOW [FORMATTED] (INDEX|INDEXES) ON ${1:table_with_index} [(FROM|IN) ${2:db_name}];
  27. snippet showlocks
  28. SHOW LOCKS ${1:table_name} PARTITION (${2:partition_spec}) EXTENDED;
  29. snippet showpartitions
  30. SHOW PARTITIONS ${1:table_name} PARTITION(ds='2010-03-03', hr='12');
  31. snippet showprincipals
  32. SHOW PRINCIPALS;
  33. snippet showrolegrant
  34. SHOW ROLE GRANT;
  35. snippet showroles
  36. SHOW ROLES;
  37. snippet showtableextended
  38. SHOW TABLE EXTENDED [IN|FROM ${1:database_name}] LIKE 'identifier_with_wildcards' [PARTITION(${2:partition_spec})];
  39. snippet showtables
  40. SHOW TABLES [IN ${1:database_name}] ['identifier_with_wildcards'];
  41. snippet showtblproperties
  42. SHOW TBLPROPERTIES ${1:table_name};
  43. snippet showtransactions
  44. SHOW TRANSACTIONS;