[
https://issues.apache.org/jira/browse/HIVE-27094?focusedWorklogId=846317&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-846317
]
ASF GitHub Bot logged work on HIVE-27094:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 18/Feb/23 20:11
Start Date: 18/Feb/23 20:11
Worklog Time Spent: 10m
Work Description: NarekDW opened a new pull request, #4074:
URL: https://github.com/apache/hive/pull/4074
### What changes were proposed in this pull request?
Add support for converting big numbers between different radixes, without an
overflow.
For example such a query:
```sql
SELECT
conv(9223372036854775807, 36, 16),
conv(9223372036854775807, 36, -16),
conv(-9223372036854775807, 36, 16),
conv(-9223372036854775807, 36, -16)
FROM src tablesample (1 rows);
```
Should give a correct result, like:
```
12DDAC15F246BAF8C0D551AC7 12DDAC15F246BAF8C0D551AC7
D2253EA0DB945073F2AAE539 -12DDAC15F246BAF8C0D551AC7
```
### Why are the changes needed?
Add support for converting big numbers between different radixes, without an
overflow.
### Does this PR introduce _any_ user-facing change?
Yes, it allows users to convert big numbers without an overflow among
different bases.
### How was this patch tested?
By existing unit tests.
Issue Time Tracking
-------------------
Worklog Id: (was: 846317)
Remaining Estimate: 0h
Time Spent: 10m
> 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
> Priority: Minor
> Fix For: 4.0.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
