Support Questions

Find answers, ask questions, and share your expertise

What is hive maximum table PARAM_VALUE" TYPE varchar(64000)? I want to set maximum, please share the maximum numbers.

New Contributor

hive=# ALTER TABLE "PARTITION_PARAMS" ALTER COLUMN "PARAM_VALUE" TYPE varchar(64000);

ALTER TABLE

hive=# \d "PARTITION_PARAMS"

Table "public.PARTITION_PARAMS"

Column | Type | Modifiers

-------------+--------------------------+---------------------------------

PART_ID | bigint | not null

PARAM_KEY | character varying(256) | not null

PARAM_VALUE | character varying(64000) | default NULL::character varying

1 REPLY 1

It's bad form to post an identical question over again in the space of twenty-four hours. The second post of the above question was removed from HCC's Community Help track Thu Aug 1 04:06 UTC 2019.

Bill Brooks, Community Moderator
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.