/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_conv.q.out
text | 190 lines | 186 code | 4 blank | 0 comment | 0 complexity | 00a8dc64288b911c4f02ff3efe61c662 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- PREHOOK: query: DESCRIBE FUNCTION conv
- PREHOOK: type: DESCFUNCTION
- POSTHOOK: query: DESCRIBE FUNCTION conv
- POSTHOOK: type: DESCFUNCTION
- conv(num, from_base, to_base) - convert num from from_base to to_base
- PREHOOK: query: DESCRIBE FUNCTION EXTENDED conv
- PREHOOK: type: DESCFUNCTION
- POSTHOOK: query: DESCRIBE FUNCTION EXTENDED conv
- POSTHOOK: type: DESCFUNCTION
- conv(num, from_base, to_base) - convert num from from_base to to_base
- If to_base is negative, treat num as a signed integer,otherwise, treat it as an unsigned integer.
- Example:
- > SELECT conv('100', 2, 10) FROM src LIMIT 1;
- '4'
- > SELECT conv(-10, 16, -10) FROM src LIMIT 1;
- '16'
- PREHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
- -- Some simple conversions to test different bases
- SELECT
- conv('4521', 10, 36),
- conv('22', 10, 10),
- conv('110011', 2, 16),
- conv('facebook', 36, 16)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/502953018/10000
- POSTHOOK: query: -- conv must work on both strings and integers up to 64-bit precision
- -- Some simple conversions to test different bases
- SELECT
- conv('4521', 10, 36),
- conv('22', 10, 10),
- conv('110011', 2, 16),
- conv('facebook', 36, 16)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/502953018/10000
- 3HL 22 33 116ED2B2FB4
- PREHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
- -- as a two's complement (64-bit)
- SELECT
- conv('-641', 10, -10),
- conv('1011', 2, -16),
- conv('-1', 10, 16),
- conv('-15', 10, 16)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1045444731/10000
- POSTHOOK: query: -- Test negative numbers. If to_base is positive, the number should be handled
- -- as a two's complement (64-bit)
- SELECT
- conv('-641', 10, -10),
- conv('1011', 2, -16),
- conv('-1', 10, 16),
- conv('-15', 10, 16)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1045444731/10000
- -641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
- PREHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
- -- or MAX_LONG (if unsigned)
- SELECT
- conv('9223372036854775807', 36, 16),
- conv('9223372036854775807', 36, -16),
- conv('-9223372036854775807', 36, 16),
- conv('-9223372036854775807', 36, -16)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/901682273/10000
- POSTHOOK: query: -- Test overflow. If a number is two large, the result should be -1 (if signed)
- -- or MAX_LONG (if unsigned)
- SELECT
- conv('9223372036854775807', 36, 16),
- conv('9223372036854775807', 36, -16),
- conv('-9223372036854775807', 36, 16),
- conv('-9223372036854775807', 36, -16)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/901682273/10000
- FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
- PREHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
- -- be NULL. If there is an invalid digit in the number, the longest valid
- -- prefix should be converted.
- SELECT
- conv('123455', 3, 10),
- conv('131', 1, 5),
- conv('515', 5, 100),
- conv('10', -2, 2)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1068643579/10000
- POSTHOOK: query: -- Test with invalid input. If one of the bases is invalid, the result should
- -- be NULL. If there is an invalid digit in the number, the longest valid
- -- prefix should be converted.
- SELECT
- conv('123455', 3, 10),
- conv('131', 1, 5),
- conv('515', 5, 100),
- conv('10', -2, 2)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1068643579/10000
- 5 NULL NULL NULL
- PREHOOK: query: -- Perform the same tests with number arguments.
- SELECT
- conv(4521, 10, 36),
- conv(22, 10, 10),
- conv(110011, 2, 16)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/877878753/10000
- POSTHOOK: query: -- Perform the same tests with number arguments.
- SELECT
- conv(4521, 10, 36),
- conv(22, 10, 10),
- conv(110011, 2, 16)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/877878753/10000
- 3HL 22 33
- PREHOOK: query: SELECT
- conv(-641, 10, -10),
- conv(1011, 2, -16),
- conv(-1, 10, 16),
- conv(-15, 10, 16)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1990388663/10000
- POSTHOOK: query: SELECT
- conv(-641, 10, -10),
- conv(1011, 2, -16),
- conv(-1, 10, 16),
- conv(-15, 10, 16)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1990388663/10000
- -641 B FFFFFFFFFFFFFFFF FFFFFFFFFFFFFFF1
- PREHOOK: query: SELECT
- conv(9223372036854775807, 36, 16),
- conv(9223372036854775807, 36, -16),
- conv(-9223372036854775807, 36, 16),
- conv(-9223372036854775807, 36, -16)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1540368732/10000
- POSTHOOK: query: SELECT
- conv(9223372036854775807, 36, 16),
- conv(9223372036854775807, 36, -16),
- conv(-9223372036854775807, 36, 16),
- conv(-9223372036854775807, 36, -16)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1540368732/10000
- FFFFFFFFFFFFFFFF -1 FFFFFFFFFFFFFFFF -1
- PREHOOK: query: SELECT
- conv(123455, 3, 10),
- conv(131, 1, 5),
- conv(515, 5, 100),
- conv('10', -2, 2)
- FROM src LIMIT 1
- PREHOOK: type: QUERY
- PREHOOK: Input: default@src
- PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1788821246/10000
- POSTHOOK: query: SELECT
- conv(123455, 3, 10),
- conv(131, 1, 5),
- conv(515, 5, 100),
- conv('10', -2, 2)
- FROM src LIMIT 1
- POSTHOOK: type: QUERY
- POSTHOOK: Input: default@src
- POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1788821246/10000
- 5 NULL NULL NULL