varchar kudu

[#1]

Dear Team,

can you please advise why varchar is not acceptable when replicating from Oracle to Kudu though I can create table with varchar on Kudu?

Error from our CDC tool.

Error while writing batch on table impala::cbs.cb_ad_x Reason account_type_v isn't [Type: string], it's varchar. Cause: account_type_v isn't [Type: string], it's varchar

CREATE TABLE cbs.cb_address_xm (
addressid varchar(65535) ,
account_link_code_n BIGINT ,
account_type_v varchar(65535) ,
address_type_n INT ,
account_type varchar(65535) , address_format varchar(65535) ,
address_type INT , building varchar(65535) , city varchar(65535) ,
city_desc varchar(65535) , country varchar(65535) , country_desc varchar(65535) ,
district varchar(65535) , district_desc varchar(65535) , floor varchar(65535) , landmark varchar(65535) , postal_code varchar(65535) , po_code varchar(65535) , street varchar(65535) , street_desc varchar(65535) , sub_locality_code varchar(65535) , sub_locality_desc varchar(65535) , op_insert_date TIMESTAMP , op_update_date TIMESTAMP , state_desc varchar(65535) ,
PRIMARY KEY (addressid) )
PARTITION BY HASH (addressid)
PARTITIONS 16 STORED AS KUDU ;

Regards,

Roshan

[#2 · Accepted solution]

From the error you provided, it looks more like you have ingested data (from oracle) of type string, but want to insert it into a column defined as a varchar. It's not that kudu doesn't accept varchar types,  it's that the data itself is not a varchar type

[#3]

@roshanbi Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.