kasakrisz commented on code in PR #4696:
URL: https://github.com/apache/hive/pull/4696#discussion_r1420181363


##########
ql/src/test/queries/clientpositive/cast_null_to_complex.q:
##########
@@ -0,0 +1,13 @@
+SET hive.cli.print.header=true;
+
+explain cbo
+select cast(null as map<int, string>), cast(null as array<map<int, string>>), 
cast(null as int), cast(null as struct<f1:array<map<int, string>>, 
f2:struct<a:double, b:string>>);
+explain
+select cast(null as map<int, string>), cast(null as array<map<int, string>>), 
cast(null as int), cast(null as struct<f1:array<map<int, string>>, 
f2:struct<a:double, b:string>>);
+select cast(null as map<int, string>), cast(null as array<map<int, string>>), 
cast(null as int), cast(null as struct<f1:array<map<int, string>>, 
f2:struct<a:double, b:string>>);
+
+
+create table t1 as
+select cast(null as map<int, string>), cast(null as array<map<int, string>>), 
cast(null as int), cast(null as struct<f1:array<map<int, string>>, 
f2:struct<a:double, b:string>>);

Review Comment:
   added q test for ctas from empty source table and a select with a subquery 
producing empty result



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to