Apache Hive Logo Apache Hive
  • Releases
  • Documentation
    • Latest
    • Javadocs
    • Language Manual
  • General
    • License
    • Privacy Policy
    • Powered by
  • Development
    • Getting Started
    • Quickstart with Docker
    • Design Docs
    • Hive JIRA
    • Hive Developer FAQ
    • Version Control
  • Community
    • Becoming A Committer
    • How To Contribute
    • Resources
    • Meetings
    • Mailing Lists
    • Issue Tracking
    • People

    • By Laws
    • How To Release
  • Blogs
  • ASF
    • Donations
    • Sponsorship
    • Thanks
    • Website
  1. Home
  2. Documentation
  3. Apache Hive : HPL/SQL - CHAR Function

Apache Hive : HPL/SQL - CHAR Function

Last updated: August 12, 2026

Table of Contents

  • Apache Hive : HPL/SQL - CHAR Function

Apache Hive : HPL/SQL - CHAR Function

CHAR function converts a number to string.

Syntax:

CHAR(num_expression); 

Return Type:

STRING

Example 1:

CHAR(1000); 
--
1000

Compatibility: IBM DB2

See also:

  • TO_CHAR Function

Feedback

Was this page helpful? Let us know how we can improve.

Edit this page on GitHub
Apache Software Foundation

Apache is a non-profit organization helping open-source software projects released under the Apache license and managed with open governance and privacy policy. See upcoming Apache Events. If you discover any security vulnerabilities, please report them privately. Finally, thanks to the sponsors who donate to the Apache Foundation.

The contents of this website are © 2026 Apache Software Foundation under the terms of the Apache License v2. Apache Hive and its logo are trademarks of the Apache Software Foundation.