adnanhamdussalam commented on issue #1451:
URL: https://github.com/apache/cloudberry/issues/1451#issuecomment-3569982076
Hi @robertmu,
PFB the DDL Script:
CREATE TABLE mydata.abc (
dialprefix text NOT NULL,
recordtype text NULL,
effect_date timestamp NOT NULL,
startdate timestamp NOT NULL,
enddate timestamp DEFAULT '2099-01-01 00:00:00'::timestamp without
time zone NULL,
source text NULL,
companycode text NULL,
modernizedprovider text NULL,
tos text NULL,
porttimestamp timestamp NULL,
iso2 text NULL,
dcadmindiv text NULL,
dclocality text NULL,
dcadmindivlocality text NULL,
dcutc text NULL,
rcadmindiv text NULL,
rclocality text NULL,
rcadmindivlocality text NULL,
rcutc text NULL,
portcount int4 NULL,
CONSTRAINT pk PRIMARY KEY (dialprefix, effect_date)
)
DISTRIBUTED BY (dialprefix, effect_date);
CREATE INDEX dialcodeorprefix_idx ON mydata.abc USING btree (dialprefix);
CREATE INDEX abc_dialprefix_idx ON mydata.abc USING btree (dialprefix,
effect_date);
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
