[jira] [Created] (HIVE-28825) Support conversion of complex types to String

["Soumyakanti Das (Jira)" <ji...@apache.org>]

Soumyakanti Das created HIVE-28825:
--------------------------------------

             Summary: Support conversion of complex types to String
                 Key: HIVE-28825
                 URL: https://issues.apache.org/jira/browse/HIVE-28825
             Project: Hive
          Issue Type: Improvement
          Components: Hive
    Affects Versions: 4.0.1
            Reporter: Soumyakanti Das
            Assignee: Soumyakanti Das


Currently functions like {{md5()}} fails on complex types. For example:
{noformat}
create table boolarray2(id int, txt string, num int, flag boolean);
insert into  boolarray2 values
  (1, 'one',   5, 'FALSE'),
  (2, 'two',  14, 'TRUE'),
  (3,  NULL,   3, 'FALSE');

select md5(s) csum from (select struct(*) s from default.boolarray2) s;

Error: Error while compiling statement: FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments 's': No matching method for class org.apache.hadoop.hive.ql.udf.UDFMd5 with (struct<col1:int,col2:string,col3:int,col4:boolean>). Possible choices: _FUNC_(binary)  _FUNC_(string) (state=42000,code=10014){noformat}



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