blob: b9bfbcda89f92e588558350903d225fd9cd90797 [file] [log] [blame]
--! qt:dataset:src
set hive.fetch.task.conversion=more;
DESCRIBE FUNCTION hash;
DESCRIBE FUNCTION EXTENDED hash;
EXPLAIN
SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
hash(3), hash(CAST('123456789012' AS BIGINT)),
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
FROM src tablesample (1 rows);
SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
hash(3), hash(CAST('123456789012' AS BIGINT)),
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
FROM src tablesample (1 rows);