Thanks for pointing that out – had updated the ResultSetMetadata (returned during queries), but had neglected to update the getColumns() call. I’ve opened https://issues.apache.org/jira/browse/HIVE-5847. ...
Hive / HCatalog Forum
Column length using VARCHAR(n)
In Hive 0.12.0 it’s now possible to create tables with columns identified as VARCHAR(n) where n indicates the maximum length of the column. However when using the JDBC driver the getColumns call shows zero length for such columns. Or when using beeline the !columns command doesn’t show a value for COLUM_SIZE. Is that something that can be addressed?
The Jira that added this functionality https://issues.apache.org/jira/browse/HIVE-5209 implies that it should work in the comment “Support returning varchar length in result set metadata.”
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world