0001 CREATE TEMPORARY VIEW various_maps AS SELECT * FROM VALUES (
0002 map(true, false),
0003 map(2Y, 1Y),
0004 map(2S, 1S),
0005 map(2, 1),
0006 map(2L, 1L),
0007 map(922337203685477897945456575809789456, 922337203685477897945456575809789456),
0008 map(9.22337203685477897945456575809789456, 9.22337203685477897945456575809789456),
0009 map(2.0D, 1.0D),
0010 map(float(2.0), float(1.0)),
0011 map(date '2016-03-14', date '2016-03-13'),
0012 map(timestamp '2016-11-15 20:54:00.000', timestamp '2016-11-12 20:54:00.000'),
0013 map('true', 'false', '2', '1'),
0014 map('2016-03-14', '2016-03-13'),
0015 map('2016-11-15 20:54:00.000', '2016-11-12 20:54:00.000'),
0016 map('922337203685477897945456575809789456', 'text'),
0017 map(array(1L, 2L), array(1L, 2L)), map(array(1, 2), array(1, 2)),
0018 map(struct(1S, 2L), struct(1S, 2L)), map(struct(1, 2), struct(1, 2))
0019 ) AS various_maps(
0020 boolean_map,
0021 tinyint_map,
0022 smallint_map,
0023 int_map,
0024 bigint_map,
0025 decimal_map1, decimal_map2,
0026 double_map,
0027 float_map,
0028 date_map,
0029 timestamp_map,
0030 string_map1, string_map2, string_map3, string_map4,
0031 array_map1, array_map2,
0032 struct_map1, struct_map2
0033 );
0034
0035 SELECT map_zip_with(tinyint_map, smallint_map, (k, v1, v2) -> struct(k, v1, v2)) m
0036 FROM various_maps;
0037
0038 SELECT map_zip_with(smallint_map, int_map, (k, v1, v2) -> struct(k, v1, v2)) m
0039 FROM various_maps;
0040
0041 SELECT map_zip_with(int_map, bigint_map, (k, v1, v2) -> struct(k, v1, v2)) m
0042 FROM various_maps;
0043
0044 SELECT map_zip_with(double_map, float_map, (k, v1, v2) -> struct(k, v1, v2)) m
0045 FROM various_maps;
0046
0047 SELECT map_zip_with(decimal_map1, decimal_map2, (k, v1, v2) -> struct(k, v1, v2)) m
0048 FROM various_maps;
0049
0050 SELECT map_zip_with(decimal_map1, int_map, (k, v1, v2) -> struct(k, v1, v2)) m
0051 FROM various_maps;
0052
0053 SELECT map_zip_with(decimal_map1, double_map, (k, v1, v2) -> struct(k, v1, v2)) m
0054 FROM various_maps;
0055
0056 SELECT map_zip_with(decimal_map2, int_map, (k, v1, v2) -> struct(k, v1, v2)) m
0057 FROM various_maps;
0058
0059 SELECT map_zip_with(decimal_map2, double_map, (k, v1, v2) -> struct(k, v1, v2)) m
0060 FROM various_maps;
0061
0062 SELECT map_zip_with(string_map1, int_map, (k, v1, v2) -> struct(k, v1, v2)) m
0063 FROM various_maps;
0064
0065 SELECT map_zip_with(string_map2, date_map, (k, v1, v2) -> struct(k, v1, v2)) m
0066 FROM various_maps;
0067
0068 SELECT map_zip_with(timestamp_map, string_map3, (k, v1, v2) -> struct(k, v1, v2)) m
0069 FROM various_maps;
0070
0071 SELECT map_zip_with(decimal_map1, string_map4, (k, v1, v2) -> struct(k, v1, v2)) m
0072 FROM various_maps;
0073
0074 SELECT map_zip_with(array_map1, array_map2, (k, v1, v2) -> struct(k, v1, v2)) m
0075 FROM various_maps;
0076
0077 SELECT map_zip_with(struct_map1, struct_map2, (k, v1, v2) -> struct(k, v1, v2)) m
0078 FROM various_maps;