Support for newer Hive data types - VARCHAR and CHAR - Forum - DataDirect Connect - Progress Community

Support for newer Hive data types - VARCHAR and CHAR

 Forum

Support for newer Hive data types - VARCHAR and CHAR

This question is answered

Hive introduced VARCHAR in 0.12.0 and CHAR in 0.13.0. Are there plans to support these in JDBC and ODBC? (And if yes, approximately when?)  Currently, a table like this:

create table mule

(

  id int,

  name string,

  amount float,

  comment varchar(1024),

  misc binary

) …;

Results in: [DataDirect][Hive JDBC Driver]Unsupported data type in column 3

Verified Answer
  • We do plan to support these types.  Since Hive 0.13 isn't a stable/GA release yet, full support for VARCHAR (ie showing up in getTypeInfo/SQLGetTypeInfo) will almost certainly be released before CHAR.  A service pack is expected over the coming weeks where we'll have completed our certification against Hive 0.12.  As part of this, we'll be resolving the situation you're hitting above.  This will hopefully allow you to successfully use both the CHAR and VARCHAR datatypes, but we may or may not claim full support for these datatypes in the service pack.  

    I would recommend adding these sorts of things to our ideas section:

    community.progress.com/.../default.aspx

All Replies
  • We do plan to support these types.  Since Hive 0.13 isn't a stable/GA release yet, full support for VARCHAR (ie showing up in getTypeInfo/SQLGetTypeInfo) will almost certainly be released before CHAR.  A service pack is expected over the coming weeks where we'll have completed our certification against Hive 0.12.  As part of this, we'll be resolving the situation you're hitting above.  This will hopefully allow you to successfully use both the CHAR and VARCHAR datatypes, but we may or may not claim full support for these datatypes in the service pack.  

    I would recommend adding these sorts of things to our ideas section:

    community.progress.com/.../default.aspx

  • Thanks, this is excellent news!