Saving all output to "!!{outputDirectory}!!/avro_schema_literal.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/avro_schema_literal.q >>> CREATE TABLE avro1 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' TBLPROPERTIES ('avro.schema.literal'='{ "namespace": "org.apache.hive", "name": "big_old_schema", "type": "record", "fields": [ { "name":"string1", "type":"string" }, { "name":"int1", "type":"int" }, { "name":"tinyint1", "type":"int" }, { "name":"smallint1", "type":"int" }, { "name":"bigint1", "type":"long" }, { "name":"boolean1", "type":"boolean" }, { "name":"float1", "type":"float" }, { "name":"double1", "type":"double" }, { "name":"list1", "type":{"type":"array", "items":"string"} }, { "name":"map1", "type":{"type":"map", "values":"int"} }, { "name":"struct1", "type":{"type":"record", "name":"struct1_name", "fields": [ { "name":"sInt", "type":"int" }, { "name":"sBoolean", "type":"boolean" }, { "name":"sString", "type":"string" } ] } }, { "name":"union1", "type":["float", "boolean", "string"] }, { "name":"enum1", "type":{"type":"enum", "name":"enum1_values", "symbols":["BLUE","RED", "GREEN"]} }, { "name":"nullableint", "type":["int", "null"] }, { "name":"bytes1", "type":"bytes" }, { "name":"fixed1", "type":{"type":"fixed", "name":"threebytes", "size":3} } ] }'); No rows affected >>> >>> DESCRIBE avro1; 'col_name','data_type','comment' 'string1','string','from deserializer' 'int1','int','from deserializer' 'tinyint1','int','from deserializer' 'smallint1','int','from deserializer' 'bigint1','bigint','from deserializer' 'boolean1','boolean','from deserializer' 'float1','float','from deserializer' 'double1','double','from deserializer' 'list1','array','from deserializer' 'map1','map','from deserializer' 'struct1','struct','from deserializer' 'union1','uniontype','from deserializer' 'enum1','string','from deserializer' 'nullableint','int','from deserializer' 'bytes1','array','from deserializer' 'fixed1','array','from deserializer' 16 rows selected >>> >>> !record