hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Chang <lei_ch...@apache.org>
Subject Re: why hawq off columnorientied table by default?
Date Mon, 29 Feb 2016 01:19:24 GMT
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, yin.zhb@163.com <yin.zhb@163.com> 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]$
>
> ------------------------------
> yin.zhb@163.com
>

Mime
View raw message