- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
varchar kudu
- Labels:
-
Apache Impala
-
Apache Kudu
Created 09-14-2021 03:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 09-21-2021 11:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 09-21-2021 11:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 09-28-2021 10:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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:
