Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
bigdata:hivemetastore [2018/05/25 13:05]
127.0.0.1 external edit
bigdata:hivemetastore [2018/11/19 19:26] (current)
preb [HIVE METASTORE]
Line 48: Line 48:
 </​code>​ </​code>​
  
 +=== Search location of all tables ===
 +<​code>​
 +/*
 + * Extract location of each table
 + */
 +SELECT TBLS.TBL_NAME,​SDS.LOCATION
 +FROM SDS,TBLS
 +WHERE TBLS.SD_ID = SDS.SD_ID;
 +</​code>​
  • bigdata/hivemetastore.txt
  • Last modified: 2018/11/19 19:26
  • by preb