Hi, if column oriented tables are not used properly, it may overwhelm hdfs since it might lead to too many files. So it is disabled by default.
Cheers Lei On Sun, Feb 28, 2016 at 10:39 PM, [email protected] <[email protected]> wrote: > hi,all: > this days i am testing hawq(1.3.1) ,I got some questions: > by default,hawq off the column_orientied_table,why? > > [gpadmin@stars1 test]$ > [gpadmin@stars1 test]$ psql -U gpadmin -d hawq -f create_table.sql > > psql:create_table.sql:48: ERROR: Column oriented tables are deprecated. To > enable it, set GUC gp_enable_column_oriented_table on. > [gpadmin@stars1 test]$ gpconfig -s gp_enabled_column_orientied_table > > 20160228:21:45:40:026806 gpconfig:stars1:gpadmin-[ERROR]:-Failed to retrieve > GUC information, guc does not exist: gp_enabled_column_orientied_table > [gpadmin@stars1 test]$ gpconfig -s gp_enable_column_oriented_table > Values on all segments are consistent > GUC : gp_enable_column_oriented_table > Master value: off > Segment value: off > [gpadmin@stars1 test]$ > > ------------------------------ > [email protected] >
