Release of Oushu HAWQ++ version 2.2.0
Oushu HAWQ++ 2.2.0 has the following new feature enhancements over Oushu HAWQ++ 2.1.1:
Added support for non-ASCII strings or strings longer than 1 as delimiters to csv and text file formats (only single ASCII characters were supported as delimiters in 2.1.1). Involves copy statements and create external statements.
Key Bug fixes
multi-character delimiter support example table creation and query create writable external table exttable_option_multibytesDelimiter_w0(p varchar, q varchar) location ('hdfs://localhost:8020/hawq_default/exttable_option_multibytesDelimiter_w0.csv') format 'csv'(delimiter '^_^' escape '&' null 'NULL') encoding 'gbk';insert into exttable_option_multibytesDelimiter_w0 values('&','&');insert into exttable_option_multibytesDelimiter_w0 values ('delimiter ','^_^');insert into exttable_option_multibytesDelimiter_w0 values ('& delimiter ','&^_^');insert into exttable_option_multibytesDelimiter_w0 values ('middle','country ');insert into exttable_option_multibytesDelimiter_w0 values ('chi','na ');select * from exttable_option_multibytesDelimiter_w0; p | q----------+------ & | & separator | ^_^ & Separator | &^_^ | Guochi | na(5 rows) csv file content generated &^_^& delimiter ^_^"^_^"& delimiter ^_^"&&&^_^"^_^chi^_^na non-ASCII delimiter support example table creation and query create writable external table exttable_option_multibytesDelimiter_w0(p varchar, q varchar) location ('hdfs://localhost:8020/hawq_default/exttable_option_multibytesDelimiter_w0.csv') format 'csv'(delimiter 'delimiter' escape '&' null 'NULL') encoding 'gbk';insert into exttable_option_multibytesDelimiter_w0 values('&','&');insert into exttable_option_multibytesDelimiter_w0 values ('delimiter ','^_^');insert into exttable_option_multibytesDelimiter_w0 values ('& delimiter ','&^_^');insert into exttable_option_multibytesDelimiter_w0 values ('middle','country ');insert into exttable_option_multibytesDelimiter_w0 values ('chi','na ');select * from exttable_option_multibytesDelimiter_w0; p | q---------+------ & | & separator | ^_^ & Separator| &^_^ | Guochi | na(5 rows) corresponding csv file content & separator &"separator" separator ^_^"&& separator" separator &^_^separator country chi separator na
