Column length using VARCHAR(n)

to create new topics or reply. | New User Registration


This topic contains 2 replies, has 2 voices, and was last updated by  ckran 1 year, 8 months ago.

  • Creator
  • #43967


    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 implies that it should work in the comment “Support returning varchar length in result set metadata.”

Viewing 2 replies - 1 through 2 (of 2 total)

You must be to reply to this topic. | Create Account

  • Author
  • #44064


    Thanks, and I see that there is patch. That was fast! It looks to me like I should be able to apply it with

    svn co hive
    cd hive
    export HIVE_HOME=/{{pwd}}
    export PATH=$HIVE_HOME/bin:$PATH

    patch -p0 < HIVE-5847.1.patch

    ant clean package

    And indeed the patch is successfully applied. But the build fails because files are missing from the root:
    build.xml – build-offline.xml – build-common.xml –
    As well as directories ivy, ant and build.xml from these and other directories.


    Jason Dere

    Thanks for pointing that out – had updated the ResultSetMetadata (returned during queries), but had neglected to update the getColumns() call. I’ve opened

Viewing 2 replies - 1 through 2 (of 2 total)
Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.