ql/src/test/queries/clientpositive/describe_syntax.q

--! qt:dataset:part

CREATE DATABASE db1;
CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING);

use db1;

ALTER TABLE t1 ADD PARTITION (ds='3', part='3');
ALTER TABLE t1 ADD PARTITION (ds='4', part='4');
ALTER TABLE t1 ADD PARTITION (ds='4', part='5');

-- describe table
DESCRIBE t1;
DESCRIBE EXTENDED t1;
DESCRIBE FORMATTED t1;

-- describe database.table
DESCRIBE db1.t1;
DESCRIBE EXTENDED db1.t1;
DESCRIBE FORMATTED db1.t1;

-- describe table column
DESCRIBE t1 key1;
DESCRIBE EXTENDED t1 key1;
DESCRIBE FORMATTED t1 key1;

-- describe database.tabe column
DESCRIBE db1.t1 key1;
DESCRIBE EXTENDED db1.t1 key1;
DESCRIBE FORMATTED db1.t1 key1;

-- describe table column
DESCRIBE t1 key1;
DESCRIBE EXTENDED t1 key1;
DESCRIBE FORMATTED t1 key1;

-- describe table partition
DESCRIBE t1 PARTITION(ds='4', part='5');
DESCRIBE EXTENDED t1 PARTITION(ds='4', part='5');
DESCRIBE FORMATTED t1 PARTITION(ds='4', part='5');

-- describe database.table partition
DESCRIBE db1.t1 PARTITION(ds='4', part='5');
DESCRIBE EXTENDED db1.t1 PARTITION(ds='4', part='5');
DESCRIBE FORMATTED db1.t1 PARTITION(ds='4', part='5');