Skip to main content
HadoopHelp
Gold ⭐️
March 3, 2020
Solved

how can we verify wheather a table is tempory or not using hive command/terminal/hue

Dear all.

 

I created one hive temp tables as below -

but how can we identified that tables is temp tables or not.

 

 

 

CREATE temporary TABLE IF NOT EXISTS employee ( eid int, name String,
salary String, destination String)
COMMENT ‘Employee details’
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘\t’
LINES TERMINATED BY ‘\n’
STORED AS TEXTFILE;

 

 

i used below command to described but not getting any info-

 

 

describe formatted employee;
col_name 	data_type 	comment
1 # col_name data_type comment
2 NULL NULL
3 eid int
4 name string
5 salary string
6 destination string
7 NULL NULL
8 # Detailed Table Information NULL NULL
9 Database: h7 NULL
10 OwnerType: USER NULL
11 Owner: **** NULL
12 CreateTime: Tue Mar 03 08:50:28 EST 2020 NULL
13 LastAccessTime: UNKNOWN NULL
14 Retention: 0 NULL
15 Location: hdfs:*********** NULL
16 Table Type: MANAGED_TABLE NULL
17 Table Parameters: NULL NULL
18 comment Employee details
19 NULL NULL
20 # Storage Information NULL NULL
21 SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe NULL
22 InputFormat: org.apache.hadoop.mapred.TextInputFormat NULL
23 OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat NULL
24 Compressed: No NULL
25 Num Buckets: -1 NULL
26 Bucket Columns: [] NULL
27 Sort Columns: [] NULL
28 Storage Desc Params: NULL NULL
29 field.delim \t
30 line.delim \n

 

 

Thanks

HadoopHelp

StevenOD
StevenODAnswer
Platinum ⭐️
March 3, 2020

Hi @HadoopHelp 

 

Try:

 

describe extended employee;

 

If you use the extended keyword you should get some detailed table information out that includes the following flag:

 

temporary:true

 

Regards,

Steve

1 reply

StevenOD
Platinum ⭐️
StevenODAnswer
Platinum ⭐️
March 3, 2020

Hi @HadoopHelp 

 

Try:

 

describe extended employee;

 

If you use the extended keyword you should get some detailed table information out that includes the following flag:

 

temporary:true

 

Regards,

Steve

Translate