Narek Karapetian created HIVE-27094:
---------------------------------------

             Summary: Big numbers support for `conv` function 
                 Key: HIVE-27094
                 URL: https://issues.apache.org/jira/browse/HIVE-27094
             Project: Hive
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 4.0.0
            Reporter: Narek Karapetian
            Assignee: Narek Karapetian
             Fix For: 4.0.0


Add support for converting big numbers between different radixes, without an 
overflow.

For example such a query:
{code:java}
SELECT
  conv(9223372036854775807, 36, 16),
  conv(9223372036854775807, 36, -16),
  conv(-9223372036854775807, 36, 16),
  conv(-9223372036854775807, 36, -16)
FROM src tablesample (1 rows); {code}
 Should give a correct result, like:
{code:java}
12DDAC15F246BAF8C0D551AC7   12DDAC15F246BAF8C0D551AC7  D2253EA0DB945073F2AAE539 
  -12DDAC15F246BAF8C0D551AC7
 {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to