Home Forums Hive / HCatalog Column length using VARCHAR(n)

Tagged: 

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

  • Creator
    Topic
  • #43967

    ckran
    Participant

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

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

You must be logged in to reply to this topic.

  • Author
    Replies
  • #44064

    ckran
    Participant

    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 http://svn.apache.org/repos/asf/hive/trunk hive
    cd hive
    export HIVE_HOME=/{{pwd}}
    export PATH=$HIVE_HOME/bin:$PATH

    wget https://issues.apache.org/jira/secure/attachment/12614544/HIVE-5847.1.patch
    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 – build.properties
    As well as directories ivy, ant and build.xml from these and other directories.

    Collapse
    #43973

    Jason Dere
    Participant

    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.

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