Support Questions
Find answers, ask questions, and share your expertise

varchar kudu

Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Cloudera Employee

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

 

 

View solution in original post

2 REPLIES 2

Cloudera Employee

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

 

 

View solution in original post

Community Manager

@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. 


Regards,

Vidya Sargur,
Community Manager

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.

Learn more about the Cloudera Community: