CREATE TABLE otto.mw_page_change0 LIKE event.mediawiki_page_change_v1;

hive (otto)> describe mw_page_change0;
OK
col_name	data_type	comment
_schema             	string              	A URI identifying the JSONSchema for this event. This should match an schema's $id in a schema repository. E.g. /schema/title/1.0.0
changelog_kind      	string              	The kind of this event in a changelog. This is used to map the event to an action in a data store.
comment             	string              	The comment left by the user that performed this change. Same as revision.comment on edits.
created_redirect_page	struct<is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string,revision_count:bigint>	Page entity that was created at the old title during a page move. This is only set for page move events. Note that the created_redirect_page will also have its own associated page create event.
dt                  	string              	ISO-8601 formatted timestamp of when the event occurred/was generated in UTC), AKA 'event time'. This is different than meta.dt, which is used as the time the system received this event.
meta                	struct<domain:string,dt:string,id:string,request_id:string,stream:string,uri:string>
page                	struct<is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string,revision_count:bigint,redirect_page_link:struct<interwiki_prefix:string,is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string>>	Fields for MediaWiki page entity.
page_change_kind    	string              	The origin kind of the change to this page as viewed by MediaWiki.
performer           	struct<edit_count:bigint,groups:array<string>,is_bot:boolean,is_system:boolean,is_temp:boolean,registration_dt:string,user_id:bigint,user_text:string>	Represents the MediaWiki actor that made this change. If this change is an edit, this will be the same as revision.editor.
prior_state         	struct<page:struct<is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string,revision_count:bigint>,revision:struct<comment:string,content_slots:map<string,struct<content_body:string,content_format:string,content_model:string,content_sha1:string,content_size:bigint,origin_rev_id:bigint,slot_role:string>>,editor:struct<edit_count:bigint,groups:array<string>,is_bot:boolean,is_system:boolean,is_temp:boolean,registration_dt:string,user_id:bigint,user_text:string>,is_comment_visible:boolean,is_content_visible:boolean,is_editor_visible:boolean,is_minor_edit:boolean,rev_dt:string,rev_id:bigint,rev_parent_id:bigint,rev_sha1:string,rev_size:bigint>>	Prior state of this page before this event. Fields are only present if their values have changed.
revision            	struct<comment:string,content_slots:map<string,struct<content_body:string,content_format:string,content_model:string,content_sha1:string,content_size:bigint,origin_rev_id:bigint,slot_role:string>>,editor:struct<edit_count:bigint,groups:array<string>,is_bot:boolean,is_system:boolean,is_temp:boolean,registration_dt:string,user_id:bigint,user_text:string>,is_comment_visible:boolean,is_content_visible:boolean,is_editor_visible:boolean,is_minor_edit:boolean,rev_dt:string,rev_id:bigint,rev_parent_id:bigint,rev_sha1:string,rev_size:bigint>	Fields for MediaWiki revision entity.
wiki_id             	string              	The wiki ID, which is usually the same as the MediaWiki database name. E.g. enwiki, metawiki, etc.
is_wmf_domain       	boolean
normalized_host     	struct<project_class:string,project:string,qualifiers:array<string>,tld:string,project_family:string>
datacenter          	string
year                	bigint
month               	bigint
day                 	bigint
hour                	bigint

# Partition Information
# col_name            	data_type           	comment

datacenter          	string
year                	bigint
month               	bigint
day                 	bigint
hour                	bigint
Time taken: 0.313 seconds, Fetched: 28 row(s)
hive (otto)> describe mediawiki_page_change_v1;
FAILED: SemanticException [Error 10001]: Table not found mediawiki_page_change_v1
hive (otto)> describe event.mediawiki_page_change_v1;
OK
col_name	data_type	comment
_schema             	string
changelog_kind      	string
comment             	string
created_redirect_page	struct<is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string,revision_count:bigint>
dt                  	string
meta                	struct<domain:string,dt:string,id:string,request_id:string,stream:string,uri:string>
page                	struct<is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string,revision_count:bigint,redirect_page_link:struct<interwiki_prefix:string,is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string>>
page_change_kind    	string
performer           	struct<edit_count:bigint,groups:array<string>,is_bot:boolean,is_system:boolean,is_temp:boolean,registration_dt:string,user_id:bigint,user_text:string>
prior_state         	struct<page:struct<is_redirect:boolean,namespace_id:bigint,page_id:bigint,page_title:string,revision_count:bigint>,revision:struct<comment:string,content_slots:map<string,struct<content_body:string,content_format:string,content_model:string,content_sha1:string,content_size:bigint,origin_rev_id:bigint,slot_role:string>>,editor:struct<edit_count:bigint,groups:array<string>,is_bot:boolean,is_system:boolean,is_temp:boolean,registration_dt:string,user_id:bigint,user_text:string>,is_comment_visible:boolean,is_content_visible:boolean,is_editor_visible:boolean,is_minor_edit:boolean,rev_dt:string,rev_id:bigint,rev_parent_id:bigint,rev_sha1:string,rev_size:bigint>>
revision            	struct<comment:string,content_slots:map<string,struct<content_body:string,content_format:string,content_model:string,content_sha1:string,content_size:bigint,origin_rev_id:bigint,slot_role:string>>,editor:struct<edit_count:bigint,groups:array<string>,is_bot:boolean,is_system:boolean,is_temp:boolean,registration_dt:string,user_id:bigint,user_text:string>,is_comment_visible:boolean,is_content_visible:boolean,is_editor_visible:boolean,is_minor_edit:boolean,rev_dt:string,rev_id:bigint,rev_parent_id:bigint,rev_sha1:string,rev_size:bigint>
wiki_id             	string
is_wmf_domain       	boolean
normalized_host     	struct<project_class:string,project:string,qualifiers:array<string>,tld:string,project_family:string>

...

CREATE TABLE otto.nested1 (c1 struct<f1:int COMMENT "f1 comment"> COMMENT "c1 comment") STORED AS PARQUET;

hive (otto)> describe otto.nested1;
OK
col_name	data_type	comment
c1                  	struct<f1:int>      	c1 comment