Skip to content

Instantly share code, notes, and snippets.

@andrewstevenson

andrewstevenson/hive-desc.sql

Created September 11, 2016 18:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andrewstevenson/7fbd0bd6c0731d1521eb81d08cdbf598 to your computer and use it in GitHub Desktop.
Save andrewstevenson/7fbd0bd6c0731d1521eb81d08cdbf598 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hive-desc.sql
hive> desc fromatted categories;
# col_name data_type comment
category_id int
category_department_id int
category_name string
my_int2 int
my_int1 int
# Detailed Table Information
Database: retail_db
Owner: null
CreateTime: Thu Apr 02 08:20:00 UTC 2015
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: hdfs://sandbox.hortonworks.com:8020/data/scrubbed/retail_db/categories
Table Type: EXTERNAL_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE false
EXTERNAL TRUE
avro.schema.url hdfs://sandbox.hortonworks.com:8020/data/scrubbed/retail_db/categories/.metadata/schemas/4.avsc
kite.compression.type snappy
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment