Reply
New Contributor
Posts: 2
Registered: ‎01-10-2017

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

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

Expert Contributor
Posts: 125
Registered: ‎07-17-2017

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

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

Cloudera Employee
Posts: 64
Registered: ‎09-28-2015

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

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
New Contributor
Posts: 1
Registered: ‎04-11-2018

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

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

Cloudera Employee
Posts: 19
Registered: ‎11-12-2013

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

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