Saving all output to "!!{outputDirectory}!!/avro_change_schema.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/avro_change_schema.q
>>>  -- verify that we can update the table properties
>>>  CREATE TABLE avro2 
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": "first_schema", 
"type": "record", 
"fields": [ 
{ "name":"string1", "type":"string" }, 
{ "name":"string2", "type":"string" } 
] }');
No rows affected 
>>>  
>>>  DESCRIBE avro2;
'col_name','data_type','comment'
'string1','string','from deserializer'
'string2','string','from deserializer'
2 rows selected 
>>>  
>>>  ALTER TABLE avro2 SET TBLPROPERTIES ('avro.schema.literal'='{ "namespace": "org.apache.hive", 
"name": "second_schema", 
"type": "record", 
"fields": [ 
{ "name":"int1", "type":"int" }, 
{ "name":"float1", "type":"float" }, 
{ "name":"double1", "type":"double" } 
] }');
No rows affected 
>>>  
>>>  DESCRIBE avro2;
'col_name','data_type','comment'
'int1','int','from deserializer'
'float1','float','from deserializer'
'double1','double','from deserializer'
3 rows selected 
>>>  
>>>  !record