| ==== |
| ---- QUERY |
| drop table if exists __text_write; |
| ==== |
| ---- QUERY |
| create table __text_write (i int, s string, d double); |
| ==== |
| ---- QUERY |
| SET COMPRESSION_CODEC=NONE; |
| SET ALLOW_UNSUPPORTED_FORMATS=1; |
| insert into __text_write select 0, "a", 1.1; |
| ==== |
| ---- QUERY |
| SET COMPRESSION_CODEC=DEFAULT; |
| SET ALLOW_UNSUPPORTED_FORMATS=1; |
| insert into __text_write values (1, "b", 2.2); |
| ==== |
| ---- QUERY |
| SET COMPRESSION_CODEC=SNAPPY; |
| SET ALLOW_UNSUPPORTED_FORMATS=1; |
| insert into __text_write values (2, "c", 3.3); |
| ==== |
| ---- QUERY |
| SET COMPRESSION_CODEC=GZIP; |
| SET ALLOW_UNSUPPORTED_FORMATS=1; |
| insert into __text_write values (3, "d", 4.4); |
| ==== |
| ---- QUERY |
| SET COMPRESSION_CODEC=GZIP; |
| SET ALLOW_UNSUPPORTED_FORMATS=0; |
| 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 |
| 1,'b',2.2 |
| 2,'c',3.3 |
| 3,'d',4.4 |
| ---- TYPES |
| INT,STRING,DOUBLE |
| ==== |
| ---- QUERY |
| drop table __text_write; |
| ==== |