blob: 42258d9a025fc2835fbc5eddef8cebb894358789 [file] [log] [blame]
-- These test attempts to deserialize an Avro file that contains map null values, and the file schema
-- vs record schema have the null values in different positions
-- i.e.
-- fileSchema = [{ "type" : "map", "values" : ["string","null"]}, "null"]
-- recordSchema = ["null", { "type" : "map", "values" : ["string","null"]}]
DROP TABLE IF EXISTS avro_table;
CREATE TABLE avro_table (avreau_col_1 map<string,string>) STORED AS AVRO;
LOAD DATA LOCAL INPATH '../../data/files/map_null_val.avro' OVERWRITE INTO TABLE avro_table;
SELECT * FROM avro_table;
DROP TABLE avro_table;