HI: i an trying tio creatte ORC, buckered table and insert and delete from hcatalog with pig, i create the table like this: CREATE EXTERNAL TABLE canal_v4(
CODTF string,
CODNRBEENF string,
FECHAOPRCNF date,
CANAL string,
FRECUENCIA int,
year string,
month string)
COMMENT 'A bucketed canal table'
CLUSTERED BY (codnrbeenf) INTO 25 BUCKETS
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
stored as ORC
LOCATION '/RSI/tables/logs/canal_v4'
TBLPROPERTIES ("immutable"="false");
how can i Insert with Pig??? i need somenthing?? is good to use partitioned with bucked?? Thanks
... View more
