| --! qt:dataset:src1 |
| CREATE TABLE datatype_stats_n0( |
| t TINYINT, |
| s SMALLINT, |
| i INT, |
| b BIGINT, |
| f FLOAT, |
| d DOUBLE, |
| dem DECIMAL, --default decimal (10,0) |
| ts TIMESTAMP, |
| dt DATE, |
| str STRING, |
| v VARCHAR(12), |
| c CHAR(5), |
| bl BOOLEAN, |
| bin BINARY); |
| |
| INSERT INTO datatype_stats_n0 values(1, 2, 44, 455, 45454.3, 454.6564, 2354, '2012-01-01 01:02:02', '2011-12-31', 'update_statisticr', 'statr', 'hivd', 'false', 'bin'); |
| INSERT INTO datatype_stats_n0 values(2, 3, 45, 456, 45454.4, 454.6565, 2355, '2012-01-01 01:02:03', '2012-01-01', 'update_statistics', 'stats', 'hive', 'true', 'bin'); |
| INSERT INTO datatype_stats_n0 values(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); |
| |
| DESC FORMATTED datatype_stats_n0 s; |
| DESC FORMATTED datatype_stats_n0 i; |
| DESC FORMATTED datatype_stats_n0 b; |
| DESC FORMATTED datatype_stats_n0 f; |
| DESC FORMATTED datatype_stats_n0 d; |
| DESC FORMATTED datatype_stats_n0 dem; |
| DESC FORMATTED datatype_stats_n0 ts; |
| DESC FORMATTED datatype_stats_n0 dt; |
| DESC FORMATTED datatype_stats_n0 str; |
| DESC FORMATTED datatype_stats_n0 v; |
| DESC FORMATTED datatype_stats_n0 c; |
| DESC FORMATTED datatype_stats_n0 bl; |
| DESC FORMATTED datatype_stats_n0 bin; |
| DESC FORMATTED datatype_stats_n0 t; |
| DESC FORMATTED datatype_stats_n0; |
| DESC datatype_stats_n0 s; |
| DESC datatype_stats_n0 i; |
| DESC datatype_stats_n0 b; |
| DESC datatype_stats_n0 f; |
| DESC datatype_stats_n0 d; |
| DESC datatype_stats_n0 dem; |
| DESC datatype_stats_n0 ts; |
| DESC datatype_stats_n0 dt; |
| DESC datatype_stats_n0 str; |
| DESC datatype_stats_n0 v; |
| DESC datatype_stats_n0 c; |
| DESC datatype_stats_n0 bl; |
| DESC datatype_stats_n0 bin; |
| DESC datatype_stats_n0; |
| |
| SET hive.ddl.output.format=json; |
| |
| DESC FORMATTED datatype_stats_n0 s; |
| DESC FORMATTED datatype_stats_n0 i; |
| DESC FORMATTED datatype_stats_n0 b; |
| DESC FORMATTED datatype_stats_n0 f; |
| DESC FORMATTED datatype_stats_n0 d; |
| DESC FORMATTED datatype_stats_n0 dem; |
| DESC FORMATTED datatype_stats_n0 ts; |
| DESC FORMATTED datatype_stats_n0 dt; |
| DESC FORMATTED datatype_stats_n0 str; |
| DESC FORMATTED datatype_stats_n0 v; |
| DESC FORMATTED datatype_stats_n0 c; |
| DESC FORMATTED datatype_stats_n0 bl; |
| DESC FORMATTED datatype_stats_n0 bin; |
| DESC FORMATTED datatype_stats_n0 t; |
| DESC FORMATTED datatype_stats_n0; |
| DESC datatype_stats_n0 s; |
| DESC datatype_stats_n0 i; |
| DESC datatype_stats_n0 b; |
| DESC datatype_stats_n0 f; |
| DESC datatype_stats_n0 d; |
| DESC datatype_stats_n0 dem; |
| DESC datatype_stats_n0 ts; |
| DESC datatype_stats_n0 dt; |
| DESC datatype_stats_n0 str; |
| DESC datatype_stats_n0 v; |
| DESC datatype_stats_n0 c; |
| DESC datatype_stats_n0 bl; |
| DESC datatype_stats_n0 bin; |
| DESC datatype_stats_n0; |