Support Questions
Find answers, ask questions, and share your expertise

table file format

Contributor

Hello

 

How can I get table's file format in impala db.

descrive [formatted] tableName does not help us or I could not identify in formatted output

 

By the way what is "table type" in formatted output. What are the possible values for this property ?

 

Thanks

msuluhan

 

2 REPLIES 2

Contributor

show table stats <tableName>

 

+----------+--------+----------+--------------+-------------------+---------+-------------------+
| #Rows    | #Files | Size     | Bytes Cached | Cache Replication | Format  | Incremental stats |
+----------+--------+----------+--------------+-------------------+---------+-------------------+
| 13852342 | 3      | 230.80MB | NOT CACHED   | NOT CACHED        | PARQUET | false             |
+----------+--------+----------+--------------+-------------------+---------+-------------------+

 

Contributor