Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to create Kudu table with Decimal or Varchar data type columns?

How to create Kudu table with Decimal or Varchar data type columns?

New Contributor

Hi All,

 

I'd like to check with you, since you can not create Decimal/Varchar data type column through Impala. Is there any other way to do it? Appreciate if you share some detailed approaches.

 

Furthermore, if my application is designed to use Impala as query interface with Kudu, is there any work around to create columns for similar precision and data type?

 

Thanks

4 REPLIES 4

Re: How to create Kudu table with Decimal or Varchar data type columns?

Expert Contributor

Hi,

May be the Decimal and Varchar types are not supported in KUDU but you can use INT,FLOAT,DOUBLE and STRING to store any kind of data like alternatives of (Decimal/Varchar).

Re: How to create Kudu table with Decimal or Varchar data type columns?

Expert Contributor
That's correct. Please see
https://www.cloudera.com/documentation/kudu/latest/topics/kudu_known_issues.html#schema_design_limit...
which notes:

- DECIMAL, CHAR, VARCHAR, DATE, and complex types such as ARRAY are not
supported.

We are currently working on DECIMAL and hope to have it supported in an
upcoming release.

-Todd
Highlighted

Re: How to create Kudu table with Decimal or Varchar data type columns?

New Contributor

if we can support float, what is issue in supporting decimal? 

Re: How to create Kudu table with Decimal or Varchar data type columns?

Contributor
Although DECIMAL and FLOAT do seem rather similar, their implementations are entirely different. So, just because we support FLOAT doesn't mean we can get DECIMAL support "for free"; that's net new code that must be written.