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

HadoopHelp — Wed, 04 Mar 2020 13:34:15 GMT

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

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

StevenOD — Tue, 03 Mar 2020 15:26:11 GMT

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

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

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

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