Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.