gistfile1.txt

[nightly6x-2.gce.cloudera.com:21000] default> create table mixedtable (x tinyint) partitioned by (y int) stored as parquetfile;
Query: create table mixedtable (x tinyint) partitioned by (y int) stored as parquetfile
+-------------------------+
| summary                 |
+-------------------------+
| Table has been created. |
+-------------------------+
Fetched 1 row(s) in 0.43s
[nightly6x-2.gce.cloudera.com:21000] default> describe mixedtable;
Query: describe mixedtable
+------+---------+---------+
| name | type    | comment |
+------+---------+---------+
| x    | tinyint |         |
| y    | int     |         |
+------+---------+---------+
Fetched 2 row(s) in 3.99s
[nightly6x-2.gce.cloudera.com:21000] default> alter table mixedtable add partition (y=1);
Query: alter table mixedtable add partition (y=1)
+--------------------------------------------+
| summary                                    |
+--------------------------------------------+
| New partition has been added to the table. |
+--------------------------------------------+
Fetched 1 row(s) in 0.07s
[nightly6x-2.gce.cloudera.com:21000] default> alter table mixedtable partition (y=1) set fileformat avro;
Query: alter table mixedtable partition (y=1) set fileformat avro
+-------------------------+
| summary                 |
+-------------------------+
| Updated 1 partition(s). |
+-------------------------+
Fetched 1 row(s) in 0.19s
[nightly6x-2.gce.cloudera.com:21000] default> describe mixedtable;
Query: describe mixedtable
+------+---------+---------+
| name | type    | comment |
+------+---------+---------+
| x    | tinyint |         |
| y    | int     |         |
+------+---------+---------+
Fetched 2 row(s) in 0.00s
[nightly6x-2.gce.cloudera.com:21000] default> refresh mixedtable;
Query: refresh mixedtable
Query submitted at: 2018-07-11 21:27:41 (Coordinator: https://nightly6x-2.gce.cloudera.com:25000)
Query progress can be monitored at: https://nightly6x-2.gce.cloudera.com:25000/query_plan?query_id=9047a3cacf2305e5:ffbf61ee00000000
Fetched 0 row(s) in 0.10s
[nightly6x-2.gce.cloudera.com:21000] default> describe mixedtable;
Query: describe mixedtable
+------+------+-------------------+
| name | type | comment           |
+------+------+-------------------+
| x    | int  | from deserializer |
| y    | int  |                   |
+------+------+-------------------+
Fetched 2 row(s) in 0.00s