检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn

不再显示此消息

  • Intl-English
    International
    • English
    • Bahasa Indonesia
    • Español
    • Português
    • Türkçe
    • عربي
    • ไทย
    • 简体中文
    • 日本語
    中国站
    • 简体中文
    Europe
    • English
    • Deutsch
    • Español
    • Français
    • Nederlands
  • Huawei Cloud
    • Activities
    • Products
    • Solutions
    • Pricing
    • KooGallery
    • Partners
    • Developers
    • Support
    • About Us
        Show more results for “”
        • Contact Us
        • Documentation
        • Console
          • My Account
          • Billing & Costs
          • Service Tickets
          • Unread Messages
          • Console
          • Partner Center
          • Sign InSign Up
        • Sign In
        • Sign Up
          • My AccountComplete Sign Up
          • Billing & Costs
          • Service Tickets
          • Unread Messages
          • Console
          • Partner Center
          • Log Out
        Cancel
            Help Center/Data Lake Insight/SQL Syntax Reference (Ally Region)/Spark SQL Syntax Reference/Built-in Functions/Mathematical Functions
            Updated on 2026-01-09 GMT+08:00
            View PDF
            Share
            • x.com
            • Facebook
            • LinkedIn
            • Copy link

            Copied.

            Mathematical Functions

              Overview
              abs
              acos
              asin
              atan
              bin
              bround
              cbrt
              ceil
              conv
              cos
              cot1
              degrees
              e
              exp
              factorial
              floor
              greatest
              hex
              least
              ln
              log
              log10
              log2
              median
              negative
              percentlie
              percentlie_approx
              pi
              pmod
              positive
              pow
              radians
              rand
              round
              shiftleft
              shiftright
              shiftrightunsigned
              sign
              sin
              sqrt
              tan
            Parent Topic: Built-in Functions

            Previous topic: upper/ucase

            Next topic: Overview

            Feedback

            Was this page helpful?

            HelpfulNot helpful
            Provide feedback

            Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

            The system is busy. Please try again later.

            Which of the following issues have you encountered?

            Content is inconsistent with the product UI
            Unclear descriptions
            Lack of examples or code
            Incorrect steps
            Can't find what I need
            Lack of best practices

            Feedback (optional)

            0/500

            Select at least one type of issue, and enter your comments or suggestions.

            Enter a maximum of 500 characters.

            SubmitCancel

            For any further questions, feel free to contact us through the chatbot.

            Chatbot
            Contact SalesAfter-SalesSelf Service
            • Site Terms
            • Privacy Statement

            Explore Huawei Cloud

            Why UsCustomer StoriesTrust CenterLegalPress Releases

            Featured Services

            Elastic Cloud Server (ECS)Elastic IP (EIP)RDS for MySQLElastic Volume Service (EVS)MapReduce Service (MRS)

            Service and Support

            DocumentationContact UsPublic NoticesSupport PlansService Health Dashboard

            Account and Payment

            Top UpInvoicesBilling CenterMy AccountPayment Method

            Quick Links

            Huawei CorporateHuawei EnterpriseHuawei Consumer BusinessHuawei Developers

            © 2026, Huawei Cloud Computing Technologies Co., Ltd. and/or its affiliates. All rights reserved.

            • Site Terms
            • Privacy Statement