| ==== |
| ---- QUERY |
| create table __text_write (i int, s string, d double); |
| ==== |
| ---- QUERY |
| SET COMPRESSION_CODEC=NONE; |
| insert into __text_write select 0, "a", 1.1; |
| ==== |
| ---- QUERY |
| SET COMPRESSION_CODEC=GZIP; |
| insert into __text_write values (3, "d", 4.4); |
| ---- CATCH |
| Writing to compressed text table is not supported. |
| ==== |
| ---- QUERY |
| select * from __text_write; |
| ---- RESULTS |
| 0,'a',1.1 |
| ---- TYPES |
| INT,STRING,DOUBLE |
| ==== |
| ---- QUERY |
| create table __avro_write (i int, s string, d double) |
| stored as AVRO |
| TBLPROPERTIES ('avro.schema.literal'='{ |
| "name": "my_record", |
| "type": "record", |
| "fields": [ |
| {"name":"i", "type":["int", "null"]}, |
| {"name":"s", "type":["string", "null"]}, |
| {"name":"d", "type":["double", "null"]}]}'); |
| ==== |
| ---- QUERY |
| insert into __avro_write select 1, "b", 2.2; |
| ---- CATCH |
| Writing to table format AVRO is not supported. |
| ==== |
| ---- QUERY |
| create table __seq_write (i int, s string, d double) |
| stored as SEQUENCEFILE; |
| ==== |
| ---- QUERY |
| insert into __seq_write values (4, "e", 5.5); |
| ---- CATCH |
| Writing to table format SEQUENCE_FILE is not supported. |
| ==== |
| ---- QUERY |
| # Test writing to mixed format table containing partitions in both supported and |
| # unsupported formats where writing to the partition with supported format should succeed. |
| # Create a table containing both text(supported) and avro(unsupported) partitions. |
| create table __mixed_format_write (id int) partitioned by (part int); |
| ==== |
| ---- QUERY |
| insert into __mixed_format_write partition(part=2000) values(1); |
| ==== |
| ---- QUERY |
| insert into __mixed_format_write partition(part=2001) values(2); |
| ==== |
| ---- QUERY |
| alter table __mixed_format_write partition (part=2001) set fileformat AVRO; |
| ==== |
| ---- QUERY |
| insert into __mixed_format_write partition(part=2000) values(3); |
| ==== |
| ---- QUERY |
| insert into __mixed_format_write partition(part=2001) values(4); |
| ---- CATCH |
| Writing to table format AVRO is not supported. |
| ==== |
| ---- QUERY |
| select id, part from __mixed_format_write where part = 2000; |
| ---- RESULTS |
| 1,2000 |
| 3,2000 |
| ---- TYPES |
| INT,INT |
| ==== |