CQD TRAF_DEFAULT_CHARSET

[Christophe LeRouzo <c....@esgyn.com>]

This is the description for the Hive one, if I change HIVE to HBase, is it
good enough?



Thx

-clr



Category

Hive Tables



Exposed to

Customer

CQD

HIVE_DEFAULT_CHARSET

Contact

Hans

Description

This default tells Trafodion what character set the columns of Hive tables
should have.

Values

ISO88591, UTF8.

Default: UTF8

Usage

Set this to ISO88591 when reading from Hive tables with ISO8859-1 data.

Production usage



Impact



Level



Conflicts/Synergies

HIVE_FILE_CHARSET

How to address the real problem







*From:* Anoop Sharma [mailto:anoop.sharma@esgyn.com]
*Sent:* Wednesday, April 6, 2016 8:42 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* RE: How to specify default charset of column in DDL create table?



cqd traf_default_col_charset ‘UTF8’;







*From:* Dave Birdsall [mailto:dave.birdsall@esgyn.com
<da...@esgyn.com>]
*Sent:* Wednesday, April 6, 2016 8:36 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* RE: How to specify default charset of column in DDL create table?



I had thought that CQD DEFAULT_CHARSET ‘UTF8’ would achieve this.



But I tried it this morning, and it doesn’t seem to work. I still get
ISO88591 by default on CREATE TABLE.



Maybe something is broken.



Dave



*From:* Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
*Sent:* Wednesday, April 6, 2016 8:28 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* How to specify default charset of column in DDL create table?



Hi, all,



When create a table in Trafodion, by default, CHAR/VARCHAR columns will
have ISO88591 as charset. Is there any way to change this default behavior,
so by default, create table will have UTF8 as charset,without explicitly
specify in DDL.



Thanks,

Ming