ADS and Beeline using MapR Impala Port 21050 connection name type comment (null) (null) # Detailed Table Information (null) (null) Database: default (null) Owner: (null) CreateTime: Tue Apr 05 12:49:45 PDT 2016 (null) LastAccessTime: UNKNOWN (null) Protect Mode: None (null) Retention: 0 (null) Location: maprfs:/user/hive/warehouse/t1 (null) Table Type: MANAGED_TABLE (null) Table Parameters: (null) (null) transient_lastDdlTime 1459885785 (null) (null) # Storage Information (null) (null) SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe (null) InputFormat: org.apache.hadoop.mapred.TextInputFormat (null) OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat (null) Compressed: No (null) Num Buckets: 0 (null) Bucket Columns: [] (null) Sort Columns: [] (null) Beeline using H2 Port 10000 connection +-------------------------------+-------------------------------------------------------------+-----------------------+--+ | col_name | data_type | comment | +-------------------------------+-------------------------------------------------------------+-----------------------+--+ | # col_name | data_type | comment | | | NULL | NULL | | c1 | string | | | c2 | timestamp | | | c3 | smallint | | | c4 | float | | | | NULL | NULL | | # Detailed Table Information | NULL | NULL | | Database: | default | NULL | | Owner: | | NULL | | CreateTime: | Tue Apr 05 12:49:45 PDT 2016 | NULL | | LastAccessTime: | UNKNOWN | NULL | | Protect Mode: | None | NULL | | Retention: | 0 | NULL | | Location: | maprfs:/user/hive/warehouse/t1 | NULL | | Table Type: | MANAGED_TABLE | NULL | | Table Parameters: | NULL | NULL | | | transient_lastDdlTime | 1459885785 | | | NULL | NULL | | # Storage Information | NULL | NULL | | SerDe Library: | org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe | NULL | | InputFormat: | org.apache.hadoop.mapred.TextInputFormat | NULL | | OutputFormat: | org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat | NULL | | Compressed: | No | NULL | | Num Buckets: | 0 | NULL | | Bucket Columns: | [] | NULL | | Sort Columns: | [] | NULL | +-------------------------------+-------------------------------------------------------------+-----------------------+--+